[cisco-voip] SQL question on UCM 6.01

[Tim Reimers]

Hi folks --
 
I'm trying to work out how to pull some data out of our CM.
Running 6.01sr13
 
If you've used the AXL SQL toolkit that comes with UCM 6.01, you've
probably seen this line in 'sample.xml'
 
"<sql query="select * from device where name like 'SEP001BD43291E9' "/>"
 
 
You also probably know that this line
 
"java -cp
.\classes;.\lib\saaj-api.jar;.\lib\saaj-impl.jar;.\lib\mail.jar;.\lib\ac
tivation.jar;.\lib\jaxm-api.jar;.\lib\jaxm-runtime.jar;.\lib\xercesImpl.
jar;.\lib\xml-apis.jar AxlSqlToolkit -username=******* -password=*******
-host=<ip-of-publisher> -input=sample.xml -output=sample-response.xml"

would pull out the data for phone SEP001BD43291E9
 
 
 
What I'm trying to figure out without much success is how to query for a
list of phones.
 
This is the full 'sample.xml' file:
 
"<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
 <!ELEMENT data (sql+)>
 <!ELEMENT sql EMPTY>
 <!ATTLIST sql
 query CDATA #IMPLIED
  update CDATA #IMPLIED
>
]>
<data>
<sql query="select * from device where name like 'SEP001BD43291E9' "/>
</data>"
 
 
Simply doing more lines like:
 
<sql query="select * from device where name like 'SEP001BD43291E9' "/>
<sql query="select * from device where name like 'SEP001BD445d64 "/>
<sql query="select * from device where name like 'SEP001BD46F3C4' "/>
 
works -- but there's excess garbage in the resulting XML file.
 
What I want to do is something like this:
 
<sql query="select * from device where name like 'SEP001BD43291E9' or
like 'SEP001BD445d64' or like 'SEP001BD4A3C4B7' "/>
 
But using "or like" doesn't work.
 
Nor does "like" or "," or anything else that I can think of.
 
 
I can't find a reference on Cisco's site for the SQL syntax of the
Informix (?) engine being used.
Other documents exist, like a data dictionary (handy) --
 
but I've not been able to find how to write a simple select query with
multiple matches
 
I can do this all day long in MySQL or MSSQL --- but Informix must be
different yet from either of those
 
Anyone got any ideas?
 
 
 
 
 
 
Tim Reimers
Systems Analyst II
Information Technology Services
City of Asheville
70 Court Plaza
Asheville, NC 28801
phone - 828-259-5512
treimers at ashevillenc.gov <mailto:timreimers at ashevillenc.gov> 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090812/37b3fdb8/attachment.html>