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

Creating Registered Servers in SSMS via PowerShell

I wrote a script that creates a "Registered Server" group and then a "Server Registration" for each of the servers found in a text or csv file. This comes in handy when you want to create lots of registrations (groups and/or servers). Basically, to use the script, you create a file (txt or csv) for … Continue reading Creating Registered Servers in SSMS via PowerShell

Collecting members of the Local Administrators group

A while ago I had to collect the members of the local administrators group via ConfigMgr. This data has come in handy a number of times so it’s certainly one of those inventory items I don’t plan on stopping just yet. Security being such a big deal, it’s nice to have a way to review … Continue reading Collecting members of the Local Administrators group

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