Hi all,
Simple question: I have a customer that has a custom report they use weekly, and someone found there were a bunch of alterations made to the report. They have asked if it is possible to see any details of who may have made/saved the changes to the report?
Thanks in advance.
‎May 30, 2023 11:32 PM
If you're talking FNMS on-prem, you might not find out all the changes, but the latest change. The reports are stored in the table "ComplianceSavedSearch" and the columns "ModifiedBy" and "ModificationDate" should tell you who did the latest modification to the report. "SearchName" is the name of the report.
SELECT
SearchName
,ModificationDate
,ModifiedBy
FROM ComplianceSavedSearch
As far as I know, there's no option to set reports to read-only in the WebUI. But if you deployed the report as SQL report (customization), it couldn't be changed from the WebUI.
The FNMS roles & rights model does not seem to help if you want users to be able to create their own reports, "Create, modify or delete" is all one option.
‎May 31, 2023 05:10 AM
If you're talking FNMS on-prem, you might not find out all the changes, but the latest change. The reports are stored in the table "ComplianceSavedSearch" and the columns "ModifiedBy" and "ModificationDate" should tell you who did the latest modification to the report. "SearchName" is the name of the report.
SELECT
SearchName
,ModificationDate
,ModifiedBy
FROM ComplianceSavedSearch
As far as I know, there's no option to set reports to read-only in the WebUI. But if you deployed the report as SQL report (customization), it couldn't be changed from the WebUI.
The FNMS roles & rights model does not seem to help if you want users to be able to create their own reports, "Create, modify or delete" is all one option.
‎May 31, 2023 05:10 AM