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.