A new Flexera Community experience is coming on November 25th. Click here for more information.

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

FNMS Management View Index views

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

(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

(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.