Using executeSQLQuery to find "Active Load ID" of a specific device

jialinli — Thu, 25 Aug 2016 03:29:33 GMT

Hi,

I want to read "Active Load ID" of a specific device via JAX-WS based on this demo https://developer.cisco.com/site/axl/learn/how-to/axl-java-sample-application.gsp

I found "ExecuteSQLQueryReq.java" and "ExecuteSQLQueryRes.java" under package "com.cisco.axl.api._11", and also found a similar discussion created 2 years ago: ExecuteSQL returning row:null with JAX-WS

I saw the following sql query and wonder how to find the related tables which can help me get active load ID from CUCM:

String sSQLQuery = "select processnodeservice.servername from processnodeservice,typeservice where processnodeservice.tkservice = typeservice.enum and typeservice.processname='ctftp'";

Looking forward to your advice, thank you~

Thanks,

Jialing

Re: Using executeSQLQuery to find "Active Load ID" of a specific device

jialinli — Thu, 25 Aug 2016 07:29:34 GMT

PS： I've found CUCM 10.5(1) Database Dictionary already, but I want to run my script on CUCM11.0, are they compatible?

Re: Using executeSQLQuery to find "Active Load ID" of a specific device

npetrele — Mon, 29 Aug 2016 21:15:43 GMT

They should be compatible for this particular query, yes.

topic Re: Using executeSQLQuery to find "Active Load ID" of a specific device in Management

Using executeSQLQuery to find "Active Load ID" of a specific device

Re: Using executeSQLQuery to find "Active Load ID" of a specific device

Re: Using executeSQLQuery to find "Active Load ID" of a specific device