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

[jialinli]

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

[jialinli]

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

[npetrele]

They should be compatible for this particular query, yes.