Query Details

MDE - Local Account Creation

MDE Local Account Created

Query

let AllDomainControllers =
        DeviceNetworkEvents
        | where Timestamp > ago(7d)
        | where LocalPort == 88
        | where LocalIPType == "FourToSixMapping"
        //| extend DCDevicename = tostring(split(DeviceName,".")[0])
        | extend DCDevicename = DeviceName
        | distinct DCDevicename;
// COM003 – Local User creation 
let LapsAccounts = dynamic (["locadm","pcadm"]);
DeviceEvents
| where ActionType == "UserAccountCreated" 
| where AccountName !in (LapsAccounts)
| where DeviceName !in (AllDomainControllers)
| where AccountName != "defaultuser1"

About this query

MDE - Local Account Creation

Query Information

MITRE ATT&CK Technique(s)

Technique IDTitleLink
T1136.001Create Account: Local Accounthttps://attack.mitre.org/techniques/T1136/001/

Description

Use the below query to detect new local user account creation events. The query excludes domain controllers and let's you also specific LAPS accounts (Microsoft Local Administrator Account Solution)

References

Microsoft 365 Defender

Microsoft Sentiel

let AllDomainControllers =
        DeviceNetworkEvents
        | where TimeGenerated > ago(7d)
        | where LocalPort == 88
        | where LocalIPType == "FourToSixMapping"
        | extend DCDevicename = DeviceName
        | distinct DCDevicename;
let LapsAccounts = dynamic (["locadm","pcadm"]);
DeviceEvents
| where ActionType == "UserAccountCreated" 
| where AccountName !in (LapsAccounts)
| where DeviceName !in (AllDomainControllers)
| where AccountName != "defaultuser1"

Explanation

This query is used to detect new local user account creation events. It excludes domain controllers and allows you to specify LAPS accounts (Microsoft Local Administrator Account Solution). The query retrieves device events where the action type is "UserAccountCreated" and the account name is not in the specified LAPS accounts. It also filters out events from domain controllers and the default user account.

Details

Alex Verboon profile picture

Alex Verboon

Released: September 23, 2023

Tables

DeviceNetworkEventsDeviceEvents

Keywords

DevicesIntuneUser

Operators

wherelet|==!=inextenddynamicdistinctago

MITRE Techniques

Actions

GitHub