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
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";
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: