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

  • Document ID:7709643
  • Creation Date:02-Feb-2007
  • Modified Date:07-Jan-2011
    • Micro Focus Products:
      AppManager

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