Export sql of a report

tallal85 · ‎Mar 16, 2023

Hi,

How to find the sql associated with a report that we created via the FNMS Webui ???? (Then via a sqlcmd and the Windows task scheduler)? Has anyone done this stored procedure method before?

Regards,

tjohnson1 · ‎Mar 18, 2023

The data is stored in the SearchSQL column of the ComplianceSavedSearch table: https://docs.flexera.com/FlexNetManagerSuite2022R2/EN/Schema/index.html#SysRef/schema/ComplianceSchema/Compliance.Logic.CoreTables/reference/ComplianceSavedSearch.html

ChrisG · ‎Mar 18, 2023

Check out the following post which discusses details related to this question: Can a FNMS report be executed from SQL Management Studio?

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)