CA Service Management

  • 1.  CMDBf query to read CI data from CI table/family

    Posted Jan 11, 2017 01:08 PM

    Hi,

     

    I am trying to read the Computer CI's from the CA CMDB using cmdbf QueryService. Can any one provide the sample query format for to query all the CI data from the CI table along with the soap body?

     

    Regards,

    Raj



  • 2.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 12, 2017 04:51 AM

    Hi Raj.

    There is an example in the online docs:

    https://docops.ca.com/ca-service-management/14-1/en/reference/ca-service-desk-manager-reference-commands/cmdb-technical-reference/cmdb-web-services/cmdb-web-services-access

    it looks like:

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dat="http://cmdbf.org/schema/1-0-0/datamodel">
       <soapenv:Header>
            <sec:securityHeader xmlns:sec="http://schemas.xmlsoap.org/soap/envelope/">
                    <sec:username>userid</sec:username>
                    <sec:password>password</sec:password>
            </sec:securityHeader>
       </soapenv:Header>

       <soapenv:Body>
          <dat:query>
             <!--Zero or more repetitions:-->
              <itemTemplate suppressFromResult="false" id="All">
             </itemTemplate>
        </dat:query>
       </soapenv:Body>
    </soapenv:Envelope>

     

     

     

     

    Regards

    ..............Michael



  • 3.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 12, 2017 10:20 AM

    Hi Michael,

     

    Thanks for the response. 

     

    I have already looked into this. But in the soap body envelope,  I don't see the CI table name?

     

    <dat:query>
               <!--Zero or more repetitions:-->
               <itemTemplate suppressFromResult="false" id="All">
               </itemTemplate>
    </dat:query>

    Can you please give an example with CI table name?

     

    Regards,

    Raj



  • 4.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 12, 2017 10:47 AM

    Hi Raj.

    Because the CMDBf webservice is exclusivly used for CI's and their relationships, you don't need to specify a CI table name for the CI's.

    Additionaly, the CMDBf webservice is the SDM specific implementation of a company and tool independent standard CI data exchange interface called CMDBf https://www.dmtf.org/standards/cmdbf. Also from this point of view,it wouldnt make sense to be able to specify a tool dependent table name.

    Hope that helps and kind regards

    ..........Michael



  • 5.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 13, 2017 11:47 AM

    Hi Michael,

     

    Thanks for your response. 

     

    I did go through the DMTF site and look into the queryservice wsdl. It looks like the schema path present in the wsdl file is wrong. 

    schemaLocation="http://schemas.dmtf.org/cmdbf/1/serviceData/dsp8040.xsd"/>

    I think the correct schema path is http://schemas.dmtf.org/cmdbf/1/tns/serviceData/dsp8040.xsd

     

    When I try to correct the schema, the wsdl file is not working properly.

     

    Regards,

    Raj



  • 6.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 13, 2017 12:15 PM

    Hi Raj.

    It is not quite clear to me, what you are trying to achieve?

    If you want to consume the SDM CMDBf webservice, the one and only one truth is the wsdl you get when accessing

    http://your_sdm_server_here:8080/axis/services/QueryPort?wsdl

    This wsdl is working for me, quite well, as far as I tested.

    Regards

    ...........Michael



  • 7.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 13, 2017 12:46 PM

    HI Michael,

     

    I am trying to create the web service project in SoapUI using the cmdbf query service(DSP8043.WSDL) listed in the https://www.dmtf.org/standards/cmdbf.

     

    Regards,

    Raj



  • 8.  Re: CMDBf query to read CI data from CI table/family

    Posted Jan 13, 2017 04:52 PM

    Hi Raj.

    That's exactly, what I did with the SDM WSDL.  This was working well, for my rudimentary tests.I suggest to do the same and not using the WSDL from the dmtf.org site.

     

    Kind regards

    ....Michael