ConfigMgr Report: Total Number of Packages Per Distribution Point

Posted by Tao Yang on 20/08/2013 in SCCM |

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

Posted by Tao Yang on 23/02/2012 in SCCM |

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

Tags: ,


SCCM Report: Site Boundaries

Posted by Tao Yang on 02/02/2012 in SCCM |

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:

Tags: ,


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

Posted by Tao Yang on 26/07/2011 in SCCM |

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


Copyright © 2010-2014 Tao Yang's System Management Blog All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.2.4.1, from BuyNowShop.com.