January 23, 2018

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

 

You May Also Like…