Need WQL queries to create collections for each CCM evaluation failure checks.
Question
Hi Experts ,
I want to create collection for each below mentioned CCMEval Task.
Can someone help me with WQL query .
Verify CCMEval task has run in recent cycles. |
Verify/Remediate client prerequisites. |
WMI Repository Integrity Test. |
Verify/Remediate SMS Agent Host status. |
WMI Event Sink Test. |
Verify WMI service exists |
Verify/Remediate client installation. |
WMI Repository Read/Write Test. |
Verify/Remediate Antimalware service status. |
Verify/Remediate Antimalware service startup type. |
Verify/Remediate Windows Update service startup type. |
Verify/Remediate SMS Agent Host startup type. |
Verify/Remediate WMI service status. |
Verify/Remediate SQL CE database is healthy. |
Verify/Remediate Microsoft Policy Platform service startup type. |
Verify BITS service exists. |
Verify/Remediate BITS startup type. |
Verify/Remediate Network Inspection service startup type. |
Verify/Remediate WMI service startup type. |
Verify/Remediate Windows Update service startup type on Windows 8. |
Verify SMS Agent Host service exists. |
Verify/Remediate Client language packs. |
Verify/Remediate Windows Update Service status |
Verify/Remediate Configuration Manager Remote Control service startup type |
Verify/Remediate Configuration Manager Remote Control service status |
Thanks,
Ketan Kamble
Answer ( 1 )
I don’t have WQL or SQL query
However, you can try checking the following views
v_CH_ClientSummary
v_CH_EvalResults