ConfigMgr Report: Total Number of Packages Per Distribution Point

Today I had to create a report in ConfigMgr to list total number of packages that have been assigned to each Distribution Point. The SQL query is rather simple, a one-liner. Here’s the query: This query works on both ConfigMgr 2007 and 2012. ConfigMgr 2007 Report: ConfigMgr 2012 Report:

SCCM Site Systems and Components Summarizer Reports

I received an email today from someone who downloaded my SCCM Health Check Script 3.5. He asked me if I can help to modify the script to only display Site Systems and Components status. I thought this can be easily achieved by creating few simple reports inside SCCM. If you are running SCCM 2007 R3 and have Reporting Service Point configured, you can publish these reports to SQL Reporting Services and create some schedules to email out daily. So I quickly wrote 3 reports: 1. Site Status Overview Report – A high level overview of site status 2. Site System

SCCM Report: Site Boundaries

I wrote this simple report yesterday to list and search site boundaries: Report Name: SCCM Site Boundaries SQL Query:   Prompts: Name: BoundaryName Prompt Text: Boundary Name Prompt SQL Statement:

SCCM Report: “System Boot Time for Computers in a Specific Collection

This is a report I wrote last week: “System Boot Time for Computers in a Specific Collection”. SQL Statement:   Prompts: Name: CollectionID Prompt Text: Collection Prompt SQL Statement: Please note the system boot time is collected from LastBootUpTime in Win32_OperatingSystem via SCCM client hardware inventory. Therefore the information is as current as SCCM client’s last hardware inventory. Example:

%d bloggers like this: