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