Skip Headers
Oracle® Identity Manager Administrative and User Console Guide
Release 9.0
B25936-01
  Go To Documentation Library
Home
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

14 Reports

Based on whether you access current operational data or historical data, the reports you can generate using Oracle Identity Manager are divided into Operational Reports and Historical Reports. This section describes how to run reports detailing the resources available to the users. There are two kinds of reports; Operational Reports and Historical Reports.

This chapter describes the standard operational and historical reports supported by Oracle Identity Manager in the following sections:

Overview of Operational Reports

The following sections describe the out-of-box operational reports in Oracle Identity Manager.

Who Has What (Users' Entitlements)

This report provides administrators or auditors the ability to query entitlements for users that match the query parameters. This report can be used for operational and compliance purposes. This is an operational report, not a historical report.

Resource Access List

This report provides administrators or auditors the ability to query all existing users provisioned to a resource. This report can be used for operational and compliance purposes. This is an operational report, not a historical report.

Overview of Historical Reports

The following sections describe the out-of-box historical data reports in Oracle Identity Manager.

User Access History (Who Had What)

This report provides administrators or auditors the ability to view user's resource access history over user's lifecycle. This report can be used for compliance and forensic auditing purposes. This is not a user access profile snapshot report. This is a lifetime report showing entire history of user's entitlements.

Resource Access List History

This report provides administrators or auditors the ability to query all users provisioned to a resource over its lifecycle. This report can be used for compliance and forensic auditing purposes. This is not a resource access list snapshot report. This is a lifetime report showing entire history of resource's access list / entitlements.

User Profile History

This report provides administrators or auditors the ability to view user's profile history over user's lifecycle. This report can be used for compliance and forensic auditing purposes. This is not a user profile snapshot report. This is a lifetime report showing entire history of user's profile.

Running Reports

To run a Report:

  1. Expand the Reports link and click Operational Reports or Historical Reports. The resulting screen displays a list of all the reports of that type that are available to the user. The reports are listed in a table with the following fields:

    Field Description
    Report Name Shows the unique name of the operational report, which is also a hyperlink to the input parameters for that report
    Report Code Identifies a unique alpha numeric code for the report
    Report Type Identifies the report type to help administrators organize their reports
    Description Provides a short description of the report

  2. Select a report by clicking on its name. The Report Input Parameters screen appears. The Report Input Parameters screen displays the input parameters that need to be provided to run a report. In some cases, at least one or more input parameter fields will be required fields, that is these fields must be filled. If this is not the case, then you must populate at least one of the fields to run a report.

  3. Enter the information required to identify what information the report contains.

  4. Click the submit button to run the report. The Report Display page appears.

Report Display

This page shows the report content. Three different display formats are available. The format information is included in the report meta data associated with each report. The three display formats are:

By default, only 50 records appear on each page. This limit can be changed in the properties file. If there are multiple pages, then the First, Previous, Next, and Last navigation links at the top and bottom of the page are active.

Filters

The filter capability is to narrow the search criteria for a report. By default, three filters appear as a drop-down and a text field. Select the type of data from the drop-down, then enter a filter string in the text field. The asterisk (*) wildcard character can be used in the filter text box. An asterisk will represent any number of characters. For example, S*t will match Slashdot and Sat.

Filters narrow down the existing report, they do not generate a new report. For example, if the report is run with input parameter as [First Name=j*] (returns all records where the first name starts with 'j'), and then it is filtered again with [Last Name=Smith], this will return only those records which have first name starting with j, and last name as Smith.

Once the filter input is provided and the Filter button is clicked, the resulting report will be displayed on the same Report Display Page. The filter dropdowns and text boxes will reflect the filter values that were provided. The Clear button clears the filter fields.

Change Input Parameters

The Change Input Parameters button returns you to the Input parameters page. The input parameter fields contain the information you already entered.

CSV Export

You can export all the report information as a single Comma Separated Values file, or CSV. Clicking on the CSV Export button prompts the user with a popup window to save the CSV file locally on the user's computer. By default, the name of the file is <report code>.csv.

Detail Page Links

The resource names and user IDs listed in the report may be links. Clicking these links opens a new Detail Page with more detailed information on that resource or user id.

Creating Reports Using Third-Party Software

Oracle Identity Manager supports the creation of reports using third-party tools like Crystal Reports. It supports the following out-of-the-box report types: