Software Development Kit (SDK) and API Discussions

Historical volume sizes

alexj
3,385 Views

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?

1 ACCEPTED SOLUTION

mbeattie
3,312 Views

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

 

 

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

View solution in original post

2 REPLIES 2

mbeattie
3,313 Views

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

 

 

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

alexj
3,275 Views

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

Public