cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Retrieve the SQL query for saved views and custom reports

Retrieve the SQL query for saved views and custom reports

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.
     reports index.png

 

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.

    searchsql.png

 

For more information on the ComplianceSavedSearch table, see the schema guide ComplianceSavedSearch Table.

note blue light.pngNote: Modifications to the formatting may be required to make the query run.
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Sep 15, 2022 09:51 AM
Updated by:
Contributors