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

File Inventory via Configuration Items rather than Software Inventory

It's no secret that I'm not a fan of using Software Inventory (SWINV). So when I recently got a request to report on whether certain files existed on machines I decided to do something a little different. I was asked to find out if a list of 9 dlls existed within a specific folder on … Continue reading File Inventory via Configuration Items rather than Software Inventory

How to see the Hardware Inventory classes and properties via T-SQL

Recently I was asked "Are you aware (do you have an example) of a way to extract data from the ConfigMgr database for hardware inventory rules and classes?" (That was in a comment of a blog I posted on my team's blog: https://blogs.technet.microsoft.com/system_center_in_action/2012/05/19/auditing-software-inventory-rules-in-system-center-2012-configuration-manager/. This post is in response to that comment. [edit: April 2019] That … Continue reading How to see the Hardware Inventory classes and properties via T-SQL

Troubleshooting/Monitoring Hardware Inventory with the InventoryLog

One of the coolest ‘features’ of inventory is the fact that it logs information to the database when it processes the files. Granted, I’m biased on this opinion because I helped make it happen. Unfortunately, I haven’t seen anyone talk about it yet so it’s either not as cool as I thought or people don’t … Continue reading Troubleshooting/Monitoring Hardware Inventory with the InventoryLog

Hardware Inventory – View to Class/Property Info

Over the past several years I've gotten a lot of questions from people about what WMI class is the source of data for a particular hardware inventory view ("v_GS_..."). This past week I created a couple queries to provide a team who has generally been the source of 95% of these questions and I figured … Continue reading Hardware Inventory – View to Class/Property Info