A new Flexera Community experience is coming on November 25th. Click here for more information.
Are the saved Management View Index views saved to a table in the database? We are on FNMS 2020 R2 on-premises.
‎Mar 24, 2021 03:04 PM
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.
‎Mar 24, 2021 06:07 PM
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.
‎Mar 24, 2021 06:07 PM