Friday, March 29, 2013

SQL query to find the application installed on particular collection in SCCM 2007

I have seen lots of user are searching a SQL query to find out some software/application installed on machine, based on the particular collection in SCCM 2007/SMS 2003,
here I go and written the SQL query to find the requirement,

Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID Join v_fullcollectionMembership FCM ON FCM.ResourceID = SP.ResourceID
WHERE FCM.CollectionID = 'CEN05238'

You need to change the product name and company name according to you and aslo you will have to change the CollectionID

No comments:

Post a Comment