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,
Mar 16, 2023 09:04 AM
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
Mar 18, 2023 08:39 PM - edited Mar 18, 2023 08:40 PM
Check out the following post which discusses details related to this question: Can a FNMS report be executed from SQL Management Studio?
Mar 18, 2023 10:55 PM