Managing Oracle Reports

CCKM provides options to generate key visibility reports based on key-related activities between CCKM and Oracle vaults and rotation schedules. Use the reports to track keys by their expiration dates.

Oracle reports are categorized as:

• Key Activity Report: Inspect individual Oracle key histories by operations, for example, when they were refreshed, rotated, edited, or deleted. Also, use this report to compare key activities between CCKM and Oracle vaults.

• Key Rotation Report: Track keys that have been rotated or will be rotated between the selected period.

• Key Aging Report: Track Oracle keys by their expiration dates. Audit a range of dates, from past material deletions to future scheduled deletions, within selected Oracle vaults.

Creating Oracle Reports

To create an Oracle report:

1. Open the Cloud Key Manager application.

2. In the left pane, click Reports > Oracle. The Oracle Reports page is displayed.

3. Click Add Report. The Choose Report Type and Name screen of the Add Oracle Report wizard is displayed.

4. Select the report type. The options are Key Activity Report, Key Rotation Report, and Key Aging Report.

5. Specify a Report Name. This is a mandatory field.

6. Click Next. The Select Oracle Vault screen of the wizard is displayed.

7. Select a vault from the Oracle Vaults drop-down list. The drop-down list contains the list of Oracle vaults added to the CipherTrust Manager.

8. Click Add. The selected vault appears under the Selected Oracle Parameters section.

   Similarly, you can add as many vaults as you want.

9. Click Next. The Set Start and End Dates screen of the wizard is displayed.

10. In the Include Entries From field, specify the start date and time for the report.

    • Click the field and select the date and time on the on-screen calender.

    • Alternatively, enter the time in MM/DD/YYYYHH:MM format.

11. In the To field, specify the end date and time for the report.

12. Click Save.

A success message Created report is displayed. The newly created report is displayed under the Oracle reports list. The report Run Date becomes Running Now and Status becomes In Progress. After the run is complete, the date and time of the run is displayed and the Status becomes Completed.

Viewing Oracle Reports

The Oracle Reports page displays the list of existing reports. Filter the reports by their names.

To view existing Oracle reports:

1. Open the Cloud Key Manager application.

2. In the left pane, click Reports > Oracle. The list of available reports is displayed. The following details of the reports are displayed:

   Column Name	Description
   Report Name	Name of the report.
   Run Date	When the report is run. If a report is running currently, Running Now is displayed.
   Type	Type of the report. The type can be: • Key Activity • Key Rotation • Key Aging
   Start Date	Start date from when the report is generated.
   End Date	End date for the report.
   Status	Status of the report. The status can be: • Completed • In Progress

Viewing Details of an Oracle Report

To view the details of an Oracle report:

1. Open the Cloud Key Manager application.

2. In the left pane, click Reports > Oracle. The list of available reports is displayed.

3. Click the desired Report Name link.

   Alternatively, click the overflow icon () corresponding to the desired report and click View.

   For a Key Aging report, the REPORT DETAILS section shows the following details of the reports:

   Column Name	Description
   Key Name	Name of the key.
   Oracle Key ID	ID of the Oracle key.
   Vault ID	ID of the Oracle vault where the key resides.
   Time of Deletion	Date and time when the key is/will be deleted.

   For a Key Activity report, the REPORT DETAILS section shows the following details of the reports:

   Column Name	Description
   Key Name	Name of the key.
   Oracle Key ID	ID of the Oracle key.
   Vault ID	ID of the Oracle vault where the key resides.
   Key Activity	Activity performed on the key.
   Oracle User	Name of the Oracle user who created the report.
   Modified Time	Date and time when the key is modified.

Downloading Oracle Reports

To download an Oracle report as a CSV file:

1. Open the Cloud Key Manager application.

2. In the left pane, click Reports > Oracle. The list of available reports is displayed.

3. Click the overflow icon () corresponding to the desired report and click Download.

   Alternatively, click the desired report under Report Name, and click Download CSV in the detail view.

The report is downloaded as a CSV file.

Deleting Oracle Reports

To delete an Oracle report:

1. Open the Cloud Key Manager application.

2. In the left pane, click Reports > Oracle. The list of available reports is displayed.

3. Click the overflow icon () corresponding to the desired report and click Delete. The Delete Report message is displayed.

4. Click Delete.

The report is removed from the list of reports.