12-12-2016 04:54 PM - edited 03-17-2019 06:33 PM
Is there a way to create a report of all Jabber chat rooms including the name of the moderators for those rooms?
12-13-2016 04:39 AM
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:
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
12-13-2016 10:33 AM
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.
12-13-2016 12:11 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide