The 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.