OpManager Report on last pulled values

OpManager LogoThe following SQL will extract the data that shows the last pulled value for all performance monitors. This will help us to identify which monitor does not getting proper / correct data from device.

mysql -u root -P 13306 OpManagerDB
SELECT agent,name,val FROM polleddata LEFT OUTER JOIN statsdata_daily ON id=pollid WHERE nameNOT LIKE 'if%' AND (val IS NULL OR val='0')
GROUP BY agent,name,val order by agent,name;

If want to redirect the output to a csv file, put the following command at the end of the SQL statement.

INTO OUTFILE 'C:\\filename.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Note: Exclude the “ENCLOSED BY” if its not required.