More On SCCM and Powershell

I thought I would add to our previous post on Powershell. Powershell can make SCCM admin far easier for repetitive tasks.  To make life really easy we can start creating our own “cmdlets”. Anyone can write their own cmdlets for Powershell but it’s heavy duty coding so we’re going to fake it by adding functions…


Client Network Traffic tests

These postings are provided “AS IS” with no warranties, and confer no rights. The following information is for example purposes only. Do not rely on this information for a production deployment. These are meant to show the areas you should test for when evaluating ConfigMgr client activity impact on your network before going into production….


What AI data is in your database?

Ever wonder what’s in the Asset Intelligence (AI) catalog on your site server’s database?  I wrote the following query for a customer to show the value of AI and the data this is in there (and convince them to deploy AI Sync Point).  It summarizes data to a list of Publishers and an sum of…


Client Activity Summary Report

The following T-SQL query will generate a report that shows the status of ConfigMgr clients.  It uses various sources for this information, including: Last Hardware Inventory timestamp Last AD Discovery agent timestamp ConfigMgr 2007 R2 Client Health views data, including: Last Heartbeat DDR Last HW Inventory Last SW Inventory Last Policy Poll to the MP…


Useful ConfigMgr Resources

The following is a list of useful information on ConfigMgr, pointing to various resources and sources of information.  ConfigMgr Resources/Information: Learning: TechCenter on TechNet: Features (Technical Content): Virtual Labs: Webcasts: Audiocasts (WMA): TechNet Virtual Labs, ConfigMgr: Download Service Pack 2 Here: (Upgrade download, Full Evaluation download available here). …


ConfigMgr and Powershell

Hello, This is my first blog post so I thought I would make it something vaguely interesting (to certain people).  Powershell has been around for a while, though for most ConfigMgr people it remains a dark area.  This is primarily due to the lack of samples explaining how to access the ConfigMgr WMI Provider on…