Software Development Kit (SDK) and API Discussions

Historical volume sizes


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


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.





If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

Re: Historical volume sizes


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

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums