AMT / ConfigMgr SQL Query: Mismatched Hostnames

In IT environments where device naming standards may be course, or where users can freely rename their systems at will, you may experience problems managing these clients’ AMT firmwares. Since, in order to maintain proper AMT functionality, the OS and AMT hostnames must match, an IT administrator or engineer would likely be interested in finding out which machines do not meet this criteria.

With that in mind, I’ve written a simple SQL query, that can be run against your Configuration Manager database, to determine what devices have mismatching OS and AMT hostnames. I’ve pasted the text below, but if you want a more nicely formatted version, please see this link at PasteBin.


/*

Author: Trevor Sullivan

Date: Tuesday, July 21st, 2009

Purpose: Identify devices whose AMT hostname and OS hostname mismatch