Thursday, October 21, 2010

Query to find Installed Application list from all machines

select distinct (a.Netbios_name0), a.Creation_date0,a.User_name0,a.ad_site_name0,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 not like '%kb%'
and (a.Client0=1 and a.Obsolete0=0 and a.Active0=1)
order by a.Netbios_name0,addr.Publisher0

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home