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

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

this issue.

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

When not to use IP Address Ranges as Boundaries in Configuration Manager

It is often surprising to me how what may seem like innocuous decisions on how to configure settings in Configuration Manager can lead to very different performance results. A case that has come up recently is the difference between using IP subnet based...(read more)

• Read the complete post at http://blogs.technet.com/b/configmgrteam/archive/2013/03/01/when-not-to-use-ip-address-ranges-as-boundaries-in-configuration-manager.aspx