Defender Advanced hunting Query for Detecting SQL Servers in your enviroment

DeviceProcessEvents
| where FileName contains "sqlservr.exe"
| join kind=inner (
    DeviceInfo
    | where OSPlatform contains "Server"
) on DeviceId
| summarize by DeviceId, DeviceName, OSPlatform
DeviceProcessEvents
| where InitiatingProcessFileName contains "sql"
| join kind=inner (
    DeviceInfo
    | where OSPlatform contains "Server"
) on DeviceId
| summarize by DeviceId, DeviceName, OSPlatform
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...