Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Hey Guys,
Looking for some help with a query. Can i get some help with a query that will provide the MaxNumberLoggedOnAgentsToHalf results for a specific time period that combines multiple PG's into one output? The query i'm running now will only p...
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCup37413 (IM&P doesn't remove AD/CUCM deleted users from Rosters)
Following the work around with the following query
run sql select contact_jid from rosters r where NOT EXISTS (select * from users u wh...
with 30000+ results and 1200+ unique entries I was able to delete some of the unique entries using
run sql delete from rosters where contact_jid = 'yourcontact@yourdomain.org'
once the number of entries was below 23000, I was able to successfully del...