Finding the application of a given SCCM deployment via T-SQL

Recently a coworker was troubleshooting some application installation issues on a device. Looking through the "AppEnforce" log he found the deployment name and Id. As an example, here's what it would look like if you were troubleshooting the same log (I highlighted the deployment name yellow, and the deployment id green for reference): Although he … Continue reading Finding the application of a given SCCM deployment via T-SQL

Advertisements

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