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