EV Observe - Monitor Microsoft 365 Data

Last modified on 2023/07/03 19:38

Office365-Generic service template available from EV Observe 4.1 onwards

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. Open url.png See List of usage reports
  • You can access resources and reports and retrieve Office 365 metrics using the Microsoft Graph API. Open url.png See the API documentation

         Reports from Microsoft 365.png

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. Open url.png See the procedure
     
OneDrive service usage Exchange service usage
Number of files by activity   Open url.png See the API documentation

Global usage data - OneDrive.png

Number of actions by type   Open url.png See the API documentation

Global usage data - Exchange.png

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   Open url.png See the API documentation

User usage data - OneDrive.png

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

    Administration center - Example Get activation counts.png

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

    API Microsoft Graph - Example Get activation counts.png

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.
       Open url.png 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.
            Office365-Generic configuration.png

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

    Office365-Generic configuration - Avaibility and checks.png

  • API Request: Request used to retrieve the metric.
    • See the relevant documentation for each Office 365 metric.
         Office365-Generic configuration - Example API report.png
  • 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.
         Office365-Generic configuration - Example API fields.png
    • 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.
  • 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.

         Office365-Generic - Display via dashboard.png

         Office365-Generic - Display via dataviz.png

Tags:
Powered by XWiki © EasyVista 2022