Moving a custom report from one FNMS instance to another

[jasonlu]

Assuming two separate single tenant FNMS on Premises with no custom properties, is there a way to move a custom report from one instance to another?

I'm assuming we could try just grabbing the row in the dbo.ComplianceSavedSearch table, and export/import that.

Would it work?

j

[ChrisG]

Yes, you're going in the right direction there. The main columns from ComplianceSavedSearch that define the report details are:

• SearchXML
• ComplianceSearchTypeID
• SearchMapping
• SearchGridLayout

(That's not to say other columns aren't important, but if you focus on data from the above columns to start with you'll get most of the way there to replicating the report configuration in another environment.)

[jevans · Accepted solution]

Agree with Chris here.

The only other thing that springs to mind for me is potentially changing the CreatedByOperatorID / RestrictedAccessTypeID.
The other columns referring to Users are plaintext, CreatedByOperatorID is a ComplianceOperatorID reference and RestrictedAccessTypeID will outline whether it's private or public.
I'd potentially set CreatedByOperatorID to a ComplianceOperatorID that exists on the new system, and ensure RestrictedAccessTypeID is set to 1.

Best regards,
Jack