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