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.

Active IQ Unified Manager Discussions

OCUM database tables data

GGIBBS

I have a question regarding the data that is in some tables/fields in the OCUM database. For example, there is a table called: aggregatehistoryyear, and there are ten (10) fields in the table. 

Can someone tell me what data is in the following fields:

* dfKBytesUsedSum

* dfKBytesTotal

 

The reason I am asking is that the data in the table does NOT match with the OCUM GUI is showing, for aggregate usage.

Hopefully, someone can explain what the data in the database tables represents. Even better would be to have a document that describes how the data get populated.

 

Thanks,

 

Geoff

 

1 ACCEPTED SOLUTION

Dhiman

G'day Geoff, 

 

It will not match. As explained, the GUI shows averaged aggregation for the "past 72 hours" whereas the DB shows sampling from polling intervals (much granular). 

 

Please consider the following usecase:

 

1. Somebody wants to know the health across this cluster, he will look at GUI

2. For critical vectors, user will need detailed data, which is why he will scan DB data, for more granular information.

 

hope this helps!

 

 

Thanks,

Dhiman

View solution in original post

4 REPLIES 4

Dhiman

Hi,

 

Very valid question, what you see in the GUI are averaged for 72 hours, whereas the DB shows hourly averages for 30 days. 

 

Thanks, 

Dhiman

GGIBBS

Dhiman,

 

thank you for the response. However, the data still does not match. 

 

Geoff

Ajaykb

Are you accessing the OCUM GUI from a different time zone & your OCUM server hosted in a different time zone ? 

Dhiman

G'day Geoff, 

 

It will not match. As explained, the GUI shows averaged aggregation for the "past 72 hours" whereas the DB shows sampling from polling intervals (much granular). 

 

Please consider the following usecase:

 

1. Somebody wants to know the health across this cluster, he will look at GUI

2. For critical vectors, user will need detailed data, which is why he will scan DB data, for more granular information.

 

hope this helps!

 

 

Thanks,

Dhiman

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