IMRUSERATTR6 Reporting Database Table Structure and Purpose

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

The IMRUSERATTR6 table is a component of the Reporting Database Schema, specifically associated with Snapshot Reports. This article outlines the table's purpose, structure, and the data it stores.

Environment

Identity Manager 14.x

Resolution

The IMRUSERATTR6 table is created by the ims_mssql_report.sql script located in the installation directory: ./opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/imrexport/db/SqlServer/ims_mssql_report.sql.

This table stores attributes of users associated with each report snapshot.

Table Structure:

Column	Data Type	Description
imr_reportid	integer	Unique identifier for the snapshot.
imr_userdn	nvarchar(628)	User Distinguished Name (unique identifier).
imr_attrname	nvarchar(255)	Name of the user-related attribute.
imr_attrvalue	nvarchar(628)	Value of the user-related attribute.

It is highly recommended to perform a backup of the snapshot database before executing any delete operations.

1. Access Snapshot Tasks: Log in to the Identity Manager UI with an account possessing permissions to manage reporting or snapshot tasks (System Manager accounts typically have this access by default).

2. Navigate to Management:

   • Select the Reports tab.
   • Select Snapshot tasks.
   • Choose Manage Snapshot Definitions > Modify Snapshot Definition.

3. Identify Snapshots:

   • Perform a search to locate and select the snapshot definition from which you wish to remove instances.

4. Execute Deletion:

   • Go to the Maintenance tab.
   • Select the specific snapshot instances you wish to remove.
   • Click Delete.