Microsoft Audit Reports

The Microsoft Audit Report retrieves data directly from the Microsoft API, enabling you to verify whether the auto-renewal status and license counts in your CloudBlue Commerce subscriptions align with Microsoft’s records. It also supports CSP-to-NCE migration planning by providing the commitment end date for CSP subscriptions that will transition to NCE upon renewal.

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

Report Insights

The report provides the following key information:

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

• Number of licenses per subscription on both Connect and Microsoft.

• Subscription creation dates on Connect and Microsoft.

• Commitment end dates of CSP subscriptions on Microsoft.

Adding the Report Template to CloudBlue Connect

Before creating the report, you must add the report template repository to CloudBlue Connect:

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

2. Open 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 Error details column will display the root cause.

Creating a Microsoft Audit Report

Once the template is added, follow these steps to create the report:

1. In the Connect Distributor portal, go to Reports > Directory and click Create Report.

2. Select the Microsoft Audit template. Review the description carefully and click Next.

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

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

5. Choose one marketplace.

6. Select Excel as the output format.

7. Click Create. The report will be generated and available in .csv format.

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