Some users may experience issues accessing the case portal. For more information, please click here.

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

FNMS Management View Index views

Jump to solution

Are the saved Management View Index views saved to a table in the database? We are on FNMS 2020 R2 on-premises.

0 Kudos
1 Solution

Yes, the views in the "Management View" area in the FNMS Web UI are stored in the [EcmSettings] table in the  [FNMSCompliance] database. If you truncate this table, all customized views in the FNMS Management View Index section that have been saved by any user will be lost.

Basically, this works similar to when a user customizes a view by adding additional columns or by applying a filter. In the [EcmSettings] table, FNMS stores the ID of the current user ([ComplianceOperatorID] column), the view and action ([SettingKey] column) in a URL like format like (ctx://Applications/List_Grid/Installed/View/67) and the actual settings for the view in XML format ([SettingValueString] column).

Unfortunately, there is no documentation specifically on the meaning of the XML data in the [SettingValueString] column in this table.

View solution in original post

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

1 Reply

Yes, the views in the "Management View" area in the FNMS Web UI are stored in the [EcmSettings] table in the  [FNMSCompliance] database. If you truncate this table, all customized views in the FNMS Management View Index section that have been saved by any user will be lost.

Basically, this works similar to when a user customizes a view by adding additional columns or by applying a filter. In the [EcmSettings] table, FNMS stores the ID of the current user ([ComplianceOperatorID] column), the view and action ([SettingKey] column) in a URL like format like (ctx://Applications/List_Grid/Installed/View/67) and the actual settings for the view in XML format ([SettingValueString] column).

Unfortunately, there is no documentation specifically on the meaning of the XML data in the [SettingValueString] column in this table.