Tuesday, October 27, 2015

SCCM SQL QUERY TO FIND "MS-OFFICE PRODUCTS REGISTERED IN ADD or REMOVE PROGRAMS"

select distinct (a.Netbios_name0), a.Creation_date0,a.User_name0,a.client0, a.ad_site_name0,a.obsolete0,b.sms_installed_sites0 as 'sitecode',
os.Caption0 + ' '+ os.CSDversion0 as 'Operating System',addr.DisplayName0,addr.Version0,addr.Publisher0,addr.InstallDate0
from v_r_system a
left outer join v_RA_System_SMSInstalledSites b on a.resourceid=b.resourceid
left outer join v_GS_WORKSTATION_STATUS c on a.resourceid=c.resourceid
left outer join v_GS_Operating_system OS on os.resourceid=a.resourceid
inner join v_GS_ADD_REMOVE_PROGRAMS addr on addr.resourceid=a.resourceid
where (addr.DisplayName0 like 'Microsoft Office 2%'
 OR addr.DisplayName0 LIKE 'Microsoft % Professional%'
 OR addr.DisplayName0 LIKE 'Microsoft % Enterprise %'
 OR addr.DisplayName0 LIKE '%Microsoft % Standard%' )
 ORDER BY Netbios_Name0 ASC

No comments:

Post a Comment