All Info from userid1 run sql select * from enduser where userid='userid1'
userid selective info for multiple users run sql select eu.userid,eu.islocaluser,eu.status, eu.mailid, eu.directoryuri, dpc.name as ad_filter from enduser eu left join directorypluginconfig dpc on eu.fkdirectorypluginconfig = dpc.pkid where eu.status=1 and dpc.name="LDAP_Directory" and userid='userid1' or email@example.com'
total_users_clusterwide run sql select count (*) as total_users_clusterwide from enduser
active_ldap_users_clusterwide run sql select count (*) as active_ldap_users_clusterwide from enduser where status = '1'
inactive_users_clusterwide run sql select count (*) as inactive_users_clusterwide from enduser where status = 2
clusterwide_inactive_active_total_users run sql select count (userid) as clusterwide_inactive_active_total_users from enduser where status = '1' union select count (*) as inactive_users_clusterwide from enduser where status = 2 union select count (*) as total_users_clusterwide from enduser
total_users_clusterwide from enduser
Count of Active Users and LDAP_Directory run sql select dpc.name as ldap_directory_name, count (*) as no_of_active_users_in_directory from enduser eu left join directorypluginconfig dpc on eu.fkdirectorypluginconfig = dpc.pkid where eu.status=1 and dpc.name="LDAP_Directory" group by dpc.name
Count of InActive Users and LDAP_Directory run sql select dpc.name as ldap_directory_name, count (*) as no_of_inactive_users_in_directory from enduser eu left join directorypluginconfig dpc on eu.fkdirectorypluginconfig = dpc.pkid where eu.status=2 and dpc.name="LDAP_Directory" group by dpc.name
LDAP Directory and their counts run sql select directorypluginconfig.name, count(directorypluginconfig.name) as no_of_users from enduser eu left join directorypluginconfig directorypluginconfig on eu.fkdirectorypluginconfig = directorypluginconfig.pkid group by directorypluginconfig.name order by directorypluginconfig.name
LDAP Directory and their schedules run sql select pkid,nextexectime from directorypluginschedule
LDAP Directory and their schedules and detailed info run sql select directorypluginconfig.name as ldap_directory_name,directorypluginconfig.syncnow as syncnow, directorypluginconfig.fullsyncstatus as sync_status, directorypluginconfig.connectedldaphost as ldap_hostname, directorypluginschedule.nextexectime as sync_schedule, ldapfilter.filter as ldap_filter from directorypluginconfig join directorypluginschedule on directorypluginconfig.pkid = directorypluginschedule.fkdirectorypluginconfig join ldapfilter on directorypluginconfig.fkldapfilter = ldapfilter.pkid order by directorypluginconfig.name
convert ldap user to manual run sql update enduser set fkdirectorypluginconfig=NULL where userid=’userid2′
Understanding Media Negociation in Interworking / Traversal Call : SIP <-> H323 through Expressway. Inside SDP and H245. Both signaling and Media goes through the Expressway so the IP address of expressway is offered to both SIP and H.323 endpoin...
Sometimes you troubleshoot the phone presence status issue, or you are wondering how the status is retrieved by IMP, the best place to start is to look at the SIP Publish message sent by the CUCM to IMP, Capture the SIP Publish message using wireshark, in...
We have a PCCE CUIC 12.5, with more than 820 agents. While running the Agent Login Logout Historical Report only allows us to choose 500 agents, so we have to run the report twice and choose the remaining agents. This consumes more time, and effort, and c...
I have been facing couple of issues with Cisco 8861 phones deployed at a customer site on an HCS setup via a voice vpn.
1. Customer is facing voice delay of 6-8 secs on both wired and wireless. The issue is observed at the start of call where ca...
I have been able to successfully get my Cisco 7960 phone registered with my self-hosted PBX system but there is an issue I am running into.The log from my TFTP server is: Read request for file <SEP<MAC>.cnf.xml>. Mode octet [14/05 1...