The Server Status Tool provides status information that is organized into groups of categories, each of which contains sub-categories. The Historic group provides status information about the historic and event data for the server on which you are working, including details of the historic and event searches currently active on clients that are connected to the server. The Historic group contains the following sub-categories:
- Alarm Summary Searches—provides status information about the searches that are currently requesting alarm summary data.
- Config Changes Searches—provides status information about the searches that are currently requesting data from the configuration changes auditing files.
- Historian—provides status information about the historic data that is stored on the server
- Historic Searches—provides status information about the searches that are currently requesting historic data
- Journal Searches—provides status information about the searches that are currently requesting event data.
The ability to edit SQL queries that are used in query lists, including Alarm Summary Lists, can be restricted. This is done by restricting the availability of the Edit Query option on such lists. Access to this option can be restricted on either a per server, or per user, basis. When access to the Edit Query option is restricted, the restriction also extends to QueryPad, the SQL diagnostics tool that is supplied with ClearSCADA. When the restriction is in place, users will be unable to connect QueryPad to the database. For more information, see Specify Whether SQL Queries can be Edited using the Clients on this Server, and see Define the SQL Editing Settings for a User.