Retrieve values for event snapshot tags
- Last UpdatedJan 31, 2025
- 2 minute read
You can retrieve values for snapshot tags associated with a particular event tag.
To retrieve event snapshot values:
-
In cells in your worksheet, enter one or more tagnames (one tagname per cell).
You must specify both the event tag that is associated with the snapshot action and the snapshot tag.
For information on selecting an event tag, see Selecting Analog, Discrete, String, Summary, or Event Tags.
For information on selecting a snapshot tag, see Selecting Event Snapshot Tags. Select the tag(s) associated with the event tag you selected.
-
On the Historian tab, in the Tag Management group, click Tag Values, and then click Event Snapshot Values. The Event Snapshot Values - Step 1 of 4 dialog box appears.
-
In the Servers list, click the name of the server to use.
-
In the Select cell(s) containing tag name(s) list, specify the location of the worksheet cell(s) that contains the tag name(s). Click on the button to select the cell(s). For more information, see Selecting Cells.
-
If you want to use a named tag range variable instead, click Binding Options and then configure the range. For more information, see Using "Binding" Tags to a Query at Run Time.
-
Click Next. The Event Snapshot Values - Step 2 of 4 dialog box appears.
-
In the Select cell for output list, specify the location of the worksheet cell(s) that will contain the output. Click on the button to select the cell(s) using your mouse. For more information, see Selecting Cells.
-
Select the Enter the results as an array-formula check box to insert the results as an array formula. An array formula can perform one or more calculations and then return either single result or multiple results. An array formula allows for the resending of the query, since the query parameters are included in the cells that contain the query results. For more information, see Working with Functions, Formulas, and Cells.
-
Select the Select cells to specify format options check box to specify a range of cells that contain formatting information. The formatting information in the cells will be applied to the query results. For more information, see Selecting Cells.
-
Click Next. The Event Snapshot Values - Step 3 of 4 dialog box appears.
-
Configure the criteria for the query.
For more information, see Display Options Tab.
-
Click Next. The Event Snapshot Values - Step 4 of 4 dialog box appears.
-
Configure the time for the query. For more information on configuring these options, see Time Options for Queries.
-
Click Finish.