sccm report for computers doesnt have software installed

Create a new report and paste the following query into it.This needs prompt as well to list the applications installed on computers .

Select Distinct
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0
FROM
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
sys.ResourceID not in (select sys.ResourceID
from
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
where
DisplayName0 = @displayname)

Prompt for Displayname:

select DisplayName0 from v_Add_Remove_Programs

You can also filter this to collection ,see how this can be done from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/

Leave a Reply