Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.

Work With Queries

You can use the Historian Interactive SQL application to run a query against the data that is contained in the Historian database tables. A query is a SET or SELECT statement, or a combination of both of these SQL statements. When you execute a SELECT or SET statement in the Historian Interactive SQL application, you can execute only one SET and one SELECT statement per query.

The tables that you can query contain data and statistics associated with Historian tags, collectors, archivers, raw data, messages, comments, trend, and session settings. For information see Historian database tables.