How to verify data is being updated in the Spectrum reporting database on the Spectrum Report Manager (SRM) system

Products

• CA Spectrum

Issue/Introduction

How to verify data is being updated in the Spectrum reporting database on the Spectrum Report Manager (SRM) system

Environment

Release : Any version of Spectrum

Component :Reporting

Resolution

There are two ways to check:

Check the SRM SPECTRUM Status page

1. Log into the web page of the OneClick/SRM system as an ADMIN user

2. Click on the Administration link

3. Click on the Report Manager link

4. Click on the SPECTRUM Status link

5. Monitor the "Last Event Time" to ensure the time is current and updating

Use mysql to check for updates

1. Log into the OneClick/SRM system as the user that owns the SRM installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

4. Enter the following command at the mysql prompt:

SELECT domain_name, avail_sync_time, alarm_sync_time, event_sync_time FROM landscape;

5. The output should look similar to the following:

mysql> SELECT domain_name, avail_sync_time, alarm_sync_time, event_sync_time FROM landscape;

+----------------+---------------------+---------------------+---------------------+

| domain_name |     avail_sync_time    |    alarm_sync_time       |     event_sync_time    |

+----------------+---------------------+---------------------+---------------------+

| spectrum        | 2019-06-19 18:10:31 | 2019-06-20 05:10:55 | 2019-06-20 11:26:03 |

+----------------+---------------------+---------------------+---------------------+

1 row in set (0.00 sec)

There should be an line for each landscape (domain_name) that is being monitored (refer to the SRM "SPECTRUM Status" page for monitored landscapes). The dates/times for the avail_sync_time, alarm)sync_time and event_sync_time columns should be current and updating periodically.

Additional Information

If the data is not updating:

1. Log into the web page of the OneClick/SRM system as an ADMIN user

2. Click on the Administration link 

3. Click on the Report Manager link 

4. Click on the SPECTRUM Status link

5. Ensure the check box in the Monitor column is checked.

    a. If not checked, check it and run through the verify steps again to ensure it is being monitored.

    b. If check but not updating, un-check, wait a few minutes and then check again. Run through the verify steps again.