It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Hipchat integrations by rooms


We would like to get a list from our integrations per hipchat rooms. How can we do it?



1 answer

0 votes
AhmadDanial Atlassian Team Nov 19, 2018

Hello there, Gergely.

Can I first confirm if you are using HipChat Cloud or rather HipChat Server / Data Center? If you are on HipChat Server, you can pull the information from the database with reference to the KB below:

For HipChat Data Center on the other hand, you need to use a different approach.

Once you obtain access to your server node backend, switch to root user:

sudo dont-blame-hipchat

Access the database:

PGPASSWORD=$(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.pass') psql -h $(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.servers[0]' | awk -F: '{print $1}') -U $(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.user') -d $(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.schema')

Pull the information from the database using the command below:

SELECT 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 = oc.addon_id LEFT JOIN rooms r ON oc.room_id =;

I could not find any specific information to pull the information from HipChat Cloud apart from the web interface. For example:


Let me know how it goes on your end. Thanks.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Hipchat

Hipchat Cloud and Stride have reached End of Life (updated)

All good things come to an end - thanks to all our customers and partners who have been along the Hipchat and Stride journey with us.  As of Feb 15th 2019, Hipchat Cloud and Stride have reached ...

35,198 views 9 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you