Reporting on Jabber chat rooms and their moderators?

[wrhale]

Is there a way to create a report of all Jabber chat rooms including the name of the moderators for those rooms?

[christoph.hable]

I am afraid that you can only realize this with SQL queries... You can find some details and sample SQL queries in the following Cisco whitepaper and in the official guideline for the database setup:

http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/BestPractices/Cisco_IMP_ExtDB_WP.pdf

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/10_5_1/CUP0_BK_DA667F7C_00_database-setup-guide-imp-105/CUP0_BK_DA667F7C_00_database-setup-guide-imp-105_chapter_0100.html

I am sure someone played with it already and can post some working queries... ;)

In the meantime I will try it out and come back to you with some feedback.

Regards,

Christoph

[wrhale]

Thank you!  Your reply gets me headed in the right direction.

Hopefully some nice people will post some working scripts (as you mentioned) and I'll be that much ahead of the game.

[Varundeep Chhatwal]

Hello

It took me some time in my lab to make out the command ;)

try the below :

select room_jid,real_jid,role from tc_users  where role like 'moderator%'

i hope this helps

Regards

Varundeep