How I can retrieve MAC address,description,device pool,IP from CUCM6?

Version 1
    This document was generated from CDN thread

    Created by: Alexandr Kulbida on 17-03-2009 01:11:09 PM
    Hello.
    Early in CCM 5 I used SQL Queries and I didn't have any problems...but now..
     
    I have seen that there are a lot of material for AXL. Developer Guide... etc.
     
    Can somebody simply explain me by steps what I need to retreive info that I want?
    Maybe somebody can provide me prepared file for this task?
     
    Thank you a lot!

    Subject: RE: How I can retrieve MAC address,description,device pool,IP from CUCM6?
    Replied by: David Staudt on 17-03-2009 07:33:53 PM
    Probably folks will be unable to provide complete working code for your project
     
    If you have specific questions based on your reading and experimentation with the AXL documents and sample code, please let us know.  The docs/samples could be improved of course, and we're working to do so, so we're glad to provide this community/self-help forum.
     
    Note most of the underlying technology used by AXL is standards-based, so the greater web will be your source for info and support regarding XML, SOAP, WSDL, and other such technologies.  Questions specific to the Cisco implementation are appropriate here.

    Subject: RE: How I can retrieve MAC address,description,device pool,IP from CUCM6?
    Replied by: Alexandr Kulbida on 23-03-2009 11:53:37 AM
    In CCM 4 I used this SQL to retrieve needed info from MSSQL
     
    select d.name as 'Device', d.Description as 'Description',
    n.dNOrPattern as 'DN', rp.name as 'Partition'
    from Device as d
    inner join DeviceNumPlanMap as dmap on dmap.fkDevice = d.pkid
    inner join NumPlan as n on n.pkid = dmap.fkNumPlan
    inner join RoutePartition as rp on rp.pkid = n.fkRoutePartition
    where d.name like 'SEP%'
    order by n.dNOrPattern, rp.name

     
    I tried to use this SQL in sample.xml to AXLToolkit but I receive error response.
     
    I think its a problem with Informix DB syntax.
     
    Can somebody provide me something like this SQL that I used int CCM 4 ??
     
    Thank you!

    Subject: RE: How I can retrieve MAC address,description,device pool,IP from CUCM6?
    Replied by: Sascha Monteiro on 24-03-2009 12:45:43 AM
    Hi,
     
    Just remove the quotes from the as statements, this worked for me
    (you can perform this via ssh cli !)
    run sql select d.name as DeviceName, d.Description as Description ,n.dNOrPattern as DN, rp.name as Partition from Device as d join DeviceNumPlanMap as dmap on (dmap.fkDevice = d.pkid) join NumPlan as n on (n.pkid = dmap.fkNumPlan) join RoutePartition as rp on (rp.pkid = n.fkRoutePartition) where d.name like 'SEP%' order by n.dNOrPattern, rp.name
     
    hth
    Sascha