I'm looking for a way to create a dashboard that shows total alarm count for each origin?
So the output would be something like:
origin = customer A
severity = critical
total alarms = 3
I would use a query like this:
SELECT origin, COUNT(*) as [Alarms]FROM NAS_ALARMSGROUP BY originORDER BY origin
If you also want to break down by severity, you could use:
SELECT origin, severity, COUNT(*) as [Alarms]FROM NAS_ALARMSGROUP by origin, severityORDER BY origin, severity
I use these with the NIS bridge and they are pretty much real-time.
You could create a table and add DB query as datasource as far as I know. This query will return number of alarms for each origin:
select DISTINCT A.origin, B.count from NAS_ALARMS A, (select origin, COUNT(*) as count from NAS_ALARMS group by origin) Bwhere A.origin=B.origin;
I'm not sure what you wish to display in severity field though, the highest alarm with that Origin?
Having considered this more, for the method above to work, NiS bridge should be enabled in nas. Even then, the nas database is replicated to nis at an interval, so this would lag behind the actual state, the lag depending on your replication interval (1h is the default I think).
To get the current situation, you need to create a widget (I prefer Numeric LED) and select Probe as data source as follows:
robot: your nas server
arguments: Origin: the hub you want alarms from
result token: alarm_count
Create a LED for each Origin.
Thanks for your replies
Retrieving data ...