AnsweredAssumed Answered

How to list alarms by severity and group them by date in UIM?

Question asked by ElioteArg on Apr 18, 2016
Latest reply on May 20, 2016 by Gene_Howard

I want to create a sql table in a custom dashboard I'm creating to list alarms the amount of alarms by severity and date. I could only get to list the amount of alarms by severity, but I'm not finding the way to also split that amount by date.

 

This is the query I make:

 

select severity, count(*) cantidad

from nas_transaction_summary

where source like '%10.120.97.21%'

group by severity

 

and it returns this:

 

"severity""cantidad"
"critical""18"
"information""19"
"major""40"
"minor""10"
"warning""32"

 

I'd like to get something like this:

 

"severity""total"2016-04-182016-04-172016-04-16...2016-04-XY
"critical""18"24282
"information""19"101008
"major""40"

13

75105
"minor""10"00433
"warning""32"172364

 

What about if I'd like to display those values in a line chart? For instance, a series would be for the critical alarms, and the count for each day would be a dot in the chart.

Outcomes