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
- Select Administration and then select Search Messages from the Historian menu.
The Historian Message Search window appears.
- Select a server from the drop-down list. If you do not specify a server, the Add-In uses the default server.
- In the Topic field, select one of the message types from the drop-down list.
- In the Query Times fields, enter values for start time and end time.
- In the Search String section, enter a search string for scanning the text of messages. You do not need to enter *’s for wildcards.
- In the Output Display section, select one or more parameters for the output display. Select a name to select it.
To select multiple individual tags, press the Control key and select the tagnames. To select a sequence of tags, press the Shift key and select the first and last tagname of the sequence.
- Select 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.
- Select Asc or Desc to sort the messages in ascending or descending order.
- 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.
- Select OK to execute the search. Select Cancel to close the window.