Searching Messages

About this task

The Search Messages function lets you search the archives for selected types of messages generated during a specific time period and to display selected fields from those messages. This puts a dynamic formula in the worksheet. Dynamic formulas allow you to build a dynamic message report that you can build, save, and re-use.

Procedure

  1. Select Administration and then select Search Messages from the Historian menu.
    The Historian Message Search dialog appears.
  2. Select a server from the drop-down list. If you do not specify a server, the Add-In uses the default server.
  3. In the Topic field, select one of the message types from the drop-down list.
  4. In the Query Times fields, enter values for start time and end time.
  5. In the Search String section, enter a search string for scanning the text of messages. You do not need to enter * ?s for wildcards.
  6. In the Output Display section, select one or more parameters for the output display. Click a name to select it.
    To select multiple individual tags, press the Control key and click the tagnames. To select a sequence of tags, press the Shift key and click the first and last tagname of the sequence.
  7. Click in the Output Range field and select a range of cells in a single row or column to determine where the returned data is placed.
  8. Select Asc or Desc to sort the messages in ascending or descending order.
  9. Select either Columns or Rows for the output display. Selecting Columns displays a table of values with parameters arranged in columns with header labels at the top. Selecting Rows rotates the table 90 degrees.
    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.
  10. Click OK to execute the search. Click Cancel to close the dialog box.