CA Service Management

Hi All,

I need some data from casdm web service, where I need month wise closed ticket data(or count) from last 1 year in a single web service call. Is is possible to fetch this data in single call, or is there any alternative for 'group by' clause in casdm web serivces. Kindly help.

Regards,

Sushma

Hi Sushma,

I don't see any webservice call which has all the where clause as per your requirement but you may want to use the doslect() webservices query which will give you more leverage for adding the where clause and get your required results.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
   <soapenv:Header/>
   <soapenv:Body>
      <ser:doSelect>
         <sid>?</sid>
         <objectType>?</objectType>
         <whereClause>?</whereClause>
         <maxRows>?</maxRows>
         <attributes>
            <!--1 or more repetitions:-->
            <string>?</string>
         </attributes>
      </ser:doSelect>
   </soapenv:Body>
</soapenv:Envelope>

Let me know this helps you keep going.

tims.registration 

Did the information provided by Maheshwar_Kusuma answer your question?

If so, please mark the answer as correct so that this thread can be closed.