We had a request recently to display all users who do not have office 2003 installed.
Now there may be a better way to do this, and if so please feel free to comment,
but there is a report for Computers with specific software in Add Remove Programs which
is preferable to looking for individual executables since office is a suite of programs.
We started with this report and created one to show Computers without specific
software in Add Remove Programs.
The best way I could find to do this was to join the results of Computers with specific
software to the collection it is based on and then look for computers where there
is no match. Right click on the Computers with specific software in Add Remove
Programs report in SMS Administrator, then choose All Tasks –> Clone
and name the new report Computers without specific software in Add Remove
Programs. Go to the properties of the new report and replace the existing
query with the one provided here. Here is the query statement:
select col.[name],
sys.User_Domain0, sys.User_Name0, sys.Operating_system_name_and0
from v_FullCollectionMembership as col
LEFT JOIN (Select sys.Netbios_Name0,
fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0
FROM v_R_System
sys
JOIN v_GS_ADD_REMOVE_PROGRAMS
arp ON sys.ResourceID
= arp.ResourceID
JOIN v_FullCollectionMembership
fcm on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0
=@displayName and fcm.CollectionID=@CollID
) as t on col.[name]
= t.[Netbios_Name0]
inner join v_R_System
sys
ON sys.ResourceID
= col.ResourceID
where t.Netbios_Name0 is null and
col.CollectionID = @CollID
order by col.[name]
>
Random Posts
Loading…