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 […]

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 […]

Adding PXELinux option to WDS.

Deployment guru Johan Arwidmark has a pretty interesting article about adding a boot menu to WDS. But it’s about Windows Server 2008 R2. If, like me, you need info about Windows Server 2008, follow his step-by-step until step 7. At step 7, open the Windows Deployment Services console, right click on your server, then click […]

Sophos Antivirus Deployment How-To.

I came across a couple of issue while test-driving Sophos Antivirus Enterprise. Here are the correct steps to deploy Sophos to Windows machines (XP, Vista and 7): Create a GPO named Disable UAC with the following settings and apply it to your hosts (Computer Configuration): Computer Configuration (Enabled)/Policies/Windows Settings/Security Settings/Local Policies/Security Options/User Account Control/Policy Setting […]

Trying to get rid of WINS but still in trouble with rogue Master Browser elections?

There is an interesting article at TechRepublic about GNZ or Global Name Zones in Windows Server 2008. For the record, in the Windows Support Tools, you can find the browstat.exe utility (browstat status from a command line) that allows you to check which computer is the Master Browser and then to troubleshoot that mess […]