AnsweredAssumed Answered

Correct query for device without alarms

Question asked by JosephMX on Dec 27, 2017
Latest reply on Dec 28, 2017 by Gene_Howard

Hi everyone,

 

Im doing a dashboard for a client and put a widget in order to show the alarms that a device have in the moment (pie widget).

The query associate to this pie its the next:

 

select severity, count(severity) from nas_alarms where source='10.0.10.250'
group by severity

 

If the device have any alarms the widget whow the correct information but if the device have not any alarms the widget show garbage. This because the result of the query its NULL.

 

 

Can any one please tell me what its the correct query in order to show '0' alarms and made the widget show correct values when the device have not any alarms and if have some they were showed too.

 

I hope you can help me.

 

Regards

 

Jose

Outcomes