topic Re: Issue with creating report for OCUM in Active IQ Unified Manager Discussions

Issue with creating report for OCUM

Andrew7193 — Wed, 04 Jun 2025 13:50:51 GMT

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

Re: Issue with creating report for OCUM

kirana — Thu, 03 May 2018 08:46:23 GMT

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.

Re: Issue with creating report for OCUM

Andrew7193 — Thu, 03 May 2018 13:09:47 GMT

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.