AnsweredAssumed Answered

How to Convert query ITCM in modeldata Xtraction

Question asked by AndreMatsuoka2015Sam on Sep 21, 2018
Latest reply on Oct 4, 2018 by Brian_Fontana

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 ?

Outcomes