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: [email protected] [mailto:[email protected]] On
Behalf Of Robert Spinelli
Sent: Tuesday, August 09, 2016 1:13 PM
To: [email protected]
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.
