The InventoryLog Report

A year ago I blogged on the "InventoryLog" table and how it can be used to help troubleshoot hardware inventory issues. I also got a comment asking about how I wrote the query/report I showed in that post. I was reminded today about that comment and figured I should post something...a year later is better … Continue reading The InventoryLog Report



[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on May 14, 2013 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for the my WordPress theme (and … Continue reading SQL Tip: APPLY

Adding Summaries to ConfigMgr 2012 SSRS Reports

Technorati Tags: ConfigMgr,SCCM,System Center Configuration Manager,SSRS,Reports The ConfigMgr 2007 reports have a record count at the top of the reports. The reports in ConfigMgr 2012 do not. I'll be walking through the steps of how to add this to your 2012 reports. Additionally, if you're unfamiliar with SSRS or "Report Builder" this will be a … Continue reading Adding Summaries to ConfigMgr 2012 SSRS Reports