SELECT distinct
v_R_System.Netbios_Name0 as [Device],
v_R_System.User_Name0 as [Username],
v_R_System.OperatingSystem0 as [OS],
v_LocalizedCIProperties.DisplayName as [Configuration Baseline],
v_CIComplianceStatusDetail.LastComplianceMessageTime as [Last Check]
FROM v_R_System
join v_CIComplianceStatusComplianceDetail on v_r_system.ResourceID = v_CIComplianceStatusComplianceDetail.ResourceID
join v_CIComplianceStatusDetail on v_r_system.ResourceID = v_CIComplianceStatusDetail.ResourceID
join v_LocalizedCIProperties on v_CIComplianceStatusComplianceDetail.CI_ID = v_LocalizedCIProperties.CI_ID
where
v_CIComplianceStatusComplianceDetail.CI_UniqueID = 'ScopeId_2C6E2FAF-844C-4686-89AF-9C5D5E47F1BD/Baseline_ed93d18e-35c0-41f3-8e1c-85bdb8bd08ae'
and
v_CIComplianceStatusComplianceDetail.ComplianceState = 2