EV Observe - Monitor Microsoft 365 Data
Microsoft 365 provides usage reports that enable you to obtain information on how Microsoft 365 services are used, e.g. Exchange, Teams, Office 365, OneDrive, SharePoint, Skype for Business and Yammer.
- The reports are available in the Microsoft 365 admin center.
See List of usage reports - You can access resources and reports and retrieve Office 365 metrics using the Microsoft Graph API. See the API documentation
Microsoft 365 metrics
Overall service usage
- You can view these metrics in charts in usage reports and retrieve them using the Microsoft Graph API.
- In EV Observe, you can retrieve them using the Office365-Generic service template. See the procedure
| OneDrive service usage | Exchange service usage | |
|---|---|---|
| Number of files by activity See the API documentation
|
Number of actions by type See the API documentation
|
Service usage by user
- You can view these metrics in tables displayed below the charts. There is one row per user.
- You will be able to monitor this data using a new service template in a future EV Observe version.
| OneDrive service usage |
|---|
| Number of files by activity for each user See the API documentation
|
Notes
- Only overall usage data for a Microsoft 365 service can be collected by the Office365-Generic service template.
Procedures
How to determine if a metric can be collected using the Office365-Generic service template
Using the Microsoft 365 admin center
1. Go to the Microsoft 365 admin center.
2. Search for the relevant metric by selecting Reports > Usage in the menu.
3. Check if the information you want is available in the chart.
- The data is displayed: You can monitor and collect the data using the Office365-Generic service template.
- The data is not displayed: You cannot monitor the data.
example You can monitor and collect data on the number of Office365 license activations
Using the Microsoft Graph API documentation
1. Go to the Microsoft Graph API documentation.
2. Select the service and metric you want to monitor.
3. Check if the User Principal Name field is present in the answer.
- The field is absent: You can monitor and collect the data using the Office365-Generic service template.
- The field is present: You cannot monitor the data.
example You can monitor and collect data on the number of Office365 license activations
How to retrieve data on overall service usage
Prerequisites
- You must first configure Azure and Office 365 monitoring prerequisites prior to using service templates based on Azure and Office 365 services.
See the detailed procedure
Step 1: Set up overall usage monitoring for a Microsoft 365 service using the Office365-Generic service template
1. Go to the Web app.
2. Create a new service template.
- Select Configuration > Services > List in the menu.
- Click + Add in the Mode: Box tab.
- Specify the information below.
General information tab
- Service template: Select the Office365-Generic service template.
- Name: Enter the name of the new service you want to create.
Availability and checks tab
example Monitor the overall amount of storage used for OneDrive
- API Request: Request used to retrieve the metric.
- See the relevant documentation for each Office 365 metric.
- See the relevant documentation for each Office 365 metric.
- Fields to process: CSV fields returned by the API if the request is successful.
- Each Office 365 service has its own CSV fields. See the relevant documentation for each Office 365 metric.
- The values retrieved are stored in variables $VAR1, $VAR2, $VAR3, etc. in the order defined in the parameter.
- You should separate each field using the | character.
- Each Office 365 service has its own CSV fields. See the relevant documentation for each Office 365 metric.
Calculation: Calculation to be run on the metrics retrieved by the request.* Exponentiation operator: **.
example Calculation to modify the unit
- The value retrieved is in Bytes.
- It is converted into Terabytes using the $VAR1/1024**4 calculation.
- The calculation uses variables $VAR1, $VAR2, $VAR3, etc. retrieved in the Fields to process parameter.
example $VAR2*100/$VAR1
- Performance data: Name of the performance data for metric charts.
- Output text: Text displayed in the Web interface.
- The $RESULT variable contains the value retrieved by the service template or the result of the Calculation parameter.
- Click Validate.
Step 2: Check that Microsoft 365 overall usage data is correctly displayed in the Web app
1. Select Dashboard > Dataviz in the menu.
2. Create a dataviz to display the monitoring results of the new service template.
