Maintenance Mode Event Codes

Products

• Spectrum
• Network Observability
• CA Performance Management

Issue/Introduction

What are the event codes for maintenance mode that can be used to audit who and when devices are placed into Maintenance Mode?

Environment

All supported version

Resolution

In Maintenance Even Type code is 0x10222

Out of Maintenance Event Type code is 0x10223

Standard Out-of-Box (OOB) data retention for the Archive Manager's DDM database is 45 days. To retrieve older user-initiated events, the SRM database must be queried if its retention period (typically 150+ days) is sufficient.

1. Verify if Spectrum Report Manager (SRM) is installed on the OneClick web server.
2. Access the SRM host and navigate to the MySQL binary directory: cd $SPECROOT/mysql/bin/.
3. Connect to the reporting database using the MySQL command prompt: ./mysql --defaults-file=../my-spectrum.cnf -u<user> -p<password> reporting.
4. Execute the following query (replacing the model name and date as needed):
   

   select * from event e, model m where m.model_key=e.model_key AND e.type=0x10222 AND m.model_name='[DEVICE_NAME]' and e.time > '[YYYY-MM-DD HH:MM:SS]';

5. Review the user_name or creator field in the results to identify the user.

The MySQL query returns a list of events where the device was placed into Maintenance Mode, including the timestamp and the user responsible.