cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
870
Views
1
Helpful
2
Replies

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

jialinli
Level 1
Level 1

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

2 Replies 2

jialinli
Level 1
Level 1

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

They should be compatible for this particular query, yes. 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: