Skip to content

Instantly share code, notes, and snippets.

@Torxsmind

Torxsmind/hybrid_on_guest_wifi.txt

Created January 15, 2024 17:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Torxsmind/afcc865baa3fee0a7ef7c52f0d12c926 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Torxsmind/afcc865baa3fee0a7ef7c52f0d12c926 to your computer and use it in GitHub Desktop.
Download ZIP
Hybrid Joined Devices on Known network
Raw
hybrid_on_guest_wifi.txt
SigninLogs
| where parse_json(tostring(parse_json(NetworkLocationDetails)[0].networkNames))[0] == "Guest WiFi"
| where DeviceDetail.trustType == "Hybrid Azure AD joined"
| extend displayName_ = tostring(DeviceDetail.displayName)
| project UserPrincipalName, displayName_
| summarize count() by UserPrincipalName, displayName_
| sort by count_
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment