Database Console
Use this page to access Flexera’s SQL database. You can access the content of each table by selecting the table name in the Tables pane. Expand the table name to view the objects and data types within that table.
To create an SQL query, right-click a table and select Show Data to automatically create a SELECT * FROM table query from the specific table. You can also right-click a table and select Schedule Query to create Scheduled Exports for the table and save the output to a CSV file.
The Details and Results panes display the status of the query.
Summary of the SQL Data in the Database Console Tables
The following table lists the SQL Data in the Database Console Tables:
| SQL Data | Description |
|---|---|
| vw_csi_devices | List of hosts with mac address & ip address |
| vw_csi_devices_cve | List of hosts affected by CVE |
| vw_host_eol | List hosts with End of Life software |
| vw_host_unpatched_os | List hosts with insecure operating system and operating system version |
| vw_host_insecure | List hosts with insecure software and software version |