Summary

This article explains details about reporting which are supported for automation module of Microsoft CSP in Machpanel.

Applies To

MachPanel Build v7 and later.

Reports for Automation Module of Microsoft CSP 

• We have a Subscription Reconcilation Report in CSP Accounts, navigate to the path: Home > Service Director > Microsoft CSP Management > Accounts
• It is available to Providers Only.
• On clicking Export Subscription Reconcilation Report following data is shown in Excel: Customer, Customer Company Name, Owner, Tenant, SubscriptionInPanel, PanelQuantity, PanelStatus, SubscriptionInMicroSoft, Quantity, Status, DateUpdated
  
• If a record exists in panel but not in backend, show SubscriptionInMicrosoft = Blank, Quantity = 0, Status = Unknown,
  
• Similarly applies for a subscription in backend but not in panel.
  

​

Other than "Subscription Reconcilation Report", following types of reports are supported for Automation Module of Microsoft CSP in MachPanel:

1. Subscriptions Report
2. Usage Report
3. Monthly Reseller Report
4. Trial Subscriptions
5. License Usage Report
6. Price Report

Subscriptions Report

Under Summary tab you can see the reports in graphic form.

Under Details tab you can see export to excel and PDF as per your requirement.

Usage Report

To view CSP usage report, navigate to the path below: Home » Service Director » Microsoft CSP » Usage Report. You can export Usage Reports to Excel by clicking Export to Excel button.

You can view and export following types of Usage Reports:

• Microsoft CSP Usage Report

Under tab Microsoft CSP Usage Report, you can view following:

Customer Name, Company Name, Owner, Tenant Name, Active users, Deleted users, Total Users, Domains, User Mailboxes, Shared Mailboxes, Room Mailboxes, Equipment Mailboxes, Skype4B Users, Distribution Groups, Dynamic Distribution Groups, Mail Enabled Security Groups, Simple Security Groups, Microsoft CSP Groups, Mail Contacts, Date Created, Last synced at.​​

​

• Microsoft 365 Subscription Usage Report

Under tab O365 Subscription Usage Report, you can view following:

Customer, Customer number, Company Name, Owner, Tenant Name, Linked With Local Org, Subscription Name, Offer Name, Microsoft Offer Id, Is AddOn, Quantity, Status, Category Name, Package Name, Profile Name, Setup date, End Date, Suspend Date.

• Detailed Usage Report

Under tab Detailed Usage Report, you can view following:

Customer Name, Customer number, Company Name, Owner, Tenant Name, Display name, User Principal Name, Licenses, User Roles, Sign-In Status, Deleted, Mailbox type, Skype4B Enabled.​​

​

• Azure Usage Report

Under Azure Usage Report you can view Azure Usage reports.​​

​

• Direct Routing Report

​

Monthly Reseller Report

To view monthly reseller report navigate to following path: Home » Service Director » Microsoft CSP » Monthly Reseller Report 

You can Search reports and Export to Excel. You can view following under Summary tab:

1. Subscription Name: It shows the subscription name.   
2. License Quantity: It shows the number of license.   
3. Price for Reseller: It shows the price for reseller.
4. Total: It shows total.

You can view detailed report under Details tab:

1. Customer: It shows name of customer    
2. Company name: It shows company name   
3. Owner: It shows owner name.   
4. Tenant Name: It shows tenant name.   
5. Start Date: It shows starting date.   
6. Suspend Date: It shows suspend date.   
7. Subscription Id: It shows subscription id.   
8. Subscription Name: It shows subscription name.   

​

Trial Subscriptions

To view Trial subscriptions navigate to following path: Home » Service Director » Microsoft CSP » Trial Subscriptions

You can filter Trial Subscriptions by following:

1. Company Name (Owner)
2. Customer ID
3. Tenant Name
4. Select Status

License Usage Report

To view License Usage Report navigate to the path mentioned below: Home » Service Director » Microsoft CSP » License Usage Report.

You can Search reports by following:

1. Company Name (Owner)
2. Customer 
3. Company Name
4. Tenant
5. Domain
6. License

You can view following under License Usage Report

1. Customer: It displays customer name along with ID.   
2. Company Name: It displays company name.  
3. Owner: It displays owner.  
4. Tenant: It displays tenant name, domain name.   
5. License: It displays license in use.
6. Active Units: It displays active units.  
7. Consumed Units: It displays consumed units.      
8. Locked Out Units: It displays locked out units.      
9. Suspended Units: It displays suspended units.  
10. Warning Units: It displays warning units.

Tenant Price Report

To view CSP tenant price and package price report navigate to the path mentioned below: Home » Service Director » Microsoft CSP » Price Report

Select Tenant Price Report tab. You can Search reports by following and Export to Excel.

​

1. Select Profile
2. Select Package
3. Offer Name

Following listing will be shown.

1. Tenant    
2. Offers/Add-ons    
3. Offer ID    
4. Status    
5. Price

Package Price Report

Select Package Price Report tab. You can Search reports by following and Export to Excel.

​

1. Select Profile
2. Select Package
3. Offer Name

Following listing will be shown.

1. Tenant    
2. Offers/Add-ons    
3. Offer ID    
4. Status    
5. Price