Queries allow you to poll ePO - On-prem data. Information gathered by queries is returned in the form of charts and tables.
A query can be used to get an answer right now. Query results can be exported to several formats, any of which can be downloaded or sent as an attachment to an email message. Most queries can also be used as dashboard monitors, enabling near real-time system monitoring. Queries can also be combined into reports, giving a more broad and systematic look at your ePO - On-prem software system.
The default dashboards and predefined queries shipped with ePO - On-prem cannot be changed or deleted. But you can duplicate them, then rename and change them as needed.
Query results are actionable
Query results displayed in tables have actions available for selected items. Actions are available at the bottom of the results page.
Queries as dashboard monitors
Most queries can be used as a dashboard monitor (except those using a table to display the initial results). Dashboard monitors are refreshed automatically on a user-configured interval (five minutes by default).
Exported results
Query results can be exported to four formats. Exported results are historical data and are not refreshed like other monitors when used as dashboard monitors. Like query results and query-based monitors displayed in the console, you can drill down into the HTML exports for more detailed information.
Unlike query results in the console, you cannot select an action when viewing exported data.
You can export to these file formats:
CSV — Use the data in a spreadsheet.
XML — Use the data for scripts or applications.
HTML — View the exported results in a browser.
PDF — Save the exported results to read or print later.
Combining queries in reports
Reports can contain any number of queries, images, static text, and other items. They can be run on demand or on a regular schedule, and produce PDF output for viewing outside ePO - On-prem.
Sharing queries between servers
Any query can be imported and exported, allowing you to share queries between servers. In a multi-server environment, you only have to create a query once.
Retrieving data from different sources
Queries can retrieve data from any registered server, including databases external to ePO - On-prem.