cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
428
Views
0
Helpful
0
Comments
cdnadmin
Level 11
Level 11
This document was generated from CDN thread

Created by: Brian McCormick on 09-07-2010 11:03:57 AM
Hi,
I would like to run a simple query on the CM database to find devices associated to specific application users.
I have downlaoded the AxlSqlToolkit and checked out the java. Does anyone have a c# version of this written they would like to share?
Thanks,
Brian

Subject: RE: C# Select Query Example
Replied by: Chris Bertrand on 19-07-2010 08:36:27 AM
Hi Brian,
 
There's a file with the database structure in the documents section. That will help you out with any other queries. As for this one it should look some thing like
 
http://developer.cisco.com/c/document_library/get_file?folderId=192390&name=DLFE-25634.pdf

ExecuteSQLQueryReq sqlreq = new ExecuteSQLQueryReq
sqlreq.sql = "select n.dnorpattern dn, rp.name partition, d.name, d.description from ((((device d inner join devicenumplanmap m on d.pkid = m.fkdevice) inner join numplan n on n.pkid = m.fknumplan) inner join NumPlan p on m.fknumplan = p.pkid) inner join routePartition rp on p.fkRoutePartition = rp.pkid) where d.name like 'SEP%' and numplanindex = 1 order by n.dnorpattern";

ExecuteSQLQueryRes sqlres = axlService.executeSQLQuery(sqlreq);
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:

Quick Links