Lab 14.5 – Retrieve Event Data with a Custom Query
Retrieve Event Data with a Custom Query
The event tags you just configured are already collecting data in the Historian database. Now, you will use SQL queries to retrieve this event information.
Step 60. Go back to the SQL Management Studio and verify that you are connected to your Tier-1 Historian Server and the Runtime database is selected.
Step 61. Download Lab 14 - Retrieving Event Data.sql.
Retrieve Event Data with a Custom Query
The event tags you just configured are already collecting data in the Historian database. Now, you will use SQL queries to retrieve this event information.
Step 60. Go back to the SQL Management Studio and verify that you are connected to your Tier-1 Historian Server and the Runtime database is selected.
Step 61. Download Lab 14 - Retrieving Event Data.sql.
Retrieve Event Data with a Custom Query
The event tags you just configured are already collecting data in the Historian database. Now, you will use SQL queries to retrieve this event information.
Step 60. Go back to the SQL Management Studio and verify that you are connected to your Tier-1 Historian Server and the Runtime database is selected.
Step 61. Download Lab 14 - Retrieving Event Data.sql.
Retrieve Event Data with a Custom Query
The event tags you just configured are already collecting data in the Historian database. Now, you will use SQL queries to retrieve this event information.
Step 60. Go back to the SQL Management Studio and verify that you are connected to your Tier-1 Historian Server and the Runtime database is selected.
Step 61. Download Lab 14 - Retrieving Event Data.sql.
And double-click on it C:\Training\Lab 14 - Retrieving Event Data.sql.
Step 62. In the body of the query, highlight the Example 1 query and click the Execute button (or Press the F5 key).
Step 63. Based on the results of this query, answer the posed questions.
Step 64. Repeat Steps 62 and 63 for the rest of the queries.
And double-click on it C:\Training\Lab 14 - Retrieving Event Data.sql.
Step 62. In the body of the query, highlight the Example 1 query and click the Execute button (or Press the F5 key).
Step 63. Based on the results of this query, answer the posed questions.
Step 64. Repeat Steps 62 and 63 for the rest of the queries.
And double-click on it C:\Training\Lab 14 - Retrieving Event Data.sql.
Step 62. In the body of the query, highlight the Example 1 query and click the Execute button (or Press the F5 key).
Step 63. Based on the results of this query, answer the posed questions.
Step 64. Repeat Steps 62 and 63 for the rest of the queries.
And double-click on it C:\Training\Lab 14 - Retrieving Event Data.sql.
Step 62. In the body of the query, highlight the Example 1 query and click the Execute button (or Press the F5 key).
Step 63. Based on the results of this query, answer the posed questions.
Step 64. Repeat Steps 62 and 63 for the rest of the queries.
Last modified: Monday, 24 June 2019, 11:15 AM