Method # 1: From CLI
1. Navigate to $SPECROOT/vnmsh and connect
2. ./show events > SSEvents.txt
Above steps will dump all events from a specific SpectroSERVER to a text file
Method # 2: From MySQL
1. Navigate to $SPECROOT/mysql/bin and execute command
./mysql --defaults-file=../my-spectrum.cnf -u<MYSQLROOTUSER> -p<MYSQLROOTUSERPWD> ddmdb
2. Execute below command at mysql prompt
SELECT model_h, utime, counter, clk_seq, version, node_id, user_key, type, severity INTO OUTFILE '/tmp/SSEvents.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM event;
I did not mention all fields/columns of event table in step # 2, if you need all, then replace all files with '*'
If you want all events from all SpectroSERVERs, then from OneClick console you have to follow method # 2, but instead of 'ddmdb', you should use 'reporting' as the DB Name.
Hope this helps