Alarm Analytics with DX Spectrum and Grafana

[Robert Kettles]

Hello,

These are the materials from the September 22, 2020 "AIOps Office Hour for NetOps Solution from Broadcom" session. The zip file contains the JSON file to import into Grafana.

Attachment(s)

AIOpsOfficeHourforNetOpsSolutionfromBroadcomSept22_2020.pdf   1.52 MB 1 version

Spectrum Alarm Analytics-1602170309709.zip   6 KB 1 version

[Robert Kettles]

Updated version that fixes the cause codes displayed in the "Top Alarms" bar chart and table views.  You can also just make the changes instead of uploading a new dashboard:

In the Top Alarms bar chart view, change alarminfo.model_h to alarminfo.cause:

SELECT
count(alarminfo.alarm_title_id) as "Count",
alarmcondition.condition_name,
alarmtitle.title,
hex(alarminfo.model_h) as "PCauseCode"
FROM reporting.alarminfo alarminfo
INNER JOIN reporting.landscape landscape

to

SELECT
count(alarminfo.alarm_title_id) as "Count",
alarmcondition.condition_name,
alarmtitle.title,
hex(alarminfo.cause) as "PCauseCode"
FROM reporting.alarminfo alarminfo
INNER JOIN reporting.landscape landscape

Similar in the Top Alarm table view:

SELECT
count(alarminfo.alarm_title_id) as "Count",
alarmcondition.condition_name,
alarmtitle.title,
hex(alarminfo.model_h) as "PCauseCode"
FROM reporting.alarminfo alarminfo
INNER JOIN reporting.landscape landscape
ON alarminfo.landscape_h = landscape.landscape_h

to

SELECT
count(alarminfo.alarm_title_id) as "Count",
alarmcondition.condition_name,
alarmtitle.title,
concat("0x",hex(alarminfo.cause)) as "PCauseCode"
FROM reporting.alarminfo alarminfo
INNER JOIN reporting.landscape landscape
ON alarminfo.landscape_h = landscape.landscape_h

This gives us not only the correct cause code but provides the familiar 0x prefix for hex values.  Enjoy!

Attachment(s)

Spectrum Alarm Analytics-1619126765353.zip   6 KB 1 version

[Robert Kettles]

More minor changes to make model handles all in lower case.  Mostly going through and changing:

hex(alarminfo.cause)

to

lower(hex(alarminfo.cause))

Attachment(s)

Spectrum Alarm Analytics-1619190559652.zip   6 KB 1 version

[Robert Kettles]

Hi everyone,

It's been a while but we have some updated content.  This mostly a maintenance update to make sure that the dashboard works with Grafana versions 9 and higher as a few of the visualizations used have been deprecated and replaced.  There's also a new dashboard variable added called "OneClickLaunch" that is used for launching the Spectrum WebApp in context from some of the table views where the model name is present.  For example, if the URL of OneClick server that you'd like to launch to is "http://oneclick.example.com:8080/spectrum" just enter "http://oneclick.example.com:8080" for the value.  Change the port number and http/https as appropriate. 

If you didn't make any changes to the dashboard, you can update by deleting your existing dashboard and import this one.  You'll need to select the appropriate values for "Spectrum Reporting" and  "Spectrum SRMDBAPI" data sources when you import but that should be fairly straightforward if you followed the guidance for initial deployment.  If you did make modifications and don't want to delete the existing one prior to importing, you'll need to change the values for dashboard title and dashboard ID when importing the updated dashboard.  Then you can either merge the new content into your existing dashboard or make modifications to the one just imported. 

Enjoy!  

Attachment(s)

Spectrum Alarm Analytics-v9_June2025.zip   7 KB 1 version

[Robert Kettles]

Hi everyone,

Another update.  I broke up the dashboard into Alarm Analytics and Event Analytics.  The event analytics were previously at the bottom of the alarm analytics dashboard.  As I added some additional event views to show top eventing (noisiest) models, I figured it made sense to split into two dashboards so don't overload things.

If you didn't make any changes to the dashboard, you can update by deleting your existing dashboard and import the Alarm Analytics one.  Event Analytics would be a new import.  You'll need to select the appropriate values for "Spectrum Reporting" and  "Spectrum SRMDBAPI" data sources when you import but that should be fairly straightforward if you followed the guidance for initial deployment.  If you did make modifications and don't want to delete the existing one prior to importing, you'll need to change the values for dashboard title and dashboard ID when importing the updated dashboard.  Then you can either merge the new content into your existing dashboard or make modifications to the one just imported. 

Enjoy!  

  

-------------------------------------------

Attachment(s)

Spectrum Event Analytics-92_August.zip   4 KB 1 version

Spectrum Alarm Analytics-92_August.zip   6 KB 1 version

[Robert Kettles]

Hi everyone,

Another update.  I still had some Angular components remaining in the dashboard so I've replaced them with updated ones.  This should work on Grafana 10.3.12 and above.

Enjoy!

-------------------------------------------

Attachment(s)

Spectrum Event Analytics-103_December.zip   4 KB 1 version

Spectrum Alarm Analytics-103_December.zip   6 KB 1 version

[Thangaselvi Kasamuthu]

Hi Robert ,

 Will it work on 24.13 and 25.X version of spectrum?

-------------------------------------------

[Robert Kettles]

Yes.  The database structure for SRM has been pretty stable for many years/releases.  The dashboard updates have been focused on changes within Grafana itself as they've moved from AngularJS to React.  You'll want to make sure you reference the updated product documentation links for steps such as creating additional users for the database.  The presentation in this thread references documentation from older releases so make sure to find the updated version for what you have installed.

-------------------------------------------