Microsoft Audit Reports

This report obtains information from the Microsoft API, which you can use to check if the auto-renewal status and the number of licenses in the CloudBlue Commerce subscriptions is aligned with the information obtained from Microsoft. In addition, the report helps you to plan the migration of CSP subscriptions to NCE, as it provides the commitment end date of the CSP subscriptions which will be migrated to NCE on the renewal date in 2024.

The report can be created for one marketplace at a time and it can be configured to show data for a period of less than two months.

The report allows you to obtain the following information:

• The auto-renewal status of NCE active subscriptions on Microsoft.

• Number of licenses in each subscription on Connect and Microsoft.

• Subscription creation date on Connect and Microsoft.

• Commitment end date of CSP subscriptions on Microsoft.

Adding the Report Template to CloudBlue Connect

Before creating the report, it is necessary to add the repository containing the report template to CloudBlue Connect. To do this, complete the following steps:

1. In the Distributor portal, go to Home > Reports.

2. Click the Repositories tab, click Add Repository and enter the following GitHub repository URL containing the report template: https://github.com/cloudblue/microsoft_reports

3. Select the tag corresponding to the latest version.

Note: If any errors occur during the report generation, the root cause will be displayed in the Error details column.

Creating a Microsoft Audit Report

Once you have added the report template to CloudBlue Connect, you will be able to configure a report based on such template. To do this, complete these steps:

1. Go to Reports > Directory in the Distributor portal and click Create Report.

2. Select the Microsoft Audit template. A description of the report is displayed. Read the description carefully and click Next.

3. Select a date range for the report. The specified period must be less than two months.

4. Select the transaction type (production or test).

5. Select only one marketplace.

6. Select the Excel output data format.

7. Enter the report name and, optionally, a description. Then, click Create. Once it is created, the report will be available in .csv format.

Note: CloudBlue Connect also allows you to create scheduled reports. For additional information, refer to the documentation in the CloudBlue Connect community.