Details of tables storing performance data in OpManager
The performance data tables in OpManager 12 and above are quite distributed, enabling better reporting. Here is a quick summary of the tables that you will need to take custom reports
- ElementsAvailabilityHourly - Every day device availability reports are taken from this table.
- ElementsAvailabilityDaily - This table is queried for availability reports for over a week. Has data archived every 24 hours.
- IFHCRAW_‹date› - This table has data of interface traffic, errors, discards etc. The Archiving occurs according to the monitoring interval set for an interface.
- IFHCHOURLYRATE_‹date›, IFHCHOURLYSUM_‹date› - This has values archived every one hour for all the interface data. Sum table has the average of the raw table entries. And Rate table has min, max rate calculation of traffic, errors, and discards.
- IFHCDAILYRATE_‹date›, IFHCDAILYSUM_‹date› - This has values archived every 24 hours. Sum table has the average of the hourly table entries. And Rate table has min, max rate calculation of traffic, errors, and discards.
OpManager archives the above performance tables after the row-count exceeds approx 250,000 rows. So, to know the date of the table to be queried, query the table METATABLE. This lists all the performance tables. The current performance tables (the names of which are mentioned above) will have the value as -1 for ENDTIME field.
Each element/device is a managed object and has a unique ID, which you can retrieve using MOID field in the ManagedObject table.The value of this MOID is the same as ElementID field in Element Availability table and same as ID field in Interface table. So, you can use a join between these two tables to create custom reports.
Besides the above tables, the host resources data such as that of CPU, Memory etc are persisted in the following table:
- Statsdata: This stores the current or raw data. That is, the data as and when collected. This table is created every 24 hours. New table is created at 12.00 midnight.
- Statsdata_hourly: Which has values archived every one hour. Hourly data is stored for a period of 15 days by default and can be set to a maximum of 90 days.
- Statsdata_daily: Which as values archived every 24 hours. Daily data is stored for a default period of 1 year and can be set to store for a max of 10 years.
For additional information on statsdata archiving - https://www.manageengine.com/network-monitoring/faq/performance-monitor-data-archiving.html.