All saved views and custom reports created using the FlexNet Manager Suite report builder are SQL-based. You can retrieve them from the compliance database by querying the ComplianceSavedSearch table.
1. Open the FlexNet Manager Suite web UI and copy the report name.
2. Run the following query on the compliance database:SELECT * FROM ComplianceSavedSearch WHERE SearchName LIKE %EXAMPLE REPORT%
The SearchName column of the associated record matches the saved name of the report in your web UI.
3. TheSearchSQLcolumn of the associated record shows the complete SQL query.
For more information on the ComplianceSavedSearch table, see the schema guide ComplianceSavedSearch Table.