Adding custom attributes to an existing query subject

The static report does not show an email address. You can configure the report model to add custom attributes such as, an email address. The scenario describes how to configure model so that you can view or drag the email addresses of the users in the reports.

1. Add the E-mail property to the ISIM database schema.
   1. In the IBM Verify Identity Governance console, select Reports > Schema Mapping.
   2. From the Entities list, select Person entity.
   3. From the unmapped attribute list, select E-mail address.
   4. Click Add.
2. Run the data synchronization tool.
   1. Select Reports > Data Synchronization.
   2. Click Run Synchronization Now.
3. Add the information about email address in the ISIMReportingPackage_6.0.0.6.zip.
   1. Open the Framework Manager.
   2. Extract the ISIMReportingModel_6.0.0.6.zip to the local disk.
   3. Open the .cpf file in the ISIMReportingModel_6.0.0.6 folder.
   4. Right click the IBM Identity Security Manager (ISIM) namespace and select Run Metadata Wizard.
   5. From the Metadata Wizard window, select Data Source and click Next.
   6. Select ISIM and click Next.
      You must use the data source name as ISIM.
   7. Select the ITIMUSER object and click Tables.
   8. Select the PERSON_MAIL table and click Next.
   9. Clear the Use primary and foreign keys check box.
   10. Click Import.
   11. Click Finish.
4. Create a relationship between the PERSON and PERSON_MAIL table.
   1. Hold the Ctrl key and select the PERSON and PERSON_MAIL tables.
   2. Right click and select Create > Relationship.
   3. Set the Cardinality of the following items:
      • PERSON table to 1..1
      • PERSON_MAIL table to 0..1
   4. Click OK.
5. Publish the modified model.
   1. In the Framework Manager console, expand Packages.
   2. Right click the metadata model and click Publish Packages.
   3. Click Next twice.
   4. Click Publish.
   5. If the package was published previously, a message prompts for the confirmation. Click Yes.
   6. Click Finish.