Announcing the General Availability of Microsoft Graph reporting APIs

General Availability of Microsoft Graph reporting APIs for retrieving Office 365 product usage data

The usage reports in the Office 365 admin center enable admins to understand their company’s usage across the Office 365 services. However, many of you have existing reporting solutions such as a company reporting application or a web portal in place. To assure that you can monitor your IT services in one unified location, the usage reporting APIs complement the usage reports and allow organizations and independent software vendors to incorporate Office 365 usage data into their existing reporting solutions. Using these APIs, you can retrieve the data available in all of the usage reports, including organization level summaries per service, entity level (user, sites, accounts) usage information for reporting periods of the last 7/30/90/180 days, and daily activity aggregates.

Get started with the new APIs

The new APIs are available now, and any user with global admin, product admin rights (for Exchange, Skype for Business and SharePoint), or a reports reader role can retrieve data through these APIs.

You can leverage the Microsoft Graph documentation for the reporting API and submit feature requests by asking or voting on an idea on UserVoice. Please submit questions by posting them on Stack Overflow and tagging microsoftgraph.

With this announcement, we are announcing the deprecation of the following APIs within the Office 365 Reporting Web Service: ConnectionbyClientType, ConnectionbyClientTypeDetail, CsActiveUser, CsAVConferenceTime, CsP2PAVTime, CsConference, CsP2PSession, GroupActivity, MailboxActivity, GroupActivity, MailboxUsage, MailboxUsageDetail, StaleMailbox and StaleMailboxDetail.

We will remove these APIs, as well as any related PowerShell cmdlets, on January 29, 2018.

If you are currently using APIs or any of the related PowerShell cmdlets from the Office 365 Reporting Web Service, please start planning the migration of any subsystems within your organization.

Below is a summary of the APIs and cmdlets that will be deprecated.

Office 365 Reporting web service reference page	Office 365 reporting-related Windows PowerShell cmdlets	Description	MS Graph Replacement
CsActiveUser* reports	Get-CsAVConferenceTimeReport	The number of active, logged-in Lync Online users during the reporting period	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_activity_reports
CsAVConferenceTime* reports	Get-CsActiveUserReport	The amount of time logged-in organization users participated in Lync Online conferences during the reporting period	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_organizer_activity_reports https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_participant_activity_reports https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_peer_to_peer_activity
CsP2PAVTime* reports	Get-CsP2PAVTimeReport
	Get-CsClientDeviceReport	View statistics about the client devices that connected to Skype for Business Online in your cloud-based organization.	These methods are being deprecated as of January 29, 2018. They are being replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_device_usage_reports
	Get-CsClientDeviceDetailReport	View statistics about the number of peer-to-peer sessions and conferences by users and devices that connected to Skype for Business Online in your cloud-based organization.
CsConference* reports	Get-CsConferenceReport	The count of Lync Online conferences and peer-to-peer sessions during the reporting period.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at Â https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_organizer_activity_reports https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_participant_activity_reports https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/skype_for_business_peer_to_peer_activity
CsP2PSession* reports	Get-CsP2PSessionReport
	Get-CsUserActivitiesReport	View number and type of activities that a user participated in while connected to Skype for Business Online in your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getskypeforbusinessactivityuserdetail
	Get-CsUsersBlockedReport	View Skype for Business Online users who have been blocked due to fraudulent call activities.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-CsPSTNConferenceTimeReport	Show the number of minutes that Skype for Business Online users spent in dial-in or dial-out conferences.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-CsPSTNUsageDetailReport	View public switched telephone network (PSTN) usage details for Skype for Business Online users.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
ConnectionbyClientType* reports	Get-ConnectionByClientTypeReport	The number and types of email client-access methods used by the organization’s users during the reporting period. For example, Outlook Web Access, Exchange Web services, and so on.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available atÂ https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/email_app_usage_reports
ConnectionbyClientTypeDetail* reports	Get-ConnectionByClientTypeDetailReport
MailboxActivity* reports GroupActivity* reports	Get-MailboxActivityReport Get-GroupActivityReport	Office 365 users created and deleted, summarized over the indicated time periods. Active Directory Domain Services (AD DS) replication can sometimes delay this information up to a day.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/mailbox_usage_reports https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/office_365_groups_activity_reports
	Get-ExternalActivityByDomainReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ExternalActivityByUserReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ExternalActivityReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ExternalActivitySummaryReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-LicenseVsUsageSummaryReport	To retrieve a report that identifies the number of active users for installed software licenses (workloads).	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
MailboxUsage report	Get-MailboxUsageReport	Summary and detailed statistics about organization user mailboxes.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/mailbox_usage_reports
MailboxUsageDetail report	Get-MailboxUsageDetailReport
MailDetail report	Get-MailDetailReport		This method will continue to work as expected and is not impacted by this deprecation
MailDetailDlpPolicy report	Get-MailDetailDlpPolicyReport		This method will continue to work as expected and is not impacted by this deprecation
MailDetailMalware report	Get-MailDetailMalwareReport		This method will continue to work as expected and is not impacted by this deprecation
MailDetailSpam report	Get-MailDetailSpamReport		This method will continue to work as expected and is not impacted by this deprecation
MailDetailTransportRule report	Get-MailDetailTransportRuleReport		This method will continue to work as expected and is not impacted by this deprecation
MailFilterList report	Get-MailFilterListReport		This method will continue to work as expected and is not impacted by this deprecation
MailTraffic report	Get-MailTrafficReport		This method will continue to work as expected and is not impacted by this deprecation
MailTrafficPolicy report	Get-MailTrafficPolicyReport		This method will continue to work as expected and is not impacted by this deprecation
MailTrafficSummary reports	Get-MailTrafficSummaryReport		This method will continue to work as expected and is not impacted by this deprecation
MailTrafficTop report	Get-MailTrafficTopReport		This method will continue to work as expected and is not impacted by this deprecation
MessageTrace report	Get-MessageTrace		This method will continue to work as expected and is not impacted by this deprecation
MessageTraceDetail report	Get-MessageTraceDetail		This method will continue to work as expected and is not impacted by this deprecation
MxRecordReport report	Get-MxRecordReport		This method will continue to work as expected and is not impacted by this deprecation
	Get-O365ClientOSReport	Get a summary report of client operating system use.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-O365ClientOSDetailReport	Get a detailed report of client operating system use.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-O365ClientBrowserReport	Get a summary report of client browser use.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-O365ClientBrowserDetailReport	Get a detailed report of client browser use.	This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
OutboundConnectorReport report	Get-OutboundConnectorReport		This method will continue to work as expected and is not impacted by this deprecation.
	Get-PartnerClientExpiringSubscriptionReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-PartnerCustomerUserReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ScorecardClientDeviceReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ScorecardClientOSReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ScorecardClientOutlookReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
	Get-ScorecardMetricsReport		This method is being deprecated as of January 29, 2018. There is no MS Graph replacement.
ServiceDeliveryReport report	Get-ServiceDeliveryReport		This method will continue to work as expected and is not impacted by this deprecation
	Get-SPOActiveUserReport	View statistics about Microsoft SharePoint Online users in your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getsharepointactivityusercounts
	Get-SPOOneDriveForBusinessFileActivityReport		This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getonedriveactivityfilecounts
	Get-SPOOneDriveForBusinessUserStatisticsReport		This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getonedriveactivityusercounts
	Get-SPOSkyDriveProDeployedReport	View the number of My Site sites in your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getonedriveactivityusercounts
	Get-SPOSkyDriveProStorageReport	View statistics about the space taken up (in MB) by My Sites in your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getonedriveusagestorage
	Get-SPOTeamSiteDeployedReport	View the number of My Site sites in your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getsharepointsiteusagestorage
	Get-SPOTeamSiteStorageReport	View statistics about the space taken up (in MB) by team sites in your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getsharepointsiteusagestorage
	Get-SPOTenantStorageMetricReport	View statistics about the space taken up (in MB) by all sites in for your cloud-based organization.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/reportroot_getsharepointsiteusagestorage
StaleMailbox report	Get-StaleMailboxReport	The details and summary counts of mailboxes that have not been accessed within the indicated time period.	This method is being deprecated as of January 29, 2018. It is replaced by the new MS Graph Reporting API available at https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/email_activity_reports
StaleMailboxDetail report	Get-StaleMailboxDetailReport