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
Friday, March 29, 2013
Thursday, March 21, 2013
System Center 2012 Configuration Manager RTM Upgrade to SP1: DMP Proxy is not responding to HTTP requests
Recently I tried to upgrade my System Center 2012 Configuration
Manager RTM hierarchy to SP1, and found that the Device Management Point was
down after the upgrade. In the site console monitoring->component status, the
SMS_MP_CONTROL_MANAGER turned to critical and showed the error message: “DMP
Proxy is not responding to HTTP requests.” And there are also error messages in
mpcontrol.log: ”Call to HttpSendRequestSync failed for port 443 with status
code 500, text: Internal Server Error.”, and reinstall the DMP would not fix
Then I tried to run the “\Windows\Microsoft.Net\Framework64\v4.0.30319\aspnet_regiis.exe–i”
to refresh the ASP.net and IIS configuration,
now the issue was resolved
Monday, March 4, 2013
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...