How do I query to display data between a specific time range from the AppManager Repository? (NETIQKB9643)

  • 7709643
  • 02-Feb-2007
  • 07-Jan-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager Repository

Situation

How do I query to display data between a specific time range from the AppManager Repository?

Resolution

To display data between a specific time range:

  1. Open SQL Server Query Analyzer.
  2. Select the Repository (QDB).
  3. Type the following SQL query:


              SELECT *
              FROM ArchiveData, ArchiveDataHeader
              WHERE ArchiveData.DataID = <DataID> and ArchiveData.Time > <UTC Time A> and ArchiveData.Time < <UTC Time B>
     
    Where:

    • <DataID> is the DataID of the particular data stream to extract from the ArchiveData and ArchiveDataHeader tables.
    • <UTC Time A>* is the first date and time of the data point to extract from the ArchiveData and ArchiveDataHeader tables.
    • <UTC Time B>* is the last date and time of the data point to extract from the ArchiveData and ArchiveDataHeader tables.

    *Use the prttime.exe utility on the AppManager 4.x CD to find the dates and times.  This utility is located under %\Contrib\Utilities.

    Example:

     SELECT *
     FROM ArchiveData, ArchiveDataHeader
     WHERE ArchiveData.DataID = 2 and ArchiveData.Time > 1020445296 and ArchiveData.Time < 1020445326

  4. Execute the SQL query by using F5 or the green arrow.

To display all UTC times for a specific data stream:

  1. Open SQL Server Query Analyzer.
  2. Select the Repository (QDB).
  3. Type the following SQL query: 

              SELECT *
              FROM ArchiveData, ArchiveDataHeader
              WHERE ArchiveData.DataID = <DataID>

    Where <DataID> is the actual DataID of the specific data stream.

  4. Execute the SQL query by using F5 or the green arrow.

Additional Information

Formerly known as NETIQKB9643

Feedback service temporarily unavailable. For content questions or problems, please contact Support.