Hello,

My company wants a custom report to list all of the servers based on baseline.  When I click on the baseline parameter, we should see all of the servers for that baseline and the rules which pertain that baseline and then a rule compliance status for each rule.

I've found a few views for the rules, but it is not making a lot of sense so far.

The report should look like this:

Baseline - Windows 2003 servers

=====================

Server     Rule   Compliance

ServerA   Rule1  Compliant

ServerA   Rule2  Compliant

ServerA   Rule3  Non-compliant

Any help is appreciated.

Thanks.

Have you already tried using the default reports? Which one comes close? Have you tried to modify it so that it will fit your needs?

Of course.  There is one that I am trying to make sense of.  It is Rules and errors summary of configuration items in a configuration baseline for an asset.

It is not what the auditors want but it is the only one that I can see for rules.  I just need to give a status of each rule.

Thanks.

Try the following query into SQLMS. You could then create a custom report based on this.

SELECT DISTINCT 
SYS.Name0, v_LocalizedCIProperties_SiteLoc.DisplayName, SNames.StateName
FROM  v_CICurrentComplianceStatus AS CCS 
INNER JOIN v_R_System AS SYS ON CCS.ResourceID = SYS.ResourceID 
INNER JOIN v_LocalizedCIProperties_SiteLoc ON CCS.CI_ID = v_LocalizedCIProperties_SiteLoc.CI_ID
INNER JOIN v_StateNames AS SNames ON CCS.ComplianceState = SNames.StateID
INNER JOIN v_CITypes AS TYP ON CCS.CIType_ID = TYP.CIType_ID
WHERE     (v_LocalizedCIProperties_SiteLoc.DisplayName LIKE '%') AND (CCS.ComplianceState like '%') AND  (SNames.TopicType = 401) AND (TYP.CIType_ID= 2) 
ORDER BY v_LocalizedCIProperties_SiteLoc.DisplayName

This is absolutely appreciated.  I just have one question.  With this query, I can see the servers for each baseline.  Good.

How would I bring in the rules and the compliance state for each rule for each server?

Again, thanks for pointing me in the right direction.  Much appreciated.