Microsoft Audit Reports

This report retrieves data directly from the Microsoft API, allowing you to check if the auto-renewal status and the license count in the CloudBlue Commerce subscriptions match Microsoft's records. It also supports CSP-to-NCE migration planning by providing the commitment end date of the CSP subscriptions that will be migrated to NCE upon renewal.

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.

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 Connect 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 Connect 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 CloudBlue Connect documentation.