I happened to have this saved for some reason. Might be close to what you mean. If you want per-computer, uncomment that line and fill in that prompt; if you mean per-collection, uncomment the fcm line and fill in the collectionid. It is 'hard coded' to 1033 English. If you happen to be elsewhere/different language, you may want to change that. I was just cheating and making it simple for me.
select fcm.name, ba.assignmentName, lcb.IsAssigned ,CASE WHEN cs.ComplianceState = 1 then 'Compliant' when cs.ComplianceState = 2 then 'Non-Compliant' when cs.ComplianceState = 4 then 'Failure' end as 'TextComplianceState' ,cs.IsEnforced, cs.ComplianceValidationRuleFailures, cs.errorCount ,cs.ConflictCount, cs.LastComplianceMessageTime, cs.LastEnforcementMessageTime ,ciinfo.DisplayName, ciinfo.description from vSMS_BaselineAssignment ba join v_fullcollectionmembership fcm on fcm.collectionid=ba.collectionid join fn_ListconfigurationBaselineInfo(1033) lcb on lcb.CI_UniqueID=ba.AssignedCI_UniqueID join vSMS_CombinedconfigurationItemRelations cir on cir.FromCI_ID=lcb.CI_ID join v_ConfigurationItems ci on ci.ci_id=cir.TOCI_ID join dbo.v_CICurrentComplianceStatus cs with(NOLOCK) on cs.CI_ID=ci.ci_ID and cs.Resourceid=fcm.resourceid join fn_ListCIs(1033) ciinfo on ciinfo.ci_id=cs.ci_id where --fcm.name = @ComputerName and --If you want per-computer, uncomment this --fcm.collectionid = @CollectionID and --if you want for a specific collection, uncomment and fill this in instead of the per-computer above. cs.isapplicable=1 and cs.isdetected=1 order by fcm.name On Wednesday, February 4, 2015 3:30 PM, Ryan Shugart <[email protected]> wrote: Hi: Is there an equivalent to the “Compliance details for a configuration baseline” (report ID 309) report in SCCM 2012R2? I’m looking for a report that shows me compliance for each configuration item for each device in a collection, and I can find ones that summarize this info but not one that goes through item by item, device by device like that one did. Thanks. Ryan Ryan Shugart LAN Administrator MiTek USA, MiTek Denver 314-851-7414 MiTek Holdings, Inc., 2011-2014, All Rights Reserved ________________________________ This communication (including any attachments) contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, copying, or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it.
