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