Here is a start. Its every device and its compliance state. Easy to filter on what you want.
select cicsd.Netbios_Name0 [Name], cicsd.ci_id [CI ID], cicsd.configurationitemname [CI], CICSD.Criteria, cicsd.CurrentValue, cicsd.LastComplianceMessageTime [Last Message] from v_R_System SYS join v_CIComplianceStatusDetail CICSD on sys.resourceid = cicsd.ResourceID Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Robert Spinelli Sent: Tuesday, August 09, 2016 1:13 PM To: mssms@lists.myitforum.com Subject: [mssms] Compliance Status Query ? Anyone have a query they use to report back what CI in a baseline is causing the baseline to be non-compliant? If you have a baseline with OS requirements selected that comes back as non-compliant and then you have CI in that baseline come back as complaint, the whole baseline is non-complaint (correct). I can't seem to figure out how to get a query to show me which of the items in the baseline is causing the baseline to be non-compliant. Thanks Rob The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.