How to collect total alarm count from ddmdb in Spectrum

Products

• Network Observability
• Spectrum

Issue/Introduction

This article provides a MySQL query to retrieve a cumulative count of alarms from the Spectrum Archive Manager (ddmdb) database.

This is useful for users who need to report on alarm volume over a specific period, such as 45 days, across multiple landscapes in a Distributed SpectroSERVER (DSS) environment.

Environment

Spectrum (All releases)

Resolution

• Events are stored locally in the ddmdb on each landscape.
• Running this command on the Main Landscape Server (MLS) only returns the count for that specific landscape.
• To get a cumulative count for the entire DSS, run the following steps on each landscape server:

Navigate to the MySQL binary directory:

Windows: Start a bash shell (bash -login) and go to $SPECROOT/mysql/bin

mysql -uroot -p<pw> ddmdb

Linux: $SPECROOT/mysql/bin

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

Execute the following query to get the alarm count per day (using event type 0x10701 which represents alarms):

SELECT DATE(FROM_UNIXTIME(utime)) AS Date, COUNT(*) AS Alarm_Count 
FROM event 
WHERE type=0x10701 
GROUP BY DATE(FROM_UNIXTIME(utime));

 

Additional Information

For more advanced reporting requirements, consider using the Operational Reports feature within Spectrum Report Manager (SRM).

NetOps Operational Reports