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.

OpManager disable alarm if data is not collected

OpManager LogoIf OpManager finds some fault with the data collection on any of the monitors, it will raise an alarm. If you would like to disable the alarm, follow the steps below.

  1. Open the file NmsProcessBE.conf under \OpManager\conf folder.
  2. Search for the entry “CLEAN_DATA_INTERVAL 999999“.
  3. At the end of the line add the entry “GENERATE_DATACOLL_EVENT false“.
  4. Save it and restart the OpManager.