Using AXL Executesqlqueryreq() to pull CUCM Service Parameters

Unanswered Question
May 13th, 2009

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?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
lusbyr Thu, 05/14/2009 - 16:08

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 Thu, 05/14/2009 - 17:41

probably the hostname of the cucm server

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



This Discussion