↳ Source GitHubRègle analytiqueMedium
Dataverse - Suspicious security role modifications
Description
Identifies an unusual pattern of events whereby a new role is created followed by the creator adding members to the role and subsequently removing the member or deleting the role after a short time period.
- Type de règle
- Scheduled
- Version
- 3.2.0
- Statut déclaré
- Available
- Fréquence
- 1h
- Période analysée
- 14d
- Déclenchement
- gt 0
Couverture MITRE déclarée
Sources déclarées
Métadonnées du fichier source. Aucune dépendance déduite du KQL.
Connecteurs
Types de données
Requête KQL
Requête originale, sans modification.
let role_create_watch_period = 2d;
let query_frequency = 1h;
let role_create_add_events= DataverseActivity
| where Message == "Create" and EntityName == "role"
| mv-expand Role = Fields
| extend RoleName = Role.Value
| where Role.Name == "name"
| mv-expand Role = Fields
| extend RoleCreateTime = TimeGenerated, RoleId = tostring(Role.Value)
| where Role.Name == "roleid"
| join kind=inner (
DataverseActivity
| where Message == "Associate" and EntityName == "systemuser"
| mv-expand Role = Fields
| where Role.Name == "role"
| extend RoleMemberAddedTime = TimeGenerated, MemberAddedRoleId = tostring(Role.Value))
on $left.RoleId == $right.MemberAddedRoleId, InstanceUrl, UserId
| where RoleMemberAddedTime between (RoleCreateTime .. (RoleCreateTime + role_create_watch_period));
let remove_role_member_events = DataverseActivity
| where TimeGenerated >= ago(query_frequency)
| where Message == "Disassociate" and EntityName == "systemuser"
| mv-expand Role = Fields
| where Role.Name == "role"
| extend ActionTime = TimeGenerated, MemberRemovedRoleId = tostring(Role.Value);
let role_delete_events = DataverseActivity
| where TimeGenerated >= ago(query_frequency)
| where Message == "Delete" and EntityName == "role"
| extend DeletedRoleID = EntityId, Action = "Role deleted within defined time window"
| project Action, ActionTime = TimeGenerated, UserId, ClientIp, DeletedRoleID, InstanceUrl;
let role_member_removals = role_create_add_events
| join kind=inner (remove_role_member_events) on $left.RoleId == $right.MemberRemovedRoleId
| where ActionTime between (RoleCreateTime .. (RoleCreateTime + role_create_watch_period))
| extend Action = "Role membership removed within defined time window";
let role_deletions = role_create_add_events
| join kind=inner (role_delete_events) on $left.RoleId == $right.DeletedRoleID
| where ActionTime between (RoleCreateTime .. (RoleCreateTime + role_create_watch_period));
union isfuzzy=true role_member_removals, role_deletions
| extend
CloudAppId = int(32780),
AccountName = tostring(split(UserId, '@')[0]),
UPNSuffix = tostring(split(UserId, '@')[1])
| project
UserId,
InstanceUrl,
ClientIp,
Action,
RoleCreateTime,
RoleName,
ActionTime,
CloudAppId,
AccountName,
UPNSuffix
Entités déclarées
Contenus associés
Liens établis à partir des identifiants déclarés et des manifests des solutions.
Traçabilité de la source
GitHubLes valeurs affichées proviennent des fichiers du dépôt Azure/Azure-Sentinel. Elles décrivent le modèle publié, pas la configuration de votre workspace.
- Commit
9800e51↗- Identifiant source
e44a58b2-b63a-4eb9-92da-85660d73495c
GSTEP / SUIVI DU CATALOGUE
Ajouté au catalogue : 16 sept. 2026 · 05:49 UTC
Dernier changement observé : 16 sept. 2026 · 05:49 UTC