SQL Tip: The nodes() method (XML)

[edit: June 2019] This was originally posted to my internal (to Microsoft) blog on June 10, 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 my WordPress theme. Note: I … Continue reading SQL Tip: The nodes() method (XML)

Advertisements

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

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

Moving the ConfigMgr site database to an Always On Availability Group

Back in 2012 I really wanted to be able to have the ConfigMgr database in an Always On Availability Group (I’ll refer to this as an “Availability Group” or an “AG” from now on). So, a coworker and I made that happen – sure, it wasn’t supported and auto-failover didn’t work but nevertheless we had … Continue reading Moving the ConfigMgr site database to an Always On Availability Group