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 

This entry was posted in Office 365. Bookmark the permalink.

Leave a Reply

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