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.
Get the script: