Your company's ad could live here and reach over 50,000 people a month!

Author: Brett Wilms

Using SQL to Search Collection Queries

Computers aren’t perfect. Sometimes they just don’t report properly to SCCM. In one particular case, we had a computer whose Add/Remove Programs information was not populating in the SCCM database. For this reason, they were showing applicable for several recurring advertisements we had out there and kept having jobs forced on them. Not fun for the user. It was requested of me to manua...

Is a Secondary Site the Answer?

We’re working on a side-by-side upgrade to SCCM 2007 from SMS 2003. We have less than 10,000 clients and currently have a primary site in each of three geographical regions to serve as the Management Point for the regional clients. One of the challenges we are facing is that we are without a server to complete the side-by-side process in one region. So, we’re trying to figure out the b...

Report: All collections for a specific computer

The web report query below returns the collection membership for a specific computer name. It also displays whether the collection has an advertisement associated with it. I’ve found it very helpful when trying to determine what advertisements a client should be receiving as well as if the client has ended up in some "funny" collections. It is similar to the canned report "All...

Report: All distribution points for a specific package

The web report query below returns the list of Distribution Points for a specific package, separated by "Installed" and "Not Installed". I created this report to help me understand what Distribution Points were missing particular packages. SELECT ‘INSTALLED’ SELECT pkg.Name, pkg.PackageID, SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2...