Tuesday, September 7, 2010

SMS Query to find manually installed applications

SELECT dbo.v_GS_SYSTEM.Domain0, dbo.v_GS_SYSTEM.Name0, dbo.v_GS_SYSTEM.SystemType0, dbo.v_GS_SYSTEM.SystemRole0,
dbo.v_GS_INSTALLED_SOFTWARE.ResourceID, dbo.v_GS_INSTALLED_SOFTWARE.InstallDate0,
dbo.v_GS_INSTALLED_SOFTWARE.ARPDisplayName0, dbo.v_GS_INSTALLED_SOFTWARE.InstalledLocation0,
dbo.v_GS_INSTALLED_SOFTWARE.InstallSource0, dbo.v_GS_INSTALLED_SOFTWARE.ProductVersion0,
dbo.v_GS_INSTALLED_SOFTWARE.Publisher0, dbo.v_GS_INSTALLED_SOFTWARE.ProductName0
FROM dbo.v_GS_INSTALLED_SOFTWARE INNER JOIN
dbo.v_GS_SYSTEM ON dbo.v_GS_INSTALLED_SOFTWARE.ResourceID = dbo.v_GS_SYSTEM.ResourceID
Where dbo.v_GS_INSTALLED_SOFTWARE.InstallSource0 not like 'C:\programData\1E\SMSNomad\%'
order by dbo.v_GS_INSTALLED_SOFTWARE.InstallSource0 desc

Description:

The above query helps to find manually installed applications list from SMS database. You can give your SMS cache folder in the 'where' clause and put a not like to avoid all those applications got installed through SMS. So, the query result would contain all those applications got installed but are not through SMS Server. (But the core applications which have installed with the Image is an exception. You may need to filter the list a bit).

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home