Problem with "ABILITY TO CUSTOMIZE THE POLICY VIOLATIONS SUMMARY"

Version 1

    Hi,

     

    i have nearly solved the problem to display all policy violation in a resource. How it is possible wished in the idea: https://thwack.solarwinds.com/ideas/1666

     

    Unfortunately it isn't really nice but you get all the information you want to see (just like me).

     

    For a simple summary overview you have to add the resource "custom swis query":

     

    edit this resource and paste following sql-statement into the field: SELECT pr.Name, rv.Info, rv.Warning, rv.Error FROM Cirrus.PolicyReportViolations rv, Cirrus.PolicyReports pr where rv.ReportID=pr.PolicyReportID and rv.TimeStamp > GETDATE()-1

     

    (perhaps you want to expand it with that: and pr.Granuality!="Weekly"

     

    You can choose the rows that have to be displayed with a simple counter at the bottom of the query field.

     

    If you are done with it then you get something like that:

     

    Name          Info     Warn     Crit

    report1          1          2          1

    report2          2          0          9

    and so on

     

    But the report-names are not a link (href) to the specific compliance policy. Sorry it is only a table but you can sort it.

    If you want links to the specific compliance policies you have to use a resource called "custom html" and in this you can only use javascript to initialize a database connect.

    If there is an other way please tell me. 

    For myself I only use a "custom query" to display the policy violation summary and below that resource a add an other resource "custom html" and pasted manually all links to the compliance policies.

     

    For further question do not hesitate and ask me.

     

    Kind regards,

    Flo