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 ?
I believe Xtraction is part of the Service Desk arena. Have you asked this question within the Service Desk community?