I'm Trying to create a report in SCCM. I need to see all the machines that doesn't have a specific software installed on it. I have created a report to see all that have the software installed on it, but I'm unable to get the report to show me the machines that doesn't have the software installed on it.
Please see the SQL Statement underneath:
Select SP.Netbios_Name0, SYS.DisplayName0, SYS.ResourceID
FROM v_Add_Remove_Programs SYS
JOIN v_R_System SP on SP.ResourceID = SYS.ResourceID
WHERE SYS.DisplayName0 = 'Trend Micro OfficeScan Client'
How can I change this to see the machines without that software?