Using AXL Executesqlqueryreq() to pull CUCM Service Parameters

[lusbyr]

I have been given the request by maintainers of CUCM in our company to pull service parameter data from CUCM servers. This would be for both 4.2(3)and 6.1(3). I have been looking through the Data Dictionary, but have had difficultly finding the correct SQL queries to perform this. Has anyone done this before? Can someone provide an example AXL SQL query to use to get the Service Parameter data?

[Sascha Monteiro]

Hi,

There is an axl element;

getServiceParameter

hth

[lusbyr]

Thanks, that parameter appears to be what is desired. The AXL query requires the nodeName to be specified, what is the format of the nodeName?

[Sascha Monteiro]

probably the hostname of the cucm server

you could do listProcessNodesByService first to see where the service is running, then do listServiceParameters

hth