Explore Events function

The Explore Events function returns events that meet specified criteria in a PI AF database. Use the Explore Events function to view and explore events in a hierarchical format. The function returns one event per row.

Use the fields at the top of the Explore Events task pane to specify which PI AF events you want to retrieve. As you specify the criteria for events, the task pane's Preview list shows the matching events. Modify the criteria to adjust the matching events before inserting the function array into the worksheet. Use the fields at the bottom of the task pane to specify the columns to include and the position of the inserted function array.

For more details, see the following topics:

• Events in worksheets

  PI DataLink can display data from PI AF events with either the Explore Events function or the Compare Events function.

• Explore events related to an element

  Follow this procedure to use the Explore Events function to analyze events related to a particular PI AF element.

• Explore events with child events

  Follow this procedure to use the Explore Events function to analyze events with child events.

• Explore Events task-pane reference

  The fields in the task pane let you specify the events to retrieve and the columns and data to return to the worksheet.

• Reserved attribute names

  To avoid conflicts with automatically generated attributes, do not define events that use reserved attribute names.

• Explore Events example

  Set the Explore Events function inputs to see the events that have been active during the past month and that are based on a particular template.

• Manage PI DataLink settings from Excel

  Use the Settings window to set the maximum number of events that the function returns.