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 )

  1. I don’t have WQL or SQL query

    However, you can try checking the following views

    v_CH_ClientSummary

    v_CH_EvalResults

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .