CA Client Automation

Expand all | Collapse all

How to Convert query ITCM in modeldata Xtraction

Jump to Best Answer
  • 1.  How to Convert query ITCM in modeldata Xtraction

    Posted 09-21-2018 10:31 AM

    Hi, have query is ok 

     

     

    SELECT * FROM ca_discovered_hardware
    WHERE ca_discovered_hardware.dis_hw_uuid in
    (SELECT object_uuid FROM ca_agent
    WHERE server_uuid IN (SELECT server_uuid FROM ca_server WHERE label='Camocim'))
    AND NOT dis_hw_uuid IN
    (SELECT asset_source_uuid FROM ca_v2_discovered_software
    WHERE name LIKE '%Trend%' OR name LIKE '%OfficeScan%')

     

    How to convert this in modeldata Xtraction ?



  • 2.  Re: How to Convert query ITCM in modeldata Xtraction
    Best Answer

    Posted 10-04-2018 11:05 AM

    I believe Xtraction is part of the Service Desk arena.  Have you asked this question within the Service Desk community?