SOLVED

How can I pull up OS versions a Teams Device is Installed?

Copper Contributor

I search for this question but couldn't find an answer. I'm not sure if anyone answered it before but i want to know how i can see what OS employees are using on TEAMS. 

4 Replies
best response confirmed by RedPanther10 (Copper Contributor)
Solution

Hi @RedPanther10 

 

You could use a KQL Query in Azure LogAnalytics:

SigninLogs
| where TimeGenerated > ago(30d)
| where AppDisplayName == "Microsoft Teams"
| where ResultType == 0 //Sucessful Login
| summarize count() by UserPrincipalName, tostring(DeviceDetail.operatingSystem), UserAgent

 

If you want to use it in PowerShell - maybe this Blog Article will give you some jump start

https://blog.icewolf.ch/archive/2023/01/26/analyze-azuread-signin-logs-with-powershell/ 

 

Regards

Andres Bohren

@RedPanther10 

 

@Andres Bohren is right about where to look for the information, so you should give him the best reply.

A simple oneliner will give you the info with PowerShell.

 

Import-Module Microsoft.Graph.Reports
Connect-MgGraph -Scope AuditLog.Read.All,Directory.Read.All
Get-MgAuditLogSignIn -filter 'contains(appDisplayName,"Teams")' | select -Unique userprincipalname, appdisplayname, @{label="OS"; expression={$_.devicedetail.operatingsystem} }

 

edited with a little improvement, it takes a few minutes to run though

 

-Ole

or are you actually looking for teams devices? like desktop phones or meeting room equipment? as in something like this: https://www.microsoft.com/en-us/microsoft-teams/across-devices/devices/product/poly-ccx-600-business...
I want to see who has TEAMS downloaded on their phones and laptops. So basically i want to know If person1 has it on their phones, because I'm trying to narrow down calls quality. @Andres Bohren response should do the trick.
1 best response

Accepted Solutions
best response confirmed by RedPanther10 (Copper Contributor)
Solution

Hi @RedPanther10 

 

You could use a KQL Query in Azure LogAnalytics:

SigninLogs
| where TimeGenerated > ago(30d)
| where AppDisplayName == "Microsoft Teams"
| where ResultType == 0 //Sucessful Login
| summarize count() by UserPrincipalName, tostring(DeviceDetail.operatingSystem), UserAgent

 

If you want to use it in PowerShell - maybe this Blog Article will give you some jump start

https://blog.icewolf.ch/archive/2023/01/26/analyze-azuread-signin-logs-with-powershell/ 

 

Regards

Andres Bohren

View solution in original post