Technology > Features > Management > Query Language

Query Language

AggreGate Server has an 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:

• Viewing/editing multiple properties of multiple resources/devices in a single aggregated table.
• Finding/filtering some data and trigger and alert if data found matches some condition.
• Building a report.
• Exporting data to an external system or file.
• Sorting and filtering existing tabular data.

AggreGate Server 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. Your query cannot select data that you’re not allowed to see. Queries may be refined using an internal debugger. A query may also prompt for some parameters before execution.

Update Queries

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.