Access the Values for a Historic View
You can access the values that are produced by a Historic View’s algorithms by querying the table for the Historic View. To do this, you can use an SQL Query or a query from another application such as Crystal Reports. In your SQL Query, you will need to use the Summary field to define the result columns that you want to query. For example, if you wanted to query the top 10 results in the Average and Sum result columns of a Historic View for a point with the ID of 23338, you would define the SQL Query as:
SELECT TOP(10) * FROM HistoricView1 WHERE Summary='AVERAGE' OR Summary='Sum' AND ID=23338.
Where: HistoricView1 is the name of the Historic View you want to query (as defined when the Historic View was configured, see Create a Historic View).