Historical volume sizes

[alexj]

Is there a way to pull historical volume sizes from OCUM or Harvest? There doesn't appear to be an API for OCUM to do this on OCUM 7.1 / Harvest 1.3.

Is there a way to log in to the database on OCUM directly to obtain this information?

[mbeattie · Accepted solution]

Hi Alex,

There are several database views of historical volume capacity available in the "ocum_report" database

• volumecapacityhistorymonthview
• volumecapacityhistoryweekview
• volumecapacityhistoryyearview

Download a copy of HeidiSQL (its' free) and place in "C:\Program Files\MySQL\MySQL Server 5.6\lib" on your OCUM server then connect to the MySQL instance.

/Matt

[alexj]

Thanks Matt. Those were the exact tables/database that I wanted and I was able to access them.