SAP HANA - _SYS_STATISTICS schema

Example

Is there a missing threshold for the associated alert

SELECT "SEVERITY","THRESHOLD" FROM (
 SELECT "SEVERITY", IFNULL("CURRENT_VALUE", "DEFAULT_VALUE") AS "THRESHOLD"
 FROM "_SYS_STATISTICS"."STATISTICS_ALERT_THRESHOLDS"  WHERE "ALERT_ID" = 27 ORDER BY "SEVERITY" ASC )

Powered by ComboStrap