Identifying Custom Attribute column name in RSA Governance & Lifecycle
3 months ago
Originally Published: 2015-05-27
Article Number
000067295
Applies To
  • All versions of RSA Governance & Lifecycle
Issue

It is very common for users to define many custom attributes while using G&L. However, these custom attributes map to database columns with pre-defined names, such as CUS_ATTR_1. To determine what custom attribute value maps to what database column, based solely off of the content of the column, is unlikely.

Resolution

To determine which Custom Attribute maps to which column, review the T_AV_CUSTOM_ATTRIBUTES table. This table stores the mappings and shows  which Custom Attribute maps to which column. 

To do so from the GUI, navigate to Admin > Attributes > User. From table options, add Database ID as per the below screenshot to get the column name:

capture_241224_201039.png

Notes

Do not manually change these internal tables, as unauthorized changes violate the support agreement. Any required modifications must be validated by raising a Technical Support ticket.