We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Updating the admin console's "Back to" product link
How to use the update-config script
How to check your JVM configuration name
How to use the validate-config-values script
Understanding Visibility API Logging
Updating Information Source, Source System
How to increase the heap size of server-util script executions
Insight System Options, Export
How to enable multi-threading on Insight's data loads
Configuring the ER rich client to connect to multiple ER instances

SQL query to list Severity of Result Templates

Gerard Cafaro

March 18, 2020 13:55
Updated

The SQL query below will list the following information about Assure Result Templates. The query can be run from the SQL console or directly against the Assure database.

Result Template name
Result Template Severity

The output for Severity is measured as:

I - Informational
W - Warning
E - Error
F - Fatal

select r.DISPLAYNAME as "Result Template", ra.ATTRIBUTEVALUE as "Severity" from "RULE" r
inner join RULEATTRIBUTEVALUE ra ON r.ATTRIB1 = ra.RULEATTRIBUTEVALUEPK
where r.RULETYPEFK = 39

Comments

0 comments

Please sign in to leave a comment.

Articles in this section