Purpose

An admin wishes to review which integrations are installed in each room on a Hipchat Server using the command line. 

Solution

1. Gain access to the server's terminal/command-line.

2. Log in to the hipchat database:

   DBPASS=$(awk '/"pass"/ {gsub(/[",]/,"");print $2}' /hipchat/config/site.json) && mysql -uroot -p$DBPASS hipchat

3. Run the following query to list the integrations installed in all rooms:

   SELECT a.name AS "Name",
       a.description AS "Description",
       a.plugin_key AS "Key",
       a.capabilities_url AS "URL",
       oc.allowed_scopes AS "Scopes",
       r.pretty_name AS "Room"
   FROM addons a
   LEFT JOIN oauth_clients oc ON a.id = oc.addon_id
   LEFT JOIN rooms r ON oc.room_id = r.id\G