MMS 2013 UDB-338 Additional Content

Hi, Thanks for attending or watching my session at MMS 2013 on reporting in Configuration Manager.  The session video is posted here: https://channel9.msdn.com/Events/MMS/2013/UD-B338. The following are resources related to the session or you might find interesting: T-SQL Statements along with Excel 2013 PowerPivot xlsx file http://gallery.technet.microsoft.com/scriptcenter/Count-of-EP-Definition-59c06ea2 (I have posted this here as it gives better formatting for…

4

Useful ConfigMgr Resources (Updated)

A while back (2 years to be precise) Saud posted a list of resources to do with ConfigMgr. Below is a well overdue update to that list: ConfigMgr Resources/Information: Learning: TechCenter on TechNet: http://technet.microsoft.com/en-us/configmgr/default.aspx Features (Technical Content): http://technet.microsoft.com/library/bb680550.aspx Virtual Labs: http://technet.microsoft.com/en-us/configmgr/bb539977.aspx Webcasts: http://www.microsoft.com/events/series/technetmms.aspx?tab=webcasts&id=42364 Audiocasts (WMA): http://technet.microsoft.com/en-us/configmgr/bb727202.aspx TechNet Virtual Labs, ConfigMgr: http://technet.microsoft.com/configmgr/bb539977.aspx Download Service Pack 2…

2

Software Deployment to Barely Connected Users

In a world where high-speed Internet connections are ubiquitous, even laptop computers can be expected to have some form of regular connection to the Internet or corporate network. However in the past few months the same scenario has cropped up in conversations with customers: How to include computers that barely connect to corporate network, in…

0

Being Proactive with ConfigMgr: Users with Low Disk Space

So this is the first post in a series about how to be proactive with ConfigMgr.  I’ve started with something that is relatively straightforward, disk space.  Now, you might say that this is too simple because we already have reports in ConfigMgr that tell us this information.  What I am aiming to due is get…

1

Obtaining a list of AI Microsoft Products

I received a question from colleague recently around how to find the exact name used in the AI database for previous versions of a Microsoft product.  The reason for this was to replace the license MVLS statement’s product name with an older version of software that is deployed by availing a customer Downgrade Rights in…

3

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…

0

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…

1