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
SCCM CB 1706 has very good new feature that is called script. script is very good feature to collect some certain data from some a comput...
This is really tough task, when you want to move public folder database from one server to another server in exchanger server 2007, Exchange...
Today we will talk about ho to setup the cloud management gateway in our SCCM environment which is available with SCCM CB 1610 Step:-1 C...
A-Source version of package is missed on DP While Package distribution on distribution point you’re facing a problem, Distmgr.log is...