Last week I finally found some time to start digging into managing security for Intune-enrolled devices with Azure Sentinel. Obviously, the first thing that had to be done was to connect Intune data to Azure Sentinel. Read about how to do that here: Connecting Intune to Azure Sentinel.
The next step was to ensure that my enrolled devices were showing up in the ingested data. I currently have both Windows and Android devices showing up in Azure Sentinel.

One of the things I’m really interested in is to see if the new Microsoft Defender ATP for Android will deliver some actionable and query-able data. Stay tuned.
Now with Intune data flowing in, I’ve been able to surmise the following tables contain the data I’ve been hunting for:
- AuditLogs
- IntuneAuditLogs
- IntuneOperationalLogs
- IntuneDeviceComplianceOrg
- IntuneDevices
- SigninLogs
- SecurityEvent
I’ve started putting together some quick KQL queries to sort through and make sense of the data. In a lot of cases, currently, there’s going to need to be some significant parsing, i.e., a lot of data is shoved into a ‘Properties’ field like is done for a custom log ingestion. I’ll be working on a parsing query that can be saved as a Function, so look for that.
I’ve not had an enormous amount of time to continue digging into the Intune/Azure Sentinel puzzle (though I really, desperately want to and will continue as I have time), but I did want to at least post about my progress and findings to hopefully spur some of you to continue the trek. Use your creativity to help build some Hunting queries and Analytics Rules.
I’ve started putting my own quick creations in my GitHub repository. Just search the page for “Intune”:
https://github.com/rod-trent/SentinelKQL
There’s a few there already:

Here’s an example to get the juices flowing. This one identifies those Intune-enrolled devices no in compliance:
IntuneDeviceComplianceOrg
| where ComplianceState <> “Compliant” and isnotempty(ComplianceState)
Have fun! Let me know what you come up with on Twitter: @rodtrent
=========================
[Want to discuss this further? Hit me up on Twitter or LinkedIn]
[Subscribe to the RSS feed for this blog]
[Subscribe to the Weekly Azure Sentinel Newsletter]
2 thoughts on “Digging Deeper into Intune and Azure Sentinel”