The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. Click here for more information.

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

FNMS Management View Index views

gymason1
By
Level 4

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

(1) Solution

erwinlindemann
By Level 9 Champion
Level 9 Champion

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
By Level 9 Champion
Level 9 Champion

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.