Historian Interactive SQL Application Functionality

You can retrieve Historian data from any available Historian server. The Historian Interactive SQL application provides a login screen when you open the application so that you can specify the server you want to query. You specify the server at startup, and you can switch to another server after completing your queries, or you can also open multiple windows to the same server or different servers. For instance, you might want to open more than one window to compare two different time periods on the same server, or the same time period on different servers.

Aside from entering and executing SQL queries, you can save and load queries, or export query results to Microsoft Excel.

The following figure displays an example of a query and its results in the Historian Interactive SQL application.