WQL query for ARP Display name

ARP display name, add remove

SMS_R_SYSTEM.ItemKey, SMS_R_SYSTEM.DiscArchkey, SMS_R_SYSTEM. Namee, SMS_R_SYSTEM. SMS_Unique Ident ifiere, SMS_R_SYSTEM. Resource_Domain_OR_Workgre, SMS_R_SYSTEM.Cliente from VSMS_R_System AS SMS_R_System INNER JOIN Add_Remove_Programs_DATA AS __System_ADD_REMOVE_PROGRAMSO ON System_ADD_REMOVE_PROGRAMSØ.Machine ID = SMS_R_System. Itemkey where __System_ADD_REMOVE_PROGRAMS.DisplayName00 = N'Desk Utilization Monitoring Client'

ARP display name, add remove64bit

select all

SMS_R_SYSTEM. ItemKey, SMS_R_SYSTEM.DiscArchKey, SMS_R_SYSTEM. Name, SMS_R_SYSTEM. SMS_Unique Ident ifiere, SMS_R_SYSTEM. Resource_Domain_OR_Workgro, SMS_R_SYSTEM. Cliente from VSMS_R_System AS SMS_R_System where (SMS_R_System. ItemKey not in (select all

__tem_ADD_REMOVE_PROGRAMS_640.Machine ID from Add_Remove_Programs_64_DATA AS __tem_ADD_REMOVE_PROGRAMS_640 where __tem_ADD_REMOVE_PROGRAMS_640.DisplayName00 = N' Lumension

Endpoint Security Client') AND SMS_R_System. Itemkey not in (select all __System_ADD_REMOVE_PROGRAMSØ.Machine ID from Add_Remove_Programs_DATA AS __System_ADD_REMOVE_PROGRAMSO where __System_ADD_REMOVE_PROGRAMSO.DisplayName00 = N' Lumension Endpoint Security Client'))