Action Plan attachments

Products

• Information Centric Analytics

Issue/Introduction

When files are attached to action plans in the Information Centric Analytics (ICA) portal, where are those files stored? Is it possible to retrieve or restore them individually or in bulk?

Environment

Version : 6.x

Component : Action Plans

Resolution

Files attached to action plans are Base64 encoded and stored in the RiskFabric relational database in the table dbo.LDW_Attachments using the CLOB datatype nvarchar(max). The original files are not removed from the filesystem nor moved to a new location.

Individual files may be downloaded from action plans using the download icon when viewing an action plan's details. Bulk selection of files is not permitted.

ICA does not provide a method for exporting or restoring the contents of the dbo.LDW_Attachments table. Broadcom recommends regularly creating backups of the RiskFabric relational database for disaster recovery, archival, and audit purposes, though neither of these processes are supported directly by Broadcom. If you require assistance with creating or restoring a copy of the RiskFabric database, contact your database administrator.