About kmdurrett

kmdurrett · 02-11-2019

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...

kmdurrett · 09-16-2016

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...

kmdurrett · 02-14-2019

Thanks, that's perfect!!

kmdurrett · 09-20-2016

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...

Member Since	‎03-29-2006 07:28 AM
Date Last Visited	‎07-02-2020 10:53 AM
Posts	4

User Statistics

User Activity

UCCE 11.0 SQL Query MaxAgents with Multiple PG's

IM&P 9.1 Watchers CSCup37413

Re: UCCE 11.0 SQL Query MaxAgents with Multiple PG's

with 30000+ results and 1200+