CUCM SQL Query for Services

[Najil PP]

Hi Experts,

Looking for an information here. I need to get the list of all services in CLI with their elapsed time like the way we get it in our RTMT. utils service list does show the services but need their time elapsed as well. is there any SQL command we can run to accomplish this.

[Valeriy Kuznetsov]

There's no way to fetch such data with SQL query because it is not stored in regular CUCM database.

What you can do is to query some feature/network service status via SNMP protocol, refer to Managed Service Guide documentation.

[Najil PP]

Thanks for the response.

can you or someone guide me how to get this using SNMP to pull a certain details of services such as activated since last 48 hrs or something similar.