Some new reports available in Office 365

​Recently, two new reports appeared under the Reports section of the Office 365 Admin portal. Those are the User activities and the Client devices per user Lync reports. They offer very detailed information and can be useful in troubleshooting or when performing an inventory of the types of devices your users work with.

Of course if you are looking into getting that data, the Admin portal will probably be the last place you would use. Instead, you will most likely use the Office 365 Reporting web service REST APIs or PowerShell. The documentation unfortunately has not been kept up to date, and the MSDN page doesn’t even list these two reports, and even some older ones. So I decided to give them some more visibility.

So, the Client devices per user report requires you to provide the username, and will give you information about the total number of activities the user has performed using different device families over the course of a calendar month. Useful if you are interested in knowing what kind of devices the user has, especially when you don’t have Exchange Online or simply haven’t created a mailbox for the user. To get the report via PowerShell, you can run the following cmdlet:

Get-CsClientDeviceDetailReport -UserName user@domain.com

And to get the report via the reporting web service, you can use this query:

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsClientDeviceDetailMonthly?$filter=UserName%20eq%20’user@domain.com’

The User activities report on the other hand gives you very detailed breakdown of all the activities the user has performed during the month. And I mean detailed! Even the number of IM sessions the user has participated in will be listed. Another very important piece of information listed is the last login time for that user during the month, and similarly, the last active time. To get the report via PowerShell, run:

Get-CsUserActivitiesReport -UserName user@domain.com

And to get the report via the web service, use:

https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsUserActivitiesMonthly?$filter=UserName%20eq%20’user@domain.com’

For the sake of completeness, here’s also a list of all the other reports/cmdlets that are missing form the MSDN article:

Report Name PowerShell cmdlet Web service collection
(Lync) Client devices Get-CsClientDeviceReport CsClientDeviceMonthly
(Lync) Client devices per user Get-CsClientDeviceDetailReport CsClientDeviceDetailMonthly
(Lync) User activities Get-CsUserActivitiesReport CsUserActivitiesMonthly
Licensing vs Usage report Get-LicenseVsUsageSummaryReport LicenseVsUsageSummary
Device usage report Get-MobileDeviceDashboardSummaryReport MobileDeviceDashboardSummaryReport
Browser used Get-O365ClientBrowserReport ClientSoftwareBrowserSummary
Browser used detail Get-O365ClientBrowserDetailReport ClientSoftwareBrowserDetail
Operating system used Get-O365ClientOSReport ClientSoftwareOSSummary
Operating system used detail Get-O365ClientOSDetailReport ClientSoftwareOSDetail
? Get-PartnerCustomerUserReport PartnerCustomerUser
? Get-ScorecardClientDeviceReport ScorecardClientDevice
? Get-ScorecardClientOSReport ScorecardClientOS
? Get-ScorecardClientOutlookReport ScorecardClientOutlook
? Get-ScorecardMetricsReport ScorecardMetrics
(SPO) Active users Get-SPOActiveUserReport SPOActiveUserDaily/Weekly/Monthly
OneDrive for Business sites deployed Get-SPOSkyDriveProDeployedReport SPOSkyDriveProDeployedWeekly/Monthly
OneDrive for Business storage Get-SPOSkyDriveProStorageReport SPOSkyDriveProStorageWeekly/Monthly
Team sites storage Get-SPOTeamSiteStorageReport SPOTeamSiteStorageWeekly/Monthly
Team sites deployed Get-SPOTeamSiteDeployedReport SPOTeamSiteDeployedWeekly/Monthly
Tenant storage metrics Get-SPOTenantStorageMetricReport SPOTenantStorageMetricDaily/Weekly/Monthly

Most of the PowerShell cmdlets above have detailed help, which can be found online here: https://technet.microsoft.com/en-us/library/dn641232(v=exchg.150).aspx

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.