Active IQ Unified Manager Discussions

Issue with creating report for OCUM

Andrew7193

I am building a history report in BIRT that draws data from an OCUM 7.1P3 appliance. I am using the aggregatecapacityhistoryyearview table. I am trying to derive a value from the UsedSum column that takes the value and divides it by 1024 Four times believing I will get a terabyte value. The values returned are not accurate at least compared to the GUI and the frames GUI. What is the value that is stored in KB? MB? GB?

 

What the OCUM GUI shows is 2.76TB at the high point what my report shows is 1.75TB 

1 ACCEPTED SOLUTION

Andrew7193

I had assumed it was KB however the issue I was experiencing was resolved by dividing UsedSum by sampleCount then by 1024/1024 to get what I wanted.

View solution in original post

2 REPLIES 2

kirana

Hi Andrew,

 

This should be in KB as the column is named 'dfKBytesUsedSum'. So, you can divide by (1024*1024) to get value in GB.

 

Andrew7193

I had assumed it was KB however the issue I was experiencing was resolved by dividing UsedSum by sampleCount then by 1024/1024 to get what I wanted.

View solution in original post

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