Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Software Development Kit (SDK) and API Discussions

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?

1 ACCEPTED SOLUTION

mbeattie

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

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

alexj

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

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public