How do I find out when a point was written to the repository or SQL table? (NETIQKB47520)

  • 7747520
  • 02-Feb-2007
  • 09-Dec-2010

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

What is the difference between BiasedTime, the ModificationTime and Time columns in the Data, ArchiveData, and Aggregate Data tables?
How do I find out when a point was written to the repository or SQL table?
How do I find out when a data point was collected?
How can I find out how the time between when a data point was collected to the time it was written to the repository?

Resolution

The following values are used to record time related to data points:

  • ModificationTime: specifies when the point was written to the repository or SQL Table.
  • Time: specifies when the point was collected on the agent.
  • BiasedTime: Time value, adjusted for Time Zone.

The difference between Time and ModificationTime is the time delta between when the point was generated on the agent and the time it was written to the repository. The time delta is used by the Operator Console and Chart Console to determine what information is changed since the console last refreshed.

Additional Information

Formerly known as NETIQKB47520