Your suggested change has been received. Thank you.

close

Suggest A Change

https://thales.na.market.dpondemand.io/docs/dpod/services/kmo….

Thales Logo

All

  • All
back

Oracle Cloud Resources

Managing Oracle Reports

search

Please Note:

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

Note

OCI supports key rotation reports for a period of maximum 14 days. When generating key rotation reports, make sure that the period between the start and end time is not more than 14 days.

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 NameDescription
    Report NameName of the report.
    Run DateWhen the report is run. If a report is running currently, Running Now is displayed.
    TypeType of the report. The type can be:
    • Key Activity
    • Key Rotation
    • Key Aging
    Start DateStart date from when the report is generated.
    End DateEnd date for the report.
    StatusStatus 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 (ellipsis) 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 NameDescription
    Key NameName of the key.
    Oracle Key IDID of the Oracle key.
    Vault IDID of the Oracle vault where the key resides.
    Time of DeletionDate 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 NameDescription
    Key NameName of the key.
    Oracle Key IDID of the Oracle key.
    Vault IDID of the Oracle vault where the key resides.
    Key ActivityActivity performed on the key.
    Oracle UserName of the Oracle user who created the report.
    Modified TimeDate 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 (ellipsis) 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 (ellipsis) 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.

On this page