How do I match up the data in the repository to what I see in a chart? (NETIQKB53167)

  • 7753167
  • 02-Feb-2007
  • 21-Apr-2011

Environment

NetIQ AppManager 7.0.x
NetIQ AppManager 6.0.x

Situation

How do I troubleshoot gaps in my data chart?

Resolution

The data in the chart comes directly from the repository. To cross-reference that data, run the following SQL query in Query Analyzer against the repository database:

          SELECT TOP 2000 Time, Value, Detailshort from Data (INDEX=Data_DataID_idx) Where DataID = <dataid number>  ORDER BY Time DESC

Selecting the top 2000 assumes the number of points to fetch in a chart has not been changed from the default which is 2000. If you have changed this to something else, change the 2000 in the SQL query to match that.

Get the dataid number from the Data Source id under the graph data tab for the chart you want.  You can also get the dataid number by right-clicking the job then selecting Create chart from selected job.

The results include a Time field. You can convert this field into a more readable format using the prttime utility available on the AppManager CD.

Additional Information

Formerly known as NETIQKB53167