Microsoft Configuration Manager
An integrated solution for for managing large groups of personal computers and servers.
4,603 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Is there a custom SCCM report which can generate details about this -
1. Total compliance
2. Patch wise report
3. Machine wise missing security patches
4. Risk level report
5. Non-Compliance since days/date
Not exactly, but you can refer to this one for inspiration and create your own. https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/mastering-configuration-manager-patch-compliance-reporting/ba-p/1415088
What exactly do you have for a SQL query now? What exactly isn't working for you? Some of what you are looking for already exists as builtin reports.