CA Client Automation

how to converte this sql querie in a ITCA querie?

select host_name

     from Ca_Discovered_Hardware har

     where har.asset_Source_Uuid not in(

          select distinct soft.asset_Source_Uuid

               from Ca_Discovered_Software soft)

          and har.dis_Hw_Uuid in (

                select member_Uuid

                     from Ca_Group_Member

                     where group_Uuid = 0x849b57d5c96b4d4989f3f99a0a8e3d83) order by 1

We have some agents without software inventory, although the UAM is OPERATIONAL

Create a dummy query first, e.g. (Hostname = 'without software').

Then right click this entry in the right pane of the Query Designer, select Edit SQL and replace the SQL by:

ca_discovered_hardware.asset_Source_Uuid not in (

          select distinct soft.asset_Source_Uuid

               from Ca_Discovered_Software soft)

          and ca_discovered_hardware.dis_Hw_Uuid in (

                select member_Uuid

                     from Ca_Group_Member

                     where group_Uuid = 0x849b57d5c96b4d4989f3f99a0a8e3d83) order by 1

Thanks