Summary

This page highlights the tables that CSUM creates and what each table is used for and if they can potentially store PII data

Tables

AO_45ED26_AUDITING NO PII Data

This table is used to store Audit records of Group changes that occur within CSUM. For example, group deletion, user addition/removal.

AO_45E2D6_BAD_GROUPNAMES NO PII Data

This table is used to store groups that have been found to contain uppercase characters, as Confluence no longer supports groups that contain uppercase characters. CSUM stores this information as it has a feature within the System Admin configuration to change these groups to lowercase.

See the following for more information: Admin: Operations

AO_45E2D6_CONFIG NO PII Data

This table is used to store the Space Group Config within the System Admin Configuration.

AO_45E2D6_DLG_AUTH_GROUP NO PII Data

Table is used to store the Groups that it’s members have been authenticated to manage a delegated group.

AO_45E2D6_DLG_AUTH_USER NO PII Data

Table is used to store the User that have been authenticated to manage a delegated group.

AO_45E2D6_DLG_GROUP NO PII Data

Table is used to store the delegated Groups that will be modifiable by authenticated users.

AO_45E2D6_GROUP_FIX_STATUS Contains PII Data

This table was used to store the status of the Bad GroupNames feature. However, this feature has been deprecated and no longer functions which means that this table is no longer used/updated.

Columns that contains PI/SPI Data:

1. init_user - Stores the User Name of the user that triggered the GroupName update.

AO_45E2D6_LDAPCONF Contains PII Data

This table is used to store LDAP configuration.

Columns that contains PI/SPI Data

1. Password - Stores the password that is used for LDAP connections

2. Username - Stores the username that is used for LDAP connections

3. test_lookup_username - Stores the username to use when testing the LDAP

4. user_password_attr - Due to a bug this column is currently storing the LDAP connection password

AO_45E2D6_TASKS Contains PII Data

This table is used to store background Task audit records. Allowing review of Tasks that have run previously.

Columns that contains PI/SPI Data

1. initiating_user - Stores the username of the initiating user

2. successful_users - Stores a list of usernames that were successfully updated

3. unsuccessful_users - Stores a list of usernames that were unsuccessfully updated