How to query for Spectrum alarm count totals stored in OneClick SRM Reporting DB

Products

• Network Observability
• Spectrum

Issue/Introduction

Is there a way to see how many total alarms came into Spectrum for a given timeframe?

Environment

Spectrum 23.3.x, 24.3.x

Resolution

The OneClick SRM Reporting DB has an alarm table that can be queried for this information.

Login:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<password>

use reporting;

Example for June (Total count for all landscapes combined which are in reporting db):

SELECT count(*) as count from alarminfo WHERE set_time >= '2025-06-01 00:00:00' AND set_time < '2025-06-30 23:59:59';

Specific Landscape (Ex Landscape 0x1000000 = 16777216) - This is hex to numerical:

SELECT count(*) as count from alarminfo WHERE set_time >= '2025-06-01 00:00:00' AND set_time < '2025-06-30 23:59:59' and landscape_h=16777216;