Query Tools
Query Tools is a special interface used to run queries and statements against a database. This interface can be accessed manually or by running a stored query from the Queries interface. The database configuration and connection information must be available in the Databases interface before those settings can be used by this interface.
Configuration -> Databases -> Queries
Configuration -> Databases -> Databases
Note:
Not all databases can be connected to using this interface.
Refer to the Grid Details section for details on how to interact with the interface.
This user interface calls REST methods from api/database/queryTools.
The UI path for this interface is Configuration -> Databases -> Query Tools.
Caution:
Be careful when using this interface. It is possible to:
-
Delete data with malformed queries.
-
Cause database performance issues when querying large datasets.
See the following table for the language used in each schema and database.
| Schema | Database | Language |
|---|---|---|
| Assure1 | MySQL | SQL |
| Event | MySQL | SQL |
| Graph | Neo4j | Cypher Query Language |
| Historical | ElasticSearch | Elasticsearch SQL |
| Metric | InfluxDB | InfluxQL |
| Vision | MySQL | SQL |
Caution:
When reviewing the external documentation linked above, confirm you are using the correct version of the documentation based on the versions listed in Unified Assurance Licensing Information User Manual.
Grid Details
-
Prev/Next - These buttons can be used to view the queries that have been run via the interface.
-
Clear Results - This button will clear the results from previously run queries.
-
Database - A selector for which database is to be used when running the query.
-
Schema - A selector for which schema is to be used when running the query.
-
ShardID - An identifier of which shard should be used when running the query.
-
SELECT Limit - A limit will be added to the query. This is also used for pagination.
-
Query - The query to be run.
-
Results - The results of the queries that have been run.
Query Toolbar
-
Line Numbers - Toggles on/off the line numbers.
-
Search - Search for text in the query.
-
Previous - Previous result for current search.
-
Next - Next result for current search.
-
Replace One - Search and replace text in the query.
-
Replace All - Search and replace all text in the query.