Querying Alarms and Events Data in the Excel Add-In

Procedure

  1. From the Historian menu, choose Query Alarms & Events.
    The Query Alarms & Events window appears.
  2. Select a Server. Your default server should be selected. To set the selected server as default, ensure the Set Server to Default option is enabled.
  3. Select from Query Type.
  4. Select a Query Criteria.
  5. Select your Output Display and Sorting.
  6. Select OK.
    Note: Excel limits the amount of data that can be entered into a formula or returned into a worksheet. The following are guidelines for formula and result limits in various versions of Excel. Output is limited to:
    • Excel XP: 32767 cells
    • Excel 2003 32767 rows