Client Health: Find all CCMEval Failed or Unknown

Keeping your ConfigMgr clients healthy is an important task for an SCCM administrator. Here's a SQL query that will find all devices in ConfigMgr that have been active in the last 7 days, but┬áhave either failed their CCMEval or have "unknown" status, ie no CCMEval results. I like to add SQL queries to PowerShell functions … Continue reading Client Health: Find all CCMEval Failed or Unknown