Search for Messages

About this task

You can search the archive for selected types of messages generated during a specific time period and to display selected fields from those messages. When you do so, a dynamic formula is placed in the worksheet, using which you can build a dynamic message report that you can build, save, and reuse.

Procedure

  1. Open an Excel worksheet.
  2. Select Historian > Administration > Search Messages.
    The Historian Message Search window appears.
  3. Select a server from the drop-down list. If you do not specify a server, the default server is used.
  4. Enter values as described in the following table.
    Field Description
    Topic Select one of the message types from the drop-down list.
    Query Times Enter values for the start time and end time.
    Search String Enter a search string for the text of messages. You need not enter * for wildcards.
    Output Display Select one or more parameters for the output display. Select a name to select it.
    Output Range Select a range of cells in a single row or column to determine where the returned data is placed.
    Asc or Desc Specify whether you want to sort the messages in ascending or descending order.
    Note: When selecting multiple tags, the orientation of the return data is based on the orientation of the selected tags and the Row/Col selection is ignored.
  5. Select OK.
    A list of messages appear based on the search criteria.