Skip to main content
waffle.svg
Domo Knowledge Base

Microsoft Exchange Metrics REST Connector

Intro

Microsoft Exchange Server is a mail server or messaging platform which works as a centralized hub with mailboxes for storing users' mail. Use this connector to view information about user details, email activity, and more. To learn more about Microsoft Exchange Server, visit their page (https://docs.microsoft.com/en-us/exc...xchserver-2019).

You connect to your Microsoft Exchange Metrics REST account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft Exchange Metrics REST connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

To connect to your Microsoft Exchange Metrics account and create a DataSet, you must have the following:

  • A customer client ID and client secret obtained from your Web App

  • Microsoft account credentials

Connecting to Your Microsoft Exchange Metrics Account

This section enumerates the options in the Credentials and Details panes in the Microsoft Exchange Metrics Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your Microsoft Exchange Metrics account. The following table describes what is needed for each field:  

Field

Description

Client ID

Enter your Microsoft Exchange Metrics client ID.

Client Secret

Enter your Microsoft Exchange Metrics client secret.

After you enter a client ID and client secret, you are taken to Microsoft's OAuth page where you are requested to enter your email, phone number, or Skype name associated with your Microsoft account. Once you have connected, you can use the same account any time you go to create a new Microsoft Exchange Metrics DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Note: If you are already logged into Microsoft when you connect in Domo, you are authenticated automatically when you click Add account. If you want to connect to an account that is different from the one you are logged into, you must first log out of Microsoft.

Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the Microsoft Exchange Metrics report you want to run. The following reports are available:

Activity Counts

Returns trends on how many users organized and participated in conference sessions held in your organization through Skype for Business.

Activity User Counts

Returns trends on how many unique users organized and participated in conference sessions held in your organization through Skype for Business.

Activity User Detail

Returns details about Skype for Business activity by user.

Device Usage Distribution User Counts

Returns the number of users using unique devices in your organization.

Device Usage User Counts

Returns usage trends on how many users in your organization have connected using the Skype for Business app.

Device Usage User Detail

Returns details about Skype for Business device usage by user.

Email Activity Counts

Returns trends of email activity (like how many were sent, read, and received) in your organization.

Email Activity User Counts

Returns trends on the number of unique users who are performing email activities like send, read, and receive.

Email Activity User Detail

Returns details about email activity users have performed.

Email App Usage User Detail

Returns details about which activities users performed on the various email apps.

Email App Usage Apps User Counts

Returns the count of unique users per email app.

Email App Usage User Counts

Returns the count of unique users that connected to Exchange Online using any email app.

Email App Usage Versions User Counts

Returns the count of unique users by Outlook desktop version.

Mailbox User Detail

Returns details about mailbox usage.

Mailbox Usage Mailbox Counts

Returns the total number of user mailboxes in your organization and how many are active each day of the reporting period.

Mailbox Usage Quota Status Mailbox Counts

Returns the count of user mailboxes in each quota category.

Mailbox Usage Storage

Returns the amount of storage used in your organization.

Office365 Groups Activity Detail

Returns details about Office 365 Groups activity by group.

Office365 Groups Activity Counts

Returns the number of group activities across group workloads.

Office365 Groups Activity Group Counts

Returns the daily total number of groups and how many of them were active based on email conversations, Yammer posts, and SharePoint file activities.

Office365 Groups Activity Storage

Returns the total storage used across all group mailboxes and group sites.

Office365 Groups Activity File Counts

Returns the total number of files and how many of them were active across all group sites associated with an Office 365 Group.

OneDrive Activity File Counts

Returns the number of unique, licensed users that performed file interactions against any OneDrive account.

OneDrive Activity User Counts

Returns the trends in the number of active OneDrive users.

Organizer Activity Minute Counts

Returns usage trends on the length in minutes and type of conference sessions held and organized by users in your organization.

Organizer Activity Counts

Returns usage trends on the number and type of conference sessions held and organized by users in your organization.

Participant Activity Counts

Returns usage trends on the number and type of conference sessions that users from your organization participated in.

Participant Activity User Counts

Returns usage trends on the number of unique users and type of conference sessions that users from your organization participated in.

Participant Activity Minute Counts

Returns usage trends on the length in minutes and type of conference sessions that users from your organization participated in.

PeerToPeer Activity User Counts

Returns usage trends on the number of unique users and type of peer-to-peer sessions held in your organization.

PeerToPeer Activity Counts

Returns usage trends on the number and type of sessions held in your organization.

PeerToPeer Activity Minute Counts

Returns usage trends on the length in minutes and type of peer-to-peer sessions held in your organization.

SharePoint Activity User Counts

Returns trends in the number of active users. A user is considered active if he or she has executed a file activity (save, sync, modify, or share) or visited a page within the specified time

SharePoint Site Usage Storage

Returns trends of storage allocated and consumed during the reporting period.

Parameter Type

Select whether you want to pull data for a selected period of days (Period) or for a specified date or date range (Date).

Period

Select the number of days you want to retrieve data for. ("D" refers to days. So D7 would pull data for 7 days, D30 would pull data for 30 days, etc.)

Duration 

Select whether you want to pull data for a specific date or a date range. 

Report Date 

Select whether the report data is for a specific date or for a relative number of days back from today. 

Select Specific Date 

Select the date for the report. 

Days Back

Enter the number of past days that should appear in the report.  

Start Date

Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date

End Date

Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date.  

Select Specific Start Date

Select the first date in your date range. 

Select Specific End Date

Select the second date in your date range. 

Days Back to Start From

Enter the number of the farthest day back that should be represented in the report. Combine with Days Back to End At to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago.

Days Back to End At

Enter the number of the most recent day back that should be represented in the report. Combine with Days Back to Start From to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, the report would contain data for 10 days ago up until 5 days ago.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.