| Server |
Select the SQL server that contains the alarms and events
data. |
| Query Type |
Select one of the following values:
- Alarms: In Historian, an
alarm's entire life cycle is stored as a single
record in the alarm archive. Thus, when retrieving
from the archive, the entire life cycle of an alarm
will be returned in a single record.
- Alarm History: Each change in
the alarm's state will be returned in a single
record.
- Events: One row per event is
returned.
|
| Query Criteria |
Enter the criteria that you want to use in the query. For
example, you may want to include alarms where the Alarm ID
is equal to a specific Alarm ID occurring after a specific
start time. In addition, you can specify which attributes
must be displayed and how the results must be sorted in the
spreadsheet. |
| Output Range |
Select a range of cells in a single row or column to
determine where the returned data must be placed. |
| Output Orientation |
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. |
| Maximum Results |
Enter the maximum number of results for the query to
return. Note: An Excel spreadsheet
can display up to 255 columns and 32,767
rows. |
| Output Display |
Specify the attributes that you want to display in the
spreadsheet. |
| Output Sorting |
Select the parameter using which you want to sort the
results:
- Alarm Time: Sorts the data by
the start time. The results appear in the reverse
chronological order.
- Custom Sort: Allows you to
select the field using which you want to sort the
results.
- None: The results are not
sorted at all. They are returned in the order they
are received from the alarms and events
database.
|
| Export Options |
Select the format in to which you want to export the
data:
- To New Worksheet: Exports the
data to a new Excel worksheet.
- To CSV File: Exports the data
with comma separated values to a new file.
- To XML File: Exports the data
to a new XML file.
|
Historian