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.