Managing Azure Reports

CCKM provides options to generate key visibility reports based on:

• Key-related activities between CCKM and Azure Vault

• Track keys by their expiration dates

• What applications are using the keys

Azure reports are categorized as:

• Key Activity Report: Inspect individual Azure 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 Azure Vault.

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

• Service/Usage Report: Monitor key usage by tracking services and applications consuming the keys. View when and where a service requests the use of each key.

Prerequisites

For managing Azure reports on CCKM, you need an Azure Log Analytics workspace ID. This ID needs to be configured in the Diagnostic settings of the key vault for which reports need to be generated. To determine the workspace ID:

1. Configure Log analytics workspace. Refer to Create a Log Analytics workspace in the Azure portal for details.

2. Determine the Workspace ID of the desired Log Analytics workspace. Click the workspace name to view its details including the Workspace ID.

3. Navigate to the Key vaults page. This page shows the list of existing Azure key vaults.

4. Perform the following steps:

   1. Under Name, click the desired key vault. The <key-vault> page is displayed.

   2. Click Diagnostic settings > Add diagnostic setting.

   3. Specify a Diagnostic setting name.

   4. Under Category details, select AuditEvent and AllMetrics.

   5. Under Destination details:

      1. Select Send to Log Analytics workspace.

      2. Select the desired Subscription from the drop-down list.

      3. Select the desired Log Analytics workspace from the drop-down list.

5. Save the changes.

The changes may take some time to take effect. After the changes are effective, you can manage Azure reports on CCKM, as described below.

Creating Azure Reports

To create an Azure report:

1. Open the Cloud Key Manager application.

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

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

4. Select a report type. The options are:

   • Key Activity Report

   • Key Aging Report

   • Service/Usage Report

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

6. Click Next. The Select Analytics Parameters screen of the wizard is displayed.

7. Select an Azure Vault from the drop-down list.

8. (Not applicable to Key Aging Report) Specify a Workspace ID. Refer to Prerequisites for instructions to determine the Workspace ID.

9. Click Add. The selected Azure Vault is displayed under Selected Log Analytics Parameters. Add more vaults, if required.

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

11. 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.

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

13. Click Save.

A success message Created report is displayed. The newly created report is displayed under the Azure reports list. The report status becomes Running Now.

Viewing Azure Reports

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

To view existing Azure reports:

1. Open the Cloud Key Manager application.

2. In the left pane, click Reports > Azure. 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.
   Type	Type of the report. The type can be: • Key Activity Report • Key Aging Report • Service/Usage Report
   Start Date	Start date from when the report is generated. If a report is run now, its status becomes Running Now.
   End Date	End date for the report.

Viewing Details of an Azure Report

To view the details of an Azure report:

1. Open the Cloud Key Manager application.

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

3. Click the desired Report Name link. The details of report are displayed.

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

Downloading Azure Reports

To download an Azure report as a CSV file:

1. Open the Cloud Key Manager application.

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

3. Click the overflow icon () corresponding to the desired alias 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 Azure Reports

To delete an Azure report:

1. Open the Cloud Key Manager application.

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

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

4. Click Delete Report.

The report is removed from the list of reports.