How can SRM monitoring be disabled from command line?

Products

• Network Observability
• Spectrum

Issue/Introduction

We accidentally installed Spectrum Report Manager with OneClick and after upgrading with exclude_parts=SA-RPT-MGR the Report Manager Preferences window is no longer available.  We need to verify that Report Manager on this OneClick is disabled and not polling the SpectroSERVERs.

Resolution

Disable the event_polling and device_polling in mysql on the OneClick/SRM host

cd $SPECROOT/mysql/bin

Windows:
./mysql -u<user> -p<password> ddmdb;

Linux:
./mysql --defaults-file=../my-spectrum.cnf -u<user> -p<password> reporting;

SELECT landscape_h, domain_name FROM landscape;

SELECT domain_name, event_polling, device_polling FROM landscape WHERE domain_name = 'name_of_ss';

UPDATE landscape SET event_polling = 0, device_polling = 0 WHERE domain_name = 'name_of_SS';

SELECT domain_name, event_polling, device_polling FROM landscape WHERE domain_name = 'name_of_ss';

quit