gymason1
Occasional contributor

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
erwinlindemann
Consultant

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

1 Reply
erwinlindemann
Consultant

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