Target an advertisement based on the software version in SCCM

Let’s say we want to advertise an update to Adobe Reader only to clients with outdated versions (anything older than 10.0.1). Create a new collection. Edit the membership rules. Click on Edit Query Statement. At the bottom press “Show Query Language”. Paste the following: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID […]

Unable to run reports in ConfigMgr?

You may get the following error message when trying to generate reports: “The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.” To solve that, add the ASP Role Service to IIS in […]

ConfigMgr Firewall exceptions for Client deployment.

To enable ConfigMgr client deployment, create the following GPO (or update if you already have one): Computer Configuration > Policies > Administrative Templates > Network > Network Connections > Windows Firewall > Domain Profile Windows Firewall: Allow inbound file and printer sharing exception: Enabled Allow unsolicited incoming messages from these IP addresses: SCCM IP Address […]

Missing IIS sites in SCCM 2007 SP2 R3?

After installing SCCM I noticed that IIS was not populated with the different websites needed to run ConfigMgr properly. I took me hours to figure out until I found the ConfigMgr Toolkit. Run the MP Troubleshooter, it will solve the issues. Of course MS could fix that easily but that must be too much to […]