The community will be undergoing maintenance soon, requiring Read-Only mode. Click to learn more.

Active IQ Unified Manager Discussions

getting historical data out of OCUM


Dear all,


using OCUM-appliance 7.1P1


I am trying the get the rigth data out of the OCUM database, as I need historical data.


I suucceeded partly when I followed    .... but I think I do not have enough data to make the right calculation.


This method uses Powershell, and within Powershell some SQL-commands to get data out of the databases.



My problem: I need TOTAL and USED per PERIOD, so I can calculate per used-percentage for that PERIOD.


Now I have this data for a certain volume, but I think this is to less info:


volumeId        : 2022231
periodEndTime   : 9-11-2017 01.00.00 uur

sampleCount     : 670
UsedSum         : 3729838208
Total           : 597688320

SnapshotUsedSum : 54430564
SnapshotTotal   : 31457280


If I  UsedSum / sampleCount , it gives me a number that is to small. I have not much more fields to choose


Who can help?!  Thank you!!  Moray





Hi Moray,


From what i could compute, your volume consumption is 0.00518GB / sample or 5.18MB / sample which basically means the volume growth rate is on an average 5.18MB every 15 mins

since the default capacity poll runs every 15 mins.


Is this number way too short of the expected value, for the I/O's runnnig on this volume ?



kiran A.



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