Can I used Administration XML to retrieve the DHCP configuration?

Version 1
    This document was generated from CDN thread

    Created by: VALERIY PAVLICHENKO on 17-02-2009 05:02:10 PM
    Hello,
     
    Is it possible to use SOAP/XML to request the DHCP configuration from Call Manager version 7.0?
     
    Thanks in advance,
    Val

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: David Staudt on 17-02-2009 05:17:00 PM
    Would this be for individual phones or UCM nodes themselves?  What specific DHCP info do you need?
     

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: VALERIY PAVLICHENKO on 17-02-2009 06:33:05 PM
    Hi David,
     
    It is for the UCM nodes (version 7)  themselves, to retrieve the DHCP servers and DHCP subnets configuration details.
     
    Thanks,
    Val

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: David Staudt on 17-02-2009 10:19:18 PM
    CM7 includes <addDHCPServer> and <addDHCPSubnet> requests, as well as their update/remove counterparts.  Looks like these are not available in prior versions.

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: VALERIY PAVLICHENKO on 17-02-2009 10:27:41 PM
    Interesting ...
     
    David, can you please point the the doc URL? I'm looking at:
     
    Chapter 1. Administrative XML (AXL) Programming
    http://www.cisco.com/en/US/customer/docs/voice_ip_comm/cucm/devguide/7_0_1/ccmdvCh1.html
     
    and can not find the dhcp related requests. I guess i'm looking at the wrong doc.
     
    Thanks,
    Val
     

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: David Staudt on 17-02-2009 11:23:39 PM
    I'm looking at the HTML schema "7.0(1) Cisco Unified Communications Manager Admin XML Interface Spec": http://developer.cisco.com/c/document_library/get_file?folderId=192390&name=DLFE-11534.zip&redirect=http%3A%2F%2Fdeveloper.cisco.com%2Fweb%2Faxl%2Fdocs%3Fp_p_id%3Ddoc_library_summary_portlet_WAR_doclibrarysummaryportlet_INSTANCE_DXka%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3Dcolumn-1%26p_p_col_count%3D3
     

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: VALERIY PAVLICHENKO on 19-02-2009 12:34:45 AM
    David,
     
    Thank you very much. Very helpful.
     
    Val

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: VALERIY PAVLICHENKO on 23-02-2009 06:19:30 PM
    Hi David,
     
    I'm able to retrive the DHCP subnet information using the follwoing request:
     
    my $soapEnv = <<AXL;
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
    <SOAP-ENV:Body>
    <axl:getDHCPSubnet xmlns:axl="http://www.cisco.com/AXL/7.0">
    <uuid>{230eeb62-7017-7ce6-a1ba-c305e216dfd6}</uuid>
    </axl:getDHCPSubnet>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
    AXL
     
    The drawback is that I have to open the CM7.0 webpage for DHCP subnet to find the uuid number 230eeb62-7017-7ce6-a1ba-c305e216dfd6 for the subnet. Is there a way to get the list of the uuids for all subnets programmatically?
    I'm new to AXL, your help and directions would be greatly appreciated.
     
    Thanks,
    Val

    Subject: RE: Can I used Administration XML to retrieve the DHCP configuration?
    Replied by: David Staudt on 23-02-2009 08:51:46 PM
    Looks like there is no 'listDHCPSubnet' request, but you can query the data using SQL and the executeSQLQuery request.  Check the Data Dictionary document for details on the tables/fields involved, but in its simplest form, the XML+SQL might look like:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/7.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLQuery sequence="1">
             <sql>select pkid from dhcpsubnet</sql>
          </ns:executeSQLQuery>
       </soapenv:Body>
    </soapenv:Envelope>