AggreGate Server features integrated query language for retrieving and managing device and system data. It is similar to Structured Query Language (SQL). Most SQL clauses are supported, including SELECT, JOIN, FROM, WHERE, GROUP BY, HAVING, UNION, ORDER BY, and LIMIT.
Queries are useful for:
Query Language Concept
AggreGate's unifed data model acts as a large database with many tables. Every property of a device or a system resource acts like a normal database table and, thus, can be queried. AggreGate queries are processed under a strict access control model. A query executed under your control cannot select data that you’re not allowed to see.
Queries may be refined and optimized using an internal debug tool. A query may also prompt for some parameters before execution.
Unlike classic SQL, AggreGate query language has no INSERT and UPDATE statements. However, query results may be modified using the GUI. For example, if you select several properties of several devices in a single table, you can edit the cells of this query and all modified data will be written back to its original location.