topic Re: Historical volume sizes in Software Development Kit (SDK) and API Discussions

Historical volume sizes

alexj — Wed, 04 Jun 2025 14:53:39 GMT

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?

Re: Historical volume sizes

mbeattie — Wed, 05 Jul 2017 11:28:35 GMT

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

Re: Historical volume sizes

alexj — Wed, 05 Jul 2017 18:13:09 GMT

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