View ocum_report_birt.eventseveritytrendchart | Generated by SchemaSpy |
View Definition:
select `eventseveritytrendhelper`.`triggeredDate` AS `triggeredDate`,cast(sum((case when (`eventseveritytrendhelper`.`severity` = 3) then `eventseveritytrendhelper`.`numberOfEvents` else 0 end)) as unsigned) AS `errorCount`,cast(sum((case when (`eventseveritytrendhelper`.`severity` = 4) then `eventseveritytrendhelper`.`numberOfEvents` else 0 end)) as unsigned) AS `criticalCount`,cast(sum((case when (`eventseveritytrendhelper`.`severity` = 2) then `eventseveritytrendhelper`.`numberOfEvents` else 0 end)) as unsigned) AS `warningCount` from `ocum_report_birt`.`eventseveritytrendhelper` group by `eventseveritytrendhelper`.`triggeredDate`
Possibly Referenced Tables/Views: