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
Subscribe to:
Post Comments (Atom)
PXE Issue after SCCM CB 1806 upgrade
Recently i had upgraded my SCCM environment 1806 and after upgrade suddenly all PXE servers stopped working. While initiating the PXE ...
-
I wanted to share the information with you about much awaited patch Tuesday, which is live now, now Microsoft is releasing only Quality up... -
Symptoms Updates publish without issue but they fail to install on the client. This error has been shown on C:\Windows\CCM\L... -
This is really tough task, when you want to move public folder database from one server to another server in exchanger server 2007, Exchange...
No comments:
Post a Comment