How To List Integrations Installed in All Rooms from Hipchat Server
This is for an outdated version of Hipchat Server
This article applies to a version of Hipchat Server which will be deprecated soon. After that period the version will no longer be supported.
You should upgrade to a more recent version of Hipchat Server as soon as you can to take advantage of new features, and security and bug fixes.
目的
An admin wishes to review which integrations are installed in each room on a Hipchat Server using the command line.
ソリューション
- Gain access to the server's terminal/command-line.
Log in to the hipchat database:
DBPASS=$(awk '/"pass"/ {gsub(/[",]/,"");print $2}' /hipchat/config/site.json) && mysql -uroot -p$DBPASS hipchat
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
最終更新日: 2018 年 1 月 19 日
Powered by Confluence and Scroll Viewport.