Tag: SCCM Reports

Hi, Answered a question on Technet forum this morning and about a report to list all Windows 7 computers without Service Pack 1 installed. I modified it slightly for this post to include the possibility to filter on a specific collectionID. When creating the report create a prompt in the report called varcollection Report Query: Select…

As a follow up and as I  promised in a previous post here are both reports which makes it possible to track advertisement status per collection and to link it to the next report, All system resources in a specific collection for a specific advertisement in a specific state. These both reports makes it possible…

Another report ;-)! There are many scenarios where I found that it would have been great to be able to track advertisement status for a specific advertisement per collection. For instance, if a manager places a service request that 40 computers at that department should have Office 2010 installed, it would be great to have a report showing the result per collection.     …

This reports will help you plan you roll-out project and plan it by presenting a report with a count of each computer model per collection. If you already have collections in SCCM per site, per department, per subnet or whatever you wan’t, you can use them to report which models exist. The reports can be…

I got this request from a customer and thought I could share it. Below query describes how to modify the query for the built-in report “Computer information for a specific computer” to include serial number.  The added sql commands are marked in red color if you want to change it yourself instead of copying the SQL…