Create an Azure role assignment

Microsoft.Authorization/roleAssignments/write — The action permits creating a role assignment that connects a target principal, role definition and scope. [11] [13]

What the action permits

  • Documented Microsoft lists roleAssignments/write as an Action for creating an assignment at a specified scope. It is a control-plane permission. [11] [14]
  • Documented Actions permit matching operations; NotActions removes matches within that role. Permission strings are case-insensitive. A matching expression establishes declared capability only. [14] [8]
  • Documented DataActions is a separate permission set. Even Owner's control-plane wildcard does not itself grant every data-plane operation. [14]

Objects and scope

  • Documented The actor calls the assignment API; properties.principalId identifies the intended recipient. These roles may refer to the same principal, but caller identity alone does not identify the recipient. [6]
  • Documented A role definition describes permissions. A role assignment associates a principal with that definition at a scope and can carry a condition. Its assignment ID differs from the role-definition ID. [13]
  • Documented Role permissions inherit from management group to subscription, resource group and resource scopes. The assignment's scope identifies where its access applies. [15]
  • Documented A role assignment is an extension resource. Its full resource ID includes the roleAssignments suffix; the grant's scope is the resource being extended. Keep both separate from the caller's authorizing assignment scope. [15] [6]
  • Documented AssignableScopes makes a role definition available for assignment at eligible scopes; it does not assign that role to a principal. [14]

Authorization prerequisites and limits

  • Documented Calling Role Assignments Create requires access to Microsoft.Authorization/roleAssignments/write at the requested scope, including any applicable inherited authorization. [6] [15]
  • Documented The documented REST request supplies the target principal object ID and role-definition resource ID, with assignment scope and assignment name in the URI. [6]
  • Documented A condition on the actor's role assignment can limit which roles, principal types or specific principals the actor may assign. An action match does not evaluate that condition. [9]
  • Documented NotActions subtracts permissions from one role; another role can still allow that action. An applicable deny assignment can block access despite an allow, subject to its own scope, inheritance and excluded principals. [14] [10]
  • Documented These three built-in roles are reviewed examples. Other built-in and custom roles can have relevant permissions; this page provides no exhaustive grant-path inventory. [12] [8]
  • Unavailable No tenant assignments, group membership, PIM activation, conditions or deny state have been evaluated here. Neither the role examples nor the historical log establish the actor's or target's effective access. [3] [9] [10]
  • Inferred Azure-Microsoft.Authorization event 8520038 is the project's generated catalog join for this operation. That event number is not an Azure-native event ID or independent evidence of emission. [2]

Reviewed declared-capability examples

These are non-exhaustive role-definition examples. They do not prove an actor assignment or effective permission.

  • Owner 8e3af657-a8ff-443c-a75c-2fe8c4bcb635

    The published wildcard includes the pilot action. This role definition does not establish any actor assignment or effective access. [12] [14]

    Actions
    *
  • User Access Administrator 18d7d88d-d35e-4fb5-a5c3-7773c20a72d9

    The published Microsoft.Authorization wildcard includes the pilot action. An actual assignment's scope and applicable constraints must still be checked. [12] [9]

    Actions
    */read, Microsoft.Authorization/*, Microsoft.Support/*
  • Role Based Access Control Administrator f58310d9-a9f6-439a-9e8d-f62e7b41a168

    The published definition names the pilot action explicitly. This is an example of declared capability, not a tenant grant. [12] [9]

    Actions
    Microsoft.Authorization/roleAssignments/write, Microsoft.Authorization/roleAssignments/delete, */read, Microsoft.Support/*
    Condition
    Microsoft's delegation example adds an assignment condition restricting roles and recipients; no such condition record is available for this historical caller.

Authority thread stages

These are research waypoints, not a calculated effective-access result or a guaranteed event sequence.

  1. Declared actor capability Documented

    A reviewed role's action expression includes roleAssignments/write after that role's exclusions. [12] [14]

    Role definition only; assignment and authorization remain separate.

  2. Actor assignment Unavailable

    An applicable assignment connects the actor to a role at a scope, potentially with a condition. [13] [3]

    No independently verified actor-assignment resource is available; historical authorization evidence is insufficient.

  3. Effective authorization Unavailable

    Applicable scope, permissions, conditions and deny assignments can affect whether the write is authorized. [15] [9] [10]

    This page explains factors and does not calculate an authorization result.

  4. Operation attempt Historical context

    The retained context names roleAssignments/write with Success and Created result strings. [4] [3]

    These strings are historical context, not admitted occurrence or value-presence evidence.

  5. Target assignment state Unavailable

    Assignment resource evidence would identify the target principal, role, scope and condition. [6] [4] [1]

    No target request body or resource response is retained; the intended Reader grant is unverified.

  6. Target capability Documented

    An assignment can give its recipient the role's permissions within the assignment scope, subject to applicable constraints. [13] [9] [10]

    This is the documented model; this target's assignment and effective access are unknown.

  7. Downstream operation Unavailable

    A later operation by the recipient would need separate evidence. [3] [4]

    No target-use event or causal grant-to-use relationship has been established.

Azure Activity Log context

Caller and target are different questions.

Inferred Authorization_d.evidence says Owner in the retained record, while the historical inducer intends Reader. This supports only a caller-side interpretation, not authoritative evidence-field semantics or a verified target grant. The request body is absent and the inducer-to-record link is unattested. [4] [1] [3]

Documented Microsoft documents ARM writes and subscription RBAC changes in Activity Log's Administrative category, with start and success/failure records. Log Analytics uses the AzureActivity schema after configured routing; OperationNameValue identifies the operation. Documentation does not prove this historical operation occurred or guarantee nested fields. [5] [7] [3]

Documented Status describes the operation result; substatus commonly describes its HTTP result. Preserve collection-specific values and distinguish a start from completion. A successful write alone does not establish continued assignment state, target effective access or subsequent use. [5] [7] [13]

Canonical event identity: Azure-Microsoft.Authorization event 8520038.

Occurrence evidence
Unavailable
Value-presence evidence
Unavailable
Request body
Absent from this historical context
Target grant state
Unavailable

Caller

actor principal Caller identity; the table's GUID description differs from REST/portal email, UPN or SPN wording. Do not infer the target from this field. [7] [5]

Documented

Authorization_d.evidence.role

actor authorizing role Owner in historical context; interpreted as caller-side authorization, not the role newly assigned to the recipient. No authoritative nested-field definition is established. [4] [1] [3]

Inferred

Authorization_d.evidence.roleDefinitionId

actor authorizing role Historical caller-side role-definition interpretation only; it cannot identify the newly granted role. [4] [1] [3]

Inferred

Authorization_d.evidence.roleAssignmentId

actor authorizing role Candidate caller-authorizing assignment ID in historical context, not verified target-assignment identity. [4] [3]

Inferred

Authorization_d.evidence.roleAssignmentScope

actor authorizing role Interpreted as the caller-authorizing assignment scope in this historical record; it does not establish the recipient's grant scope. [4] [1] [3]

Inferred

Authorization_d.evidence.principalId

actor principal Candidate caller-side principal identifier in historical context; it is not target principal evidence. [4] [3]

Inferred

Authorization_d.evidence.principalType

actor principal Candidate caller-side principal type in historical context; it does not verify the recipient's type. [4] [3]

Inferred

Authorization_d.scope

operation resource scope The historical string resembles the role-assignment resource ID for the operation. That interpretation neither defines all authorization scopes nor verifies a target grant. [4] [15] [3]

Inferred

_ResourceId

operation resource scope Resource associated with the AzureActivity record; distinguish the assignment resource from the resource it extends. [7] [15]

Documented

REST request body: properties.principalId

target principal Documented recipient object ID in the assignment API body. That body is unavailable here; this is not a guaranteed Activity Log path. [6] [4]

Unavailable

REST request body: properties.roleDefinitionId

assigned role definition Documented role-definition resource ID to assign. No retained request establishes it; Owner authorization evidence is not a substitute. [6] [4]

Unavailable

REST response: properties.scope

assignment scope Documented assignment scope in the API response. No response is retained; the caller's evidence.roleAssignmentScope cannot supply it. [6] [4]

Unavailable

CorrelationId

correlation Associates records within a larger action; alone it does not prove later use by the target. [7] [5]

Documented

EventDataId

correlation Identifies one event record; it is not a role-assignment ID. [7]

Documented

ActivityStatusValue

result Operation status; retain its actual spelling and completion state for the collection surface. [7]

Documented

ActivitySubstatusValue

result Operation substatus, commonly an HTTP result; it does not identify the recipient or granted role. [7]

Documented

Detection evidence

Analysis state: Partial. Existing represented Azure Activity rule predicates only. Complete direct selectors and partial candidates are counted separately; consumer selections establish neither occurrence nor effective access.

Direct operation detections

Azure RBAC Built-In Administrator Roles Assigned Elastic

Analysis: Complete. KQL consumer logic, not Azure platform authority.

Direct selector:

  • event.action eq MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[1],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    1
    DNF terms
    0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23
    Stage
    0 kql:query
Additional represented rule context
  • data_stream.dataset eq azure.activitylogs
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[0],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    0
    DNF terms
    0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *18d7d88d-d35e-4fb5-a5c3-7773c20a72d9* optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[2,0],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    2, 0
    DNF terms
    0, 1, 2, 3
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *f58310d9-a9f6-439a-9e8d-f62e7b41a168* optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[2,1],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    2, 1
    DNF terms
    4, 5, 6, 7
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *b24988ac-6180-42a0-ab88-20f7382dd24c* optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[2,2],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    2, 2
    DNF terms
    8, 9, 10, 11
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *8e3af657-a8ff-443c-a75c-2fe8c4bcb635* optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[2,3],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    2, 3
    DNF terms
    12, 13, 14, 15
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *92b92042-07d9-4307-87f7-36a593fc5850* optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[2,4],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    2, 4
    DNF terms
    16, 17, 18, 19
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *a8889054-8d42-49c9-bc1c-52486c10e7cd* optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[2,5],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    2, 5
    DNF terms
    20, 21, 22, 23
    Stage
    0 kql:query
  • azure.activitylogs.identity.claims.appid eq 7319c514-987d-4e9b-ac3d-d38c4f427f4c negated optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[3,0,0],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    3, 0, 0
    DNF terms
    0, 4, 8, 12, 16, 20
    Stage
    0 kql:query
  • azure.activitylogs.identity.authorization.evidence.role eq Service Owner role negated optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[3,0,1],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    3, 0, 1
    DNF terms
    1, 5, 9, 13, 17, 21
    Stage
    0 kql:query
  • azure.activitylogs.identity.authorization.evidence.principal_type eq ServicePrincipal negated optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[3,0,2],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    3, 0, 2
    DNF terms
    2, 6, 10, 14, 18, 22
    Stage
    0 kql:query
  • azure.activitylogs.properties.requestbody.properties.roleDefinitionId wildcard *b24988ac-6180-42a0-ab88-20f7382dd24c* negated optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca",0,[3,0,3],0]
    Semantic scope
    resolved-unit-v1-42811c7317d7053a7a8e21ce640e7c02a2a2a9331c911141171b3df4e2c59aca/stage:0/filter
    Predicate path
    3, 0, 3
    DNF terms
    3, 7, 11, 15, 19, 23
    Stage
    0 kql:query
Stage, filter, grouping, or window context
  • {"metadata":{"indices":["filebeat-*","logs-azure.activitylogs-*"],"integrations":["azure"],"level":"high","source_tags":["Domain: Cloud","Domain: Identity","Data Source: Azure","Data Source: Azure Activity Logs","Platform: Azure","Rule Type: Custom Query (KQL)","Use Case: Identity and Access Audit","Tactic: Privilege Escalation","Tactic: Persistence","Resources: Investigation Guide"]},"rule":{"field_usage":{"blockers":["query: stage uses lack source-role coordinates"],"conditions":[{"blockers":[],"category":"check","condition_id":"elastic:stage:0","inputs":[{"authored_path":"data_stream.dataset","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"data_stream.dataset","source_table":"","transforms":[]},{"authored_path":"event.action","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"event.action","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.identity.claims.appid","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.claims.appid","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.identity.authorization.evidence.role","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.authorization.evidence.role","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.identity.authorization.evidence.principal_type","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.authorization.evidence.principal_type","source_table":"","transforms":[]},{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]}],"operands":[{"authored_token":"data_stream.dataset","kind":"field","position":"lhs","predicate_path":[0],"reference":{"authored_path":"data_stream.dataset","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"data_stream.dataset","source_table":"","transforms":[]},"value":"data_stream.dataset"},{"authored_token":"azure.activitylogs","kind":"literal","position":"value","predicate_path":[0],"reference":null,"value":"azure.activitylogs"},{"authored_token":"event.action","kind":"field","position":"lhs","predicate_path":[1],"reference":{"authored_path":"event.action","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"event.action","source_table":"","transforms":[]},"value":"event.action"},{"authored_token":"MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE","kind":"literal","position":"value","predicate_path":[1],"reference":null,"value":"MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[2,0],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*18d7d88d-d35e-4fb5-a5c3-7773c20a72d9*","kind":"literal","position":"value","predicate_path":[2,0],"reference":null,"value":"*18d7d88d-d35e-4fb5-a5c3-7773c20a72d9*"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[2,1],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*f58310d9-a9f6-439a-9e8d-f62e7b41a168*","kind":"literal","position":"value","predicate_path":[2,1],"reference":null,"value":"*f58310d9-a9f6-439a-9e8d-f62e7b41a168*"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[2,2],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*b24988ac-6180-42a0-ab88-20f7382dd24c*","kind":"literal","position":"value","predicate_path":[2,2],"reference":null,"value":"*b24988ac-6180-42a0-ab88-20f7382dd24c*"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[2,3],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*8e3af657-a8ff-443c-a75c-2fe8c4bcb635*","kind":"literal","position":"value","predicate_path":[2,3],"reference":null,"value":"*8e3af657-a8ff-443c-a75c-2fe8c4bcb635*"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[2,4],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*92b92042-07d9-4307-87f7-36a593fc5850*","kind":"literal","position":"value","predicate_path":[2,4],"reference":null,"value":"*92b92042-07d9-4307-87f7-36a593fc5850*"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[2,5],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*a8889054-8d42-49c9-bc1c-52486c10e7cd*","kind":"literal","position":"value","predicate_path":[2,5],"reference":null,"value":"*a8889054-8d42-49c9-bc1c-52486c10e7cd*"},{"authored_token":"azure.activitylogs.identity.claims.appid","kind":"field","position":"lhs","predicate_path":[3,0,0],"reference":{"authored_path":"azure.activitylogs.identity.claims.appid","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.claims.appid","source_table":"","transforms":[]},"value":"azure.activitylogs.identity.claims.appid"},{"authored_token":"7319c514-987d-4e9b-ac3d-d38c4f427f4c","kind":"literal","position":"value","predicate_path":[3,0,0],"reference":null,"value":"7319c514-987d-4e9b-ac3d-d38c4f427f4c"},{"authored_token":"azure.activitylogs.identity.authorization.evidence.role","kind":"field","position":"lhs","predicate_path":[3,0,1],"reference":{"authored_path":"azure.activitylogs.identity.authorization.evidence.role","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.authorization.evidence.role","source_table":"","transforms":[]},"value":"azure.activitylogs.identity.authorization.evidence.role"},{"authored_token":"Service Owner role","kind":"literal","position":"value","predicate_path":[3,0,1],"reference":null,"value":"Service Owner role"},{"authored_token":"azure.activitylogs.identity.authorization.evidence.principal_type","kind":"field","position":"lhs","predicate_path":[3,0,2],"reference":{"authored_path":"azure.activitylogs.identity.authorization.evidence.principal_type","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.authorization.evidence.principal_type","source_table":"","transforms":[]},"value":"azure.activitylogs.identity.authorization.evidence.principal_type"},{"authored_token":"ServicePrincipal","kind":"literal","position":"value","predicate_path":[3,0,2],"reference":null,"value":"ServicePrincipal"},{"authored_token":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"field","position":"lhs","predicate_path":[3,0,3],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"value":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId"},{"authored_token":"*b24988ac-6180-42a0-ab88-20f7382dd24c*","kind":"literal","position":"value","predicate_path":[3,0,3],"reference":null,"value":"*b24988ac-6180-42a0-ab88-20f7382dd24c*"}],"predecessors":[],"predicate":{"children":[{"field":"data_stream.dataset","kind":"eq","values":["azure.activitylogs"]},{"field":"event.action","kind":"eq","values":["MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"]},{"children":[{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*18d7d88d-d35e-4fb5-a5c3-7773c20a72d9*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*f58310d9-a9f6-439a-9e8d-f62e7b41a168*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*b24988ac-6180-42a0-ab88-20f7382dd24c*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*8e3af657-a8ff-443c-a75c-2fe8c4bcb635*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*92b92042-07d9-4307-87f7-36a593fc5850*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*a8889054-8d42-49c9-bc1c-52486c10e7cd*"]}],"kind":"or"},{"children":[{"children":[{"field":"azure.activitylogs.identity.claims.appid","kind":"eq","values":["7319c514-987d-4e9b-ac3d-d38c4f427f4c"]},{"field":"azure.activitylogs.identity.authorization.evidence.role","kind":"eq","values":["Service Owner role"]},{"field":"azure.activitylogs.identity.authorization.evidence.principal_type","kind":"eq","values":["ServicePrincipal"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*b24988ac-6180-42a0-ab88-20f7382dd24c*"]}],"kind":"and"}],"kind":"not"}],"kind":"and"},"stage_index":0}],"coverage":"partial","occurrences":[{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:0","predicate_path":[0],"reference":{"authored_path":"data_stream.dataset","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"data_stream.dataset","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:1","predicate_path":[1],"reference":{"authored_path":"event.action","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"event.action","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:2","predicate_path":[2,0],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:3","predicate_path":[2,1],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:4","predicate_path":[2,2],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:5","predicate_path":[2,3],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:6","predicate_path":[2,4],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:7","predicate_path":[2,5],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:8","predicate_path":[3,0,0],"reference":{"authored_path":"azure.activitylogs.identity.claims.appid","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.claims.appid","source_table":"","transforms":[]},"roles":["exclusion"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:9","predicate_path":[3,0,1],"reference":{"authored_path":"azure.activitylogs.identity.authorization.evidence.role","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.authorization.evidence.role","source_table":"","transforms":[]},"roles":["exclusion"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:10","predicate_path":[3,0,2],"reference":{"authored_path":"azure.activitylogs.identity.authorization.evidence.principal_type","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.identity.authorization.evidence.principal_type","source_table":"","transforms":[]},"roles":["exclusion"],"stage_index":0},{"condition_id":"elastic:stage:0","dependency_path":[],"occurrence_id":"elastic:stage:0:11","predicate_path":[3,0,3],"reference":{"authored_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":[]},"roles":["exclusion"],"stage_index":0}],"source_digest":"02a2b906e3899438521845b14f679b9a1940f39e37592505c2dbe8237a30f12b","version":1},"global_time_window":{"seconds":540},"parse_failed":false,"stage_summary":["kql:query"]},"unit":0,"url":"https://github.com/elastic/detection-rules/blob/main/rules/integrations/azure/privilege_escalation_azure_rbac_administrator_roles_assigned.toml"}
  • {"context":{"command":"kql:query","filter_pred":{"children":[{"field":"data_stream.dataset","kind":"eq","values":["azure.activitylogs"]},{"field":"event.action","kind":"eq","values":["MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"]},{"children":[{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*18d7d88d-d35e-4fb5-a5c3-7773c20a72d9*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*f58310d9-a9f6-439a-9e8d-f62e7b41a168*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*b24988ac-6180-42a0-ab88-20f7382dd24c*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*8e3af657-a8ff-443c-a75c-2fe8c4bcb635*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*92b92042-07d9-4307-87f7-36a593fc5850*"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*a8889054-8d42-49c9-bc1c-52486c10e7cd*"]}],"kind":"or"},{"children":[{"children":[{"field":"azure.activitylogs.identity.claims.appid","kind":"eq","values":["7319c514-987d-4e9b-ac3d-d38c4f427f4c"]},{"field":"azure.activitylogs.identity.authorization.evidence.role","kind":"eq","values":["Service Owner role"]},{"field":"azure.activitylogs.identity.authorization.evidence.principal_type","kind":"eq","values":["ServicePrincipal"]},{"field":"azure.activitylogs.properties.requestbody.properties.roleDefinitionId","kind":"wildcard","values":["*b24988ac-6180-42a0-ab88-20f7382dd24c*"]}],"kind":"and"}],"kind":"not"}],"kind":"and"},"index":0,"options":{"from":"now-9m"},"source_text":"data_stream.dataset: azure.activitylogs and\n event.action: \"MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE\" and\n azure.activitylogs.properties.requestbody.properties.roleDefinitionId:\n (\n *18d7d88d-d35e-4fb5-a5c3-7773c20a72d9* or\n *f58310d9-a9f6-439a-9e8d-f62e7b41a168* or\n *b24988ac-6180-42a0-ab88-20f7382dd24c* or\n *8e3af657-a8ff-443c-a75c-2fe8c4bcb635* or\n *92b92042-07d9-4307-87f7-36a593fc5850* or\n *a8889054-8d42-49c9-bc1c-52486c10e7cd*\n ) and not (\n azure.activitylogs.identity.claims.appid: \"7319c514-987d-4e9b-ac3d-d38c4f427f4c\" and\n azure.activitylogs.identity.authorization.evidence.role: \"Service Owner role\" and\n azure.activitylogs.identity.authorization.evidence.principal_type: \"ServicePrincipal\" and\n azure.activitylogs.properties.requestbody.properties.roleDefinitionId: *b24988ac-6180-42a0-ab88-20f7382dd24c*\n )","uses":["azure.activitylogs.identity.authorization.evidence.principal_type","azure.activitylogs.identity.authorization.evidence.role","azure.activitylogs.identity.claims.appid","azure.activitylogs.properties.requestbody.properties.roleDefinitionId","data_stream.dataset","event.action"]},"stage":0,"unit":0}

Consumer rule logic only; rule-selected role GUIDs are not role-definition authority.

Granting Of Permissions To An Account Sigma

Analysis: Complete. SIGMA consumer logic, not Azure platform authority.

Direct selector:

  • eq Microsoft.Authorization/roleAssignments/write
    Selector context
    Coordinate
    ["resolved-unit-v1-bd704edb50a33feadf6a2dc60f5f375b2355abdb2627dd45f8f5f666af208c40",0,[],0]
    Semantic scope
    resolved-unit-v1-bd704edb50a33feadf6a2dc60f5f375b2355abdb2627dd45f8f5f666af208c40/stage:0/filter
    Predicate path
    DNF terms
    0
    Stage
    0 sigma:and
Stage, filter, grouping, or window context
  • {"metadata":{"level":"medium","log_source":{"product":"azure","service":"activitylogs"}},"rule":{"field_usage":{"blockers":[],"conditions":[{"blockers":[],"category":"check","condition_id":"sigma:stage:0","inputs":[],"operands":[{"authored_token":"Microsoft.Authorization/roleAssignments/write","kind":"literal","position":"value","predicate_path":[],"reference":null,"value":"Microsoft.Authorization/roleAssignments/write"}],"predecessors":[],"predicate":{"kind":"eq","values":["Microsoft.Authorization/roleAssignments/write"]},"stage_index":0}],"coverage":"complete","occurrences":[],"source_digest":"e8729d09e9d98fb5788b7b1602bf71a6b750a86a8f91daa84bbfaa5ebb5127d4","version":1},"parse_failed":false,"sigma_condition":"keywords","stage_summary":["sigma:and"]},"unit":0,"url":"https://github.com/SigmaHQ/sigma/blob/master/rules/cloud/azure/activity_logs/azure_granting_permission_detection.yml"}
  • {"context":{"command":"sigma:and","filter_pred":{"kind":"eq","values":["Microsoft.Authorization/roleAssignments/write"]},"index":0,"sigma_selector":{"condition":"keywords","condition_role":"and","selection_name":"keywords"},"source_text":"keywords:\n - Microsoft.Authorization/roleAssignments/write"},"stage":0,"unit":0}

Consumer rule logic only; rule-selected role GUIDs are not role-definition authority.

Fieldless whole-event keyword; this is not an operation-field test. Prose is not a represented predicate.

Role Assignment Created Sigma

Analysis: Complete. SIGMA consumer logic, not Azure platform authority.

Direct selector:

  • operationName eq MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE
    Selector context
    Coordinate
    ["resolved-unit-v1-883628ab898226bb16400e1b21a73cd363a99686322195d9f34e6ca06862f6ff",0,[0],0]
    Semantic scope
    resolved-unit-v1-883628ab898226bb16400e1b21a73cd363a99686322195d9f34e6ca06862f6ff/stage:0/filter
    Predicate path
    0
    DNF terms
    0
    Stage
    0 sigma:and
Additional represented rule context
  • properties.statusCode eq Created
    Selector context
    Coordinate
    ["resolved-unit-v1-883628ab898226bb16400e1b21a73cd363a99686322195d9f34e6ca06862f6ff",0,[1],0]
    Semantic scope
    resolved-unit-v1-883628ab898226bb16400e1b21a73cd363a99686322195d9f34e6ca06862f6ff/stage:0/filter
    Predicate path
    1
    DNF terms
    0
    Stage
    0 sigma:and
Stage, filter, grouping, or window context
  • {"metadata":{"level":"informational","log_source":{"product":"azure","service":"activitylogs"}},"rule":{"field_usage":{"blockers":[],"conditions":[{"blockers":[],"category":"check","condition_id":"sigma:stage:0","inputs":[{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"operationName","source_table":"","transforms":[]},{"authored_path":"properties.statusCode","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"properties.statusCode","source_table":"","transforms":[]}],"operands":[{"authored_token":"operationName","kind":"field","position":"lhs","predicate_path":[0],"reference":{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"operationName","source_table":"","transforms":[]},"value":"operationName"},{"authored_token":"MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE","kind":"literal","position":"value","predicate_path":[0],"reference":null,"value":"MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"},{"authored_token":"properties.statusCode","kind":"field","position":"lhs","predicate_path":[1],"reference":{"authored_path":"properties.statusCode","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"properties.statusCode","source_table":"","transforms":[]},"value":"properties.statusCode"},{"authored_token":"Created","kind":"literal","position":"value","predicate_path":[1],"reference":null,"value":"Created"}],"predecessors":[],"predicate":{"children":[{"field":"operationName","kind":"eq","values":["MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"]},{"field":"properties.statusCode","kind":"eq","values":["Created"]}],"kind":"and"},"stage_index":0}],"coverage":"complete","occurrences":[{"condition_id":"sigma:stage:0","dependency_path":[],"occurrence_id":"sigma:stage:0:0","predicate_path":[0],"reference":{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"operationName","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"sigma:stage:0","dependency_path":[],"occurrence_id":"sigma:stage:0:1","predicate_path":[1],"reference":{"authored_path":"properties.statusCode","binding_id":"","expansion_ids":[],"origin":"query","source_leg":"","source_path":"properties.statusCode","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0}],"source_digest":"331085cc0bd211d6298230b5d389d031870fc440a57c0345089cb6a99a612170","version":1},"parse_failed":false,"sigma_condition":"selection","stage_summary":["sigma:and"]},"unit":0,"url":"https://github.com/Yamato-Security/suzaku-rules/blob/599033b7d5c75a8daafdbc0130a476ca12afeaf6/suzaku/azure/activity_logs/azure_role_assignment_created.yml"}
  • {"context":{"command":"sigma:and","filter_pred":{"children":[{"field":"operationName","kind":"eq","values":["MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"]},{"field":"properties.statusCode","kind":"eq","values":["Created"]}],"kind":"and"},"index":0,"sigma_selector":{"condition":"selection","condition_role":"and","selection_name":"selection"},"source_text":"selection:\n operationName: MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE\n properties.statusCode: Created"},"stage":0,"unit":0}

Consumer rule logic only; rule-selected role GUIDs are not role-definition authority.

Partial or ambiguous operation detections

Suspicious granting of permissions to an account Kusto

Analysis: Partial. KUSTO consumer logic, not Azure platform authority.

Direct selector:

  • OperationNameValue eq microsoft.authorization/roleassignments/write
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",5,[0],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:5/filter
    Predicate path
    0
    DNF terms
    0, 1
    Stage
    5 join
Additional represented rule context
  • OperationNameValue eq microsoft.authorization/roleassignments/write negated
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",1,[],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:1/filter
    Predicate path
    DNF terms
    0
    Stage
    1 where
  • AssignmentCountbyCaller ge 5
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",12,[],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:12/filter
    Predicate path
    DNF terms
    0
    Stage
    12 where
    Transforms
    number
  • TimeGenerated time range >= optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",2,[],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:2/filter
    Predicate path
    DNF terms
    0
    Stage
    2 where
  • TimeGenerated time range 1209600 optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",2,[],1]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:2/filter
    Predicate path
    DNF terms
    1
    Stage
    2 where
  • TimeGenerated time range <= optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",2,[],2]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:2/filter
    Predicate path
    DNF terms
    2
    Stage
    2 where
  • TimeGenerated time range 86400 optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",2,[],3]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:2/filter
    Predicate path
    DNF terms
    3
    Stage
    2 where
  • count_ ge 5
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",4,[],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:4/filter
    Predicate path
    DNF terms
    0
    Stage
    4 where
    Transforms
    number
  • TimeGenerated time range > optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",5,[1],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:5/filter
    Predicate path
    1
    DNF terms
    0
    Stage
    5 join
  • TimeGenerated time range 86400 optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",5,[1],1]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:5/filter
    Predicate path
    1
    DNF terms
    1
    Stage
    5 join
  • OperationNameValue eq microsoft.authorization/roleassignments/write
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[0],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    0
    DNF terms
    0, 1, 2, 3, 4, 5, 6, 7
    Stage
    9 join
  • TimeGenerated time range >= optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[1],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    1
    DNF terms
    0, 1
    Stage
    9 join
  • TimeGenerated time range 1209600 optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[1],1]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    1
    DNF terms
    2, 3
    Stage
    9 join
  • TimeGenerated time range <= optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[1],2]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    1
    DNF terms
    4, 5
    Stage
    9 join
  • TimeGenerated time range 86400 optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[1],3]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    1
    DNF terms
    6, 7
    Stage
    9 join
  • count_ ge 5
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[2],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    2
    DNF terms
    0, 1, 2, 3, 4, 5, 6, 7
    Stage
    9 join
    Transforms
    number
  • OperationNameValue eq microsoft.authorization/roleassignments/write
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[3,0],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    3, 0
    DNF terms
    0, 1, 2, 3, 4, 5, 6, 7
    Stage
    9 join
  • TimeGenerated time range > optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[3,1],0]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    3, 1
    DNF terms
    0, 2, 4, 6
    Stage
    9 join
  • TimeGenerated time range 86400 optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f",9,[3,1],1]
    Semantic scope
    resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter
    Predicate path
    3, 1
    DNF terms
    1, 3, 5, 7
    Stage
    9 join
Stage, filter, grouping, or window context
  • {"metadata":{"connector_ids":["AzureActivity","BehaviorAnalytics"],"level":"medium","query_frequency_seconds":86400,"required_data_types":["AzureActivity","IdentityInfo"]},"rule":{"field_usage":{"blockers":["unresolved_source:externaldata"],"conditions":[{"blockers":[],"category":"check","condition_id":"stage:1/condition:0","inputs":[{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"OperationNameValue","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"value":"OperationNameValue"},{"authored_token":"\"microsoft.authorization/roleassignments/write\"","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":"microsoft.authorization/roleassignments/write"}],"predecessors":[],"predicate":{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},"stage_index":1},{"blockers":[],"category":"check","condition_id":"stage:2/condition:1","inputs":[{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"TimeGenerated","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"value":"TimeGenerated"},{"authored_token":"ago(starttime)","kind":"expression","position":"value","predicate_path":[],"reference":null,"value":"ago(starttime)"},{"authored_token":"ago(endtime)","kind":"expression","position":"value","predicate_path":[],"reference":null,"value":"ago(endtime)"}],"predecessors":["stage:1/condition:0"],"predicate":{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},"stage_index":2},{"blockers":[],"category":"calculation","condition_id":"stage:4/condition:2","inputs":[{"authored_path":"count_","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"count_","source_table":"AzureActivity","transforms":["count"]}],"operands":[{"authored_token":"count_","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"count_","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"count_","source_table":"AzureActivity","transforms":["count"]},"value":"count_"},{"authored_token":"alertOperationThreshold:5","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":5}],"predecessors":["stage:2/condition:1"],"predicate":{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]},"stage_index":4},{"blockers":[],"category":"check","condition_id":"stage:7/condition:3","inputs":[{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"OperationNameValue","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"value":"OperationNameValue"},{"authored_token":"\"microsoft.authorization/roleassignments/write\"","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":"microsoft.authorization/roleassignments/write"}],"predecessors":[],"predicate":{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},"stage_index":5},{"blockers":[],"category":"calculation","condition_id":"stage:8/condition:4","inputs":[{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"TimeGenerated","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"value":"TimeGenerated"},{"authored_token":"ago(endtime)","kind":"expression","position":"rhs","predicate_path":[],"reference":null,"value":"ago(endtime)"}],"predecessors":["stage:7/condition:3"],"predicate":{"field":"TimeGenerated","kind":"time_range","values":[">","86400"]},"stage_index":5},{"blockers":[],"category":"correlation","condition_id":"stage:5/condition:5","inputs":[{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"$left.CallerIpAddress","kind":"field","position":"lhs","predicate_path":[0],"reference":{"authored_path":"$left.CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"value":"$left.CallerIpAddress"},{"authored_token":"$right.CallerIpAddress","kind":"field","position":"rhs","predicate_path":[0],"reference":{"authored_path":"$right.CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"value":"$right.CallerIpAddress"},{"authored_token":"$left.Caller","kind":"field","position":"lhs","predicate_path":[1],"reference":{"authored_path":"$left.Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"value":"$left.Caller"},{"authored_token":"$right.Caller","kind":"field","position":"rhs","predicate_path":[1],"reference":{"authored_path":"$right.Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"value":"$right.Caller"}],"predecessors":["stage:4/condition:2","stage:8/condition:4"],"predicate":{"children":[{"field":"$left.CallerIpAddress","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.CallerIpAddress"]},{"field":"$left.Caller","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.Caller"]}],"kind":"and"},"stage_index":5},{"blockers":[],"category":"correlation","condition_id":"stage:8/condition:6","inputs":[{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","case","split","tostring"]},{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},{"authored_path":"$right.ID","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"ID","source_table":"","transforms":[]}],"operands":[{"authored_token":"$left.RoleAssignedID","kind":"field","position":"lhs","predicate_path":[],"reference":null,"value":"$left.RoleAssignedID"},{"authored_token":"$right.ID","kind":"field","position":"rhs","predicate_path":[],"reference":{"authored_path":"$right.ID","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"ID","source_table":"","transforms":[]},"value":"$right.ID"}],"predecessors":["stage:5/condition:5"],"predicate":{"field":"$left.RoleAssignedID","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.ID"]},"stage_index":8},{"blockers":[],"category":"check","condition_id":"stage:11/condition:7","inputs":[{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"OperationNameValue","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"value":"OperationNameValue"},{"authored_token":"\"microsoft.authorization/roleassignments/write\"","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":"microsoft.authorization/roleassignments/write"}],"predecessors":[],"predicate":{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},"stage_index":9},{"blockers":[],"category":"check","condition_id":"stage:12/condition:8","inputs":[{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"TimeGenerated","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"value":"TimeGenerated"},{"authored_token":"ago(starttime)","kind":"expression","position":"value","predicate_path":[],"reference":null,"value":"ago(starttime)"},{"authored_token":"ago(endtime)","kind":"expression","position":"value","predicate_path":[],"reference":null,"value":"ago(endtime)"}],"predecessors":["stage:11/condition:7"],"predicate":{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},"stage_index":9},{"blockers":[],"category":"calculation","condition_id":"stage:14/condition:9","inputs":[{"authored_path":"count_","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"count_","source_table":"AzureActivity","transforms":["count"]}],"operands":[{"authored_token":"count_","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"count_","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"count_","source_table":"AzureActivity","transforms":["count"]},"value":"count_"},{"authored_token":"alertOperationThreshold:5","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":5}],"predecessors":["stage:12/condition:8"],"predicate":{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]},"stage_index":9},{"blockers":[],"category":"check","condition_id":"stage:17/condition:10","inputs":[{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"OperationNameValue","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"value":"OperationNameValue"},{"authored_token":"\"microsoft.authorization/roleassignments/write\"","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":"microsoft.authorization/roleassignments/write"}],"predecessors":[],"predicate":{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},"stage_index":9},{"blockers":[],"category":"calculation","condition_id":"stage:18/condition:11","inputs":[{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"TimeGenerated","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"value":"TimeGenerated"},{"authored_token":"ago(endtime)","kind":"expression","position":"rhs","predicate_path":[],"reference":null,"value":"ago(endtime)"}],"predecessors":["stage:17/condition:10"],"predicate":{"field":"TimeGenerated","kind":"time_range","values":[">","86400"]},"stage_index":9},{"blockers":[],"category":"correlation","condition_id":"stage:15/condition:12","inputs":[{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"$left.CallerIpAddress","kind":"field","position":"lhs","predicate_path":[0],"reference":{"authored_path":"$left.CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"value":"$left.CallerIpAddress"},{"authored_token":"$right.CallerIpAddress","kind":"field","position":"rhs","predicate_path":[0],"reference":{"authored_path":"$right.CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"value":"$right.CallerIpAddress"},{"authored_token":"$left.Caller","kind":"field","position":"lhs","predicate_path":[1],"reference":{"authored_path":"$left.Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"value":"$left.Caller"},{"authored_token":"$right.Caller","kind":"field","position":"rhs","predicate_path":[1],"reference":{"authored_path":"$right.Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"value":"$right.Caller"}],"predecessors":["stage:14/condition:9","stage:18/condition:11"],"predicate":{"children":[{"field":"$left.CallerIpAddress","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.CallerIpAddress"]},{"field":"$left.Caller","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.Caller"]}],"kind":"and"},"stage_index":9},{"blockers":[],"category":"correlation","condition_id":"stage:18/condition:13","inputs":[{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","case","split","tostring"]},{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},{"authored_path":"$right.ID","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"ID","source_table":"","transforms":[]}],"operands":[{"authored_token":"$left.RoleAssignedID","kind":"field","position":"lhs","predicate_path":[],"reference":null,"value":"$left.RoleAssignedID"},{"authored_token":"$right.ID","kind":"field","position":"rhs","predicate_path":[],"reference":{"authored_path":"$right.ID","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"ID","source_table":"","transforms":[]},"value":"$right.ID"}],"predecessors":["stage:15/condition:12"],"predicate":{"field":"$left.RoleAssignedID","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.ID"]},"stage_index":9},{"blockers":[],"category":"correlation","condition_id":"stage:9/condition:14","inputs":[{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:0:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]}],"operands":[{"authored_token":"$left.Caller","kind":"field","position":"lhs","predicate_path":[0],"reference":{"authored_path":"$left.Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"value":"$left.Caller"},{"authored_token":"$right.Caller","kind":"field","position":"rhs","predicate_path":[0],"reference":{"authored_path":"$right.Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:0:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"value":"$right.Caller"},{"authored_token":"$left.CallerIpAddress","kind":"field","position":"lhs","predicate_path":[1],"reference":{"authored_path":"$left.CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"value":"$left.CallerIpAddress"},{"authored_token":"$right.CallerIpAddress","kind":"field","position":"rhs","predicate_path":[1],"reference":{"authored_path":"$right.CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"value":"$right.CallerIpAddress"}],"predecessors":["stage:8/condition:6","stage:18/condition:13"],"predicate":{"children":[{"field":"$left.Caller","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.Caller"]},{"field":"$left.CallerIpAddress","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.CallerIpAddress"]}],"kind":"and"},"stage_index":9},{"blockers":[],"category":"correlation","condition_id":"stage:11/condition:15","inputs":[{"authored_path":"$left.PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},{"authored_path":"$left.PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},{"authored_path":"$left.PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},{"authored_path":"$right.AccountObjectId","binding_id":"kusto:root/stage:1/right/stage:0/group:0:AccountObjectId","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"AccountObjectId","source_table":"IdentityInfo","transforms":[]}],"operands":[{"authored_token":"$left.PrincipalId","kind":"field","position":"lhs","predicate_path":[],"reference":null,"value":"$left.PrincipalId"},{"authored_token":"$right.AccountObjectId","kind":"field","position":"rhs","predicate_path":[],"reference":{"authored_path":"$right.AccountObjectId","binding_id":"kusto:root/stage:1/right/stage:0/group:0:AccountObjectId","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"AccountObjectId","source_table":"IdentityInfo","transforms":[]},"value":"$right.AccountObjectId"}],"predecessors":["stage:9/condition:14"],"predicate":{"field":"$left.PrincipalId","kind":"cross_field_compare","transforms":["op:eq","kusto_rhs_dynamic_path","kusto_table_qualified"],"values":["$right.AccountObjectId"]},"stage_index":11},{"blockers":[],"category":"calculation","condition_id":"stage:12/condition:16","inputs":[{"authored_path":"AssignmentCountbyCaller","binding_id":"kusto:root/stage:0/aggregate:0:*:AssignmentCountbyCaller","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"AssignmentCountbyCaller","source_table":"AzureActivity","transforms":["count"]}],"operands":[{"authored_token":"AssignmentCountbyCaller","kind":"field","position":"lhs","predicate_path":[],"reference":{"authored_path":"AssignmentCountbyCaller","binding_id":"kusto:root/stage:0/aggregate:0:*:AssignmentCountbyCaller","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"AssignmentCountbyCaller","source_table":"AzureActivity","transforms":["count"]},"value":"AssignmentCountbyCaller"},{"authored_token":"alertOperationThreshold:5","kind":"literal","position":"rhs","predicate_path":[],"reference":null,"value":5}],"predecessors":["stage:11/condition:15"],"predicate":{"field":"AssignmentCountbyCaller","kind":"ge","transforms":["number"],"values":["5"]},"stage_index":12}],"coverage":"partial","occurrences":[{"condition_id":"stage:1/condition:0","dependency_path":[],"occurrence_id":"stage:1/occurrence:0","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["exclusion"],"stage_index":1},{"condition_id":"stage:2/condition:1","dependency_path":[],"occurrence_id":"stage:2/occurrence:1","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"roles":["exclusion","time"],"stage_index":2},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:3/occurrence:2","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":3},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:3/occurrence:3","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":3},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:3/occurrence:4","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["bin"]},"roles":["grouping"],"stage_index":3},{"condition_id":"stage:4/condition:2","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_"],"occurrence_id":"stage:4/occurrence:5","predicate_path":[],"reference":{"authored_path":"count_","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"count_","source_table":"AzureActivity","transforms":["count"]},"roles":["exclusion","derived_filter"],"stage_index":4},{"condition_id":"stage:7/condition:3","dependency_path":[],"occurrence_id":"stage:7/occurrence:6","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["filter"],"stage_index":5},{"condition_id":"stage:8/condition:4","dependency_path":[],"occurrence_id":"stage:8/occurrence:7","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"roles":["filter","time"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:8","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["min"]},"roles":["aggregation","time"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:9","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["max"]},"roles":["aggregation","time"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:10","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["make_set"]},"roles":["aggregation","time"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:11","predicate_path":[],"reference":{"authored_path":"ActivityStatusValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ActivityStatusValue","source_table":"AzureActivity","transforms":["make_set"]},"roles":["aggregation"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:12","predicate_path":[],"reference":{"authored_path":"CorrelationId","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CorrelationId","source_table":"AzureActivity","transforms":["make_set"]},"roles":["aggregation"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:13","predicate_path":[],"reference":{"authored_path":"ResourceId","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ResourceId","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:14","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:15","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:16","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:17","predicate_path":[],"reference":{"authored_path":"Resource","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Resource","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:18","predicate_path":[],"reference":{"authored_path":"ResourceGroup","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ResourceGroup","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId"],"occurrence_id":"stage:14/occurrence:19","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId"],"occurrence_id":"stage:14/occurrence:20","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId"],"occurrence_id":"stage:14/occurrence:21","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType"],"occurrence_id":"stage:14/occurrence:22","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType"],"occurrence_id":"stage:14/occurrence:23","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalType","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType"],"occurrence_id":"stage:14/occurrence:24","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalType","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope"],"occurrence_id":"stage:14/occurrence:25","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope"],"occurrence_id":"stage:14/occurrence:26","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.Scope","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope"],"occurrence_id":"stage:14/occurrence:27","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.scope","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails"],"occurrence_id":"stage:14/occurrence:28","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails"],"occurrence_id":"stage:14/occurrence:29","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails"],"occurrence_id":"stage:14/occurrence:30","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":5},{"condition_id":"stage:5/condition:5","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress"],"occurrence_id":"stage:5/occurrence:31","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":5},{"condition_id":"stage:5/condition:5","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress"],"occurrence_id":"stage:5/occurrence:32","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":5},{"condition_id":"stage:5/condition:5","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller"],"occurrence_id":"stage:5/occurrence:33","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":5},{"condition_id":"stage:5/condition:5","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller"],"occurrence_id":"stage:5/occurrence:34","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":5},{"condition_id":"stage:8/condition:6","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:8/occurrence:35","predicate_path":[],"reference":{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","case","split","tostring"]},"roles":["join"],"stage_index":8},{"condition_id":"stage:8/condition:6","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:8/occurrence:36","predicate_path":[],"reference":{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["join"],"stage_index":8},{"condition_id":"stage:8/condition:6","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:8/occurrence:37","predicate_path":[],"reference":{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["join"],"stage_index":8},{"condition_id":"stage:8/condition:6","dependency_path":[],"occurrence_id":"stage:8/occurrence:38","predicate_path":[],"reference":{"authored_path":"$right.ID","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"ID","source_table":"","transforms":[]},"roles":["join"],"stage_index":8},{"condition_id":"stage:11/condition:7","dependency_path":[],"occurrence_id":"stage:11/occurrence:39","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["exclusion"],"stage_index":9},{"condition_id":"stage:12/condition:8","dependency_path":[],"occurrence_id":"stage:12/occurrence:40","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"roles":["exclusion","time"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:13/occurrence:41","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:13/occurrence:42","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:13/occurrence:43","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["bin"]},"roles":["grouping"],"stage_index":9},{"condition_id":"stage:14/condition:9","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_"],"occurrence_id":"stage:14/occurrence:44","predicate_path":[],"reference":{"authored_path":"count_","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/aggregate:0:count_","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"count_","source_table":"AzureActivity","transforms":["count"]},"roles":["exclusion","derived_filter"],"stage_index":9},{"condition_id":"stage:17/condition:10","dependency_path":[],"occurrence_id":"stage:17/occurrence:45","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["filter"],"stage_index":9},{"condition_id":"stage:18/condition:11","dependency_path":[],"occurrence_id":"stage:18/occurrence:46","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":[]},"roles":["filter","time"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:47","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["min"]},"roles":["aggregation","time"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:48","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["max"]},"roles":["aggregation","time"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:49","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["make_set"]},"roles":["aggregation","time"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:50","predicate_path":[],"reference":{"authored_path":"ActivityStatusValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ActivityStatusValue","source_table":"AzureActivity","transforms":["make_set"]},"roles":["aggregation"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:51","predicate_path":[],"reference":{"authored_path":"CorrelationId","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CorrelationId","source_table":"AzureActivity","transforms":["make_set"]},"roles":["aggregation"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:52","predicate_path":[],"reference":{"authored_path":"ResourceId","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ResourceId","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:53","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:54","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:55","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:56","predicate_path":[],"reference":{"authored_path":"Resource","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Resource","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:24/occurrence:57","predicate_path":[],"reference":{"authored_path":"ResourceGroup","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ResourceGroup","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId"],"occurrence_id":"stage:24/occurrence:58","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId"],"occurrence_id":"stage:24/occurrence:59","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId"],"occurrence_id":"stage:24/occurrence:60","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType"],"occurrence_id":"stage:24/occurrence:61","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType"],"occurrence_id":"stage:24/occurrence:62","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalType","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType"],"occurrence_id":"stage:24/occurrence:63","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalType","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope"],"occurrence_id":"stage:24/occurrence:64","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope"],"occurrence_id":"stage:24/occurrence:65","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.Scope","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope"],"occurrence_id":"stage:24/occurrence:66","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.scope","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails"],"occurrence_id":"stage:24/occurrence:67","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails"],"occurrence_id":"stage:24/occurrence:68","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails"],"occurrence_id":"stage:24/occurrence:69","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":9},{"condition_id":"stage:15/condition:12","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress"],"occurrence_id":"stage:15/occurrence:70","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:0:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:15/condition:12","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress"],"occurrence_id":"stage:15/occurrence:71","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:15/condition:12","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller"],"occurrence_id":"stage:15/occurrence:72","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:1/group:1:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:15/condition:12","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller"],"occurrence_id":"stage:15/occurrence:73","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:18/condition:13","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:18/occurrence:74","predicate_path":[],"reference":{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","case","split","tostring"]},"roles":["join"],"stage_index":9},{"condition_id":"stage:18/condition:13","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:18/occurrence:75","predicate_path":[],"reference":{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["join"],"stage_index":9},{"condition_id":"stage:18/condition:13","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:18/occurrence:76","predicate_path":[],"reference":{"authored_path":"$left.RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["join"],"stage_index":9},{"condition_id":"stage:18/condition:13","dependency_path":[],"occurrence_id":"stage:18/occurrence:77","predicate_path":[],"reference":{"authored_path":"$right.ID","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"ID","source_table":"","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller"],"occurrence_id":"stage:19/occurrence:78","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress"],"occurrence_id":"stage:19/occurrence:79","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["grouping"],"stage_index":9},{"condition_id":"stage:9/condition:14","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller"],"occurrence_id":"stage:9/occurrence:80","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:9/condition:14","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:0:Caller"],"occurrence_id":"stage:9/occurrence:81","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:0:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:9/condition:14","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress"],"occurrence_id":"stage:9/occurrence:82","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"stage:9/condition:14","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:1:CallerIpAddress"],"occurrence_id":"stage:9/occurrence:83","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/group:1:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["join"],"stage_index":9},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/aggregate:0:StartTimeUtc"],"occurrence_id":"stage:10/occurrence:84","predicate_path":[],"reference":{"authored_path":"StartTimeUtc","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/aggregate:0:StartTimeUtc","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["min","arg_max"]},"roles":["aggregation","time"],"stage_index":10},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:10/occurrence:85","predicate_path":[],"reference":{"authored_path":"*","binding_id":"","expansion_ids":[],"origin":"computed","source_leg":"","source_path":"*","source_table":"","transforms":["arg_max"]},"roles":["aggregation","time"],"stage_index":10},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId"],"occurrence_id":"stage:10/occurrence:86","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["grouping"],"stage_index":10},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId"],"occurrence_id":"stage:10/occurrence:87","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":10},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId"],"occurrence_id":"stage:10/occurrence:88","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["grouping"],"stage_index":10},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:10/occurrence:89","predicate_path":[],"reference":{"authored_path":"RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","case","split","tostring"]},"roles":["grouping"],"stage_index":10},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:10/occurrence:90","predicate_path":[],"reference":{"authored_path":"RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["grouping"],"stage_index":10},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID"],"occurrence_id":"stage:10/occurrence:91","predicate_path":[],"reference":{"authored_path":"RoleAssignedID","binding_id":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["grouping"],"stage_index":10},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:13/occurrence:92","predicate_path":[],"reference":{"authored_path":"TimeGenerated","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"TimeGenerated","source_table":"IdentityInfo","transforms":["arg_max"]},"roles":["aggregation","time"],"stage_index":11},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:13/occurrence:93","predicate_path":[],"reference":{"authored_path":"*","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"*","source_table":"IdentityInfo","transforms":["arg_max"]},"roles":["aggregation","time"],"stage_index":11},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:13/occurrence:94","predicate_path":[],"reference":{"authored_path":"AccountObjectId","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"AccountObjectId","source_table":"IdentityInfo","transforms":[]},"roles":["grouping"],"stage_index":11},{"condition_id":"stage:11/condition:15","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","kusto:root/stage:0/group:0:PrincipalId"],"occurrence_id":"stage:11/occurrence:95","predicate_path":[],"reference":{"authored_path":"$left.PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["join"],"stage_index":11},{"condition_id":"stage:11/condition:15","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","kusto:root/stage:0/group:0:PrincipalId"],"occurrence_id":"stage:11/occurrence:96","predicate_path":[],"reference":{"authored_path":"$left.PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["join"],"stage_index":11},{"condition_id":"stage:11/condition:15","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","kusto:root/stage:0/group:0:PrincipalId"],"occurrence_id":"stage:11/occurrence:97","predicate_path":[],"reference":{"authored_path":"$left.PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["join"],"stage_index":11},{"condition_id":"stage:11/condition:15","dependency_path":["kusto:root/stage:1/right/stage:0/group:0:AccountObjectId"],"occurrence_id":"stage:11/occurrence:98","predicate_path":[],"reference":{"authored_path":"$right.AccountObjectId","binding_id":"kusto:root/stage:1/right/stage:0/group:0:AccountObjectId","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"AccountObjectId","source_table":"IdentityInfo","transforms":[]},"roles":["join"],"stage_index":11},{"condition_id":"stage:12/condition:16","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/aggregate:0:AssignmentCountbyCaller","kusto:root/stage:0/aggregate:0:*:AssignmentCountbyCaller"],"occurrence_id":"stage:12/occurrence:99","predicate_path":[],"reference":{"authored_path":"AssignmentCountbyCaller","binding_id":"kusto:root/stage:0/aggregate:0:*:AssignmentCountbyCaller","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"AssignmentCountbyCaller","source_table":"AzureActivity","transforms":["count"]},"roles":["filter","derived_filter"],"stage_index":12},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/aggregate:2:ActivityTimeStamp","kusto:root/stage:0/aggregate:0:*:ActivityTimeStamp"],"occurrence_id":"stage:14/occurrence:100","predicate_path":[],"reference":{"authored_path":"ActivityTimeStamp","binding_id":"kusto:root/stage:0/aggregate:0:*:ActivityTimeStamp","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["make_set"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:3:OperationNameValue","kusto:root/stage:0/aggregate:0:*:OperationNameValue"],"occurrence_id":"stage:14/occurrence:101","predicate_path":[],"reference":{"authored_path":"OperationNameValue","binding_id":"kusto:root/stage:0/aggregate:0:*:OperationNameValue","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"OperationNameValue","source_table":"AzureActivity","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","kusto:root/stage:0/aggregate:0:*:Caller"],"occurrence_id":"stage:14/occurrence:102","predicate_path":[],"reference":{"authored_path":"Caller","binding_id":"kusto:root/stage:0/aggregate:0:*:Caller","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","kusto:root/stage:0/aggregate:0:*:CallerIpAddress"],"occurrence_id":"stage:14/occurrence:103","predicate_path":[],"reference":{"authored_path":"CallerIpAddress","binding_id":"kusto:root/stage:0/aggregate:0:*:CallerIpAddress","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","kusto:root/stage:0/group:0:PrincipalId"],"occurrence_id":"stage:14/occurrence:104","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","kusto:root/stage:0/group:0:PrincipalId"],"occurrence_id":"stage:14/occurrence:105","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:2/assign:0:PrincipalId","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:6:PrincipalId","kusto:root/stage:0/group:0:PrincipalId"],"occurrence_id":"stage:14/occurrence:106","predicate_path":[],"reference":{"authored_path":"PrincipalId","binding_id":"kusto:root/stage:0/group:0:PrincipalId","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","kusto:root/stage:0/group:1:RoleAssignedID"],"occurrence_id":"stage:14/occurrence:107","predicate_path":[],"reference":{"authored_path":"RoleAssignedID","binding_id":"kusto:root/stage:0/group:1:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","case","split","tostring"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","kusto:root/stage:0/group:1:RoleAssignedID"],"occurrence_id":"stage:14/occurrence:108","predicate_path":[],"reference":{"authored_path":"RoleAssignedID","binding_id":"kusto:root/stage:0/group:1:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/stage:0/assign:0:RoleAssignedID","kusto:root/stage:0/group:1:RoleAssignedID"],"occurrence_id":"stage:14/occurrence:109","predicate_path":[],"reference":{"authored_path":"RoleAssignedID","binding_id":"kusto:root/stage:0/group:1:RoleAssignedID","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId[(- 1)]","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case","split","tostring"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/stage:0/aggregate:0:*:RoleAddedDetails"],"occurrence_id":"stage:14/occurrence:110","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/stage:0/aggregate:0:*:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/stage:0/aggregate:0:*:RoleAddedDetails"],"occurrence_id":"stage:14/occurrence:111","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/stage:0/aggregate:0:*:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.RoleDefinitionId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:5/assign:0:RoleAddedDetails","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:9:RoleAddedDetails","kusto:root/stage:0/aggregate:0:*:RoleAddedDetails"],"occurrence_id":"stage:14/occurrence:112","predicate_path":[],"reference":{"authored_path":"RoleAddedDetails","binding_id":"kusto:root/stage:0/aggregate:0:*:RoleAddedDetails","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.roleDefinitionId","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:113","predicate_path":[],"reference":{"authored_path":"Role","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"Role","source_table":"IdentityInfo","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:114","predicate_path":[],"reference":{"authored_path":"RoleDescription","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"RoleDescription","source_table":"IdentityInfo","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:115","predicate_path":[],"reference":{"authored_path":"AccountUPN","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"AccountUPN","source_table":"IdentityInfo","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:116","predicate_path":[],"reference":{"authored_path":"AccountCreationTime","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"AccountCreationTime","source_table":"IdentityInfo","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:117","predicate_path":[],"reference":{"authored_path":"GroupMembership","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"GroupMembership","source_table":"IdentityInfo","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":[],"occurrence_id":"stage:14/occurrence:118","predicate_path":[],"reference":{"authored_path":"UserType","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"kusto:root/stage:1/right/source","source_path":"UserType","source_table":"IdentityInfo","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/aggregate:3:ActivityStatusValue","kusto:root/stage:0/aggregate:0:*:ActivityStatusValue"],"occurrence_id":"stage:14/occurrence:119","predicate_path":[],"reference":{"authored_path":"ActivityStatusValue","binding_id":"kusto:root/stage:0/aggregate:0:*:ActivityStatusValue","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ActivityStatusValue","source_table":"AzureActivity","transforms":["make_set"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:5:ResourceGroup","kusto:root/stage:0/aggregate:0:*:ResourceGroup"],"occurrence_id":"stage:14/occurrence:120","predicate_path":[],"reference":{"authored_path":"ResourceGroup","binding_id":"kusto:root/stage:0/aggregate:0:*:ResourceGroup","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"ResourceGroup","source_table":"AzureActivity","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:7:PrincipalType","kusto:root/stage:0/aggregate:0:*:PrincipalType"],"occurrence_id":"stage:14/occurrence:121","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/stage:0/aggregate:0:*:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:7:PrincipalType","kusto:root/stage:0/aggregate:0:*:PrincipalType"],"occurrence_id":"stage:14/occurrence:122","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/stage:0/aggregate:0:*:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.PrincipalType","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:3/assign:0:PrincipalType","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:7:PrincipalType","kusto:root/stage:0/aggregate:0:*:PrincipalType"],"occurrence_id":"stage:14/occurrence:123","predicate_path":[],"reference":{"authored_path":"PrincipalType","binding_id":"kusto:root/stage:0/aggregate:0:*:PrincipalType","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.principalType","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:8:Scope","kusto:root/stage:0/aggregate:0:*:Scope"],"occurrence_id":"stage:14/occurrence:124","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/stage:0/aggregate:0:*:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody","source_table":"AzureActivity","transforms":["parse_json","tostring","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:8:Scope","kusto:root/stage:0/aggregate:0:*:Scope"],"occurrence_id":"stage:14/occurrence:125","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/stage:0/aggregate:0:*:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.Properties.Scope","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:1/assign:0:parsed_property","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:4/assign:0:Scope","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:8:Scope","kusto:root/stage:0/aggregate:0:*:Scope"],"occurrence_id":"stage:14/occurrence:126","predicate_path":[],"reference":{"authored_path":"Scope","binding_id":"kusto:root/stage:0/aggregate:0:*:Scope","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Properties.requestbody.properties.scope","source_table":"AzureActivity","transforms":["parse_json","tostring","parse_json","case"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/aggregate:4:CorrelationId","kusto:root/stage:0/aggregate:0:*:CorrelationId"],"occurrence_id":"stage:14/occurrence:127","predicate_path":[],"reference":{"authored_path":"CorrelationId","binding_id":"kusto:root/stage:0/aggregate:0:*:CorrelationId","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CorrelationId","source_table":"AzureActivity","transforms":["make_set"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/aggregate:0:StartTimeUtc","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:4/assign:0:timestamp","kusto:root/stage:0/aggregate:0:*:timestamp"],"occurrence_id":"stage:14/occurrence:128","predicate_path":[],"reference":{"authored_path":"timestamp","binding_id":"kusto:root/stage:0/aggregate:0:*:timestamp","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"TimeGenerated","source_table":"AzureActivity","transforms":["min"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:4/assign:1:AccountCustomEntity","kusto:root/stage:0/aggregate:0:*:AccountCustomEntity"],"occurrence_id":"stage:14/occurrence:129","predicate_path":[],"reference":{"authored_path":"AccountCustomEntity","binding_id":"kusto:root/stage:0/aggregate:0:*:AccountCustomEntity","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller","source_table":"AzureActivity","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:1:CallerIpAddress","kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:4/assign:2:IPCustomEntity","kusto:root/stage:0/aggregate:0:*:IPCustomEntity"],"occurrence_id":"stage:14/occurrence:130","predicate_path":[],"reference":{"authored_path":"IPCustomEntity","binding_id":"kusto:root/stage:0/aggregate:0:*:IPCustomEntity","expansion_ids":[],"origin":"source","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"CallerIpAddress","source_table":"AzureActivity","transforms":[]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/stage:0/aggregate:0:AssignmentCountbyCaller","kusto:root/stage:0/aggregate:0:*:AssignmentCountbyCaller"],"occurrence_id":"stage:14/occurrence:131","predicate_path":[],"reference":{"authored_path":"AssignmentCountbyCaller","binding_id":"kusto:root/stage:0/aggregate:0:*:AssignmentCountbyCaller","expansion_ids":[],"origin":"computed","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/stage:0/right/let:CallerIPCountSummary/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"AssignmentCountbyCaller","source_table":"AzureActivity","transforms":["count"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","kusto:root/stage:0/aggregate:0:*:Caller","kusto:root/stage:4/assign:0:Name"],"occurrence_id":"stage:14/occurrence:132","predicate_path":[],"reference":{"authored_path":"Name","binding_id":"kusto:root/stage:4/assign:0:Name","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller[0]","source_table":"AzureActivity","transforms":["split","tostring"]},"roles":["output"],"stage_index":14},{"condition_id":"","dependency_path":["kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/stage:6/group:2:Caller","kusto:root/stage:0/aggregate:0:*:Caller","kusto:root/stage:4/assign:1:UPNSuffix"],"occurrence_id":"stage:14/occurrence:133","predicate_path":[],"reference":{"authored_path":"UPNSuffix","binding_id":"kusto:root/stage:4/assign:1:UPNSuffix","expansion_ids":[],"origin":"nested","source_leg":"kusto:root/let:RoleAssignedActivityWithCount/let:RoleAssignedActivitywithRoleDetails/let:RoleAssignedActivity/stage:3/right/let:createRoleAssignmentActivity/source","source_path":"Caller[0]","source_table":"AzureActivity","transforms":["split","tostring"]},"roles":["output"],"stage_index":14}],"source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d","version":1},"global_time_window":{"kind":"bin","seconds":86400},"group_by_keys":["$left.PrincipalId","$left.RoleAssignedID","$right.AccountObjectId","$right.ID","Caller","CallerIpAddress","PrincipalId","RoleAssignedID"],"kusto_let_predicates":{"CallerIPCountSummary":{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]}],"kind":"and"},"RoleAssignedActivity":{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]}],"kind":"and"},"RoleAssignedActivityWithCount":{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]}],"kind":"and"},"RoleAssignedActivitywithRoleDetails":{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]}],"kind":"and"},"createRoleAssignmentActivity":{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]}},"kusto_let_sources":{"CallerIPCountSummary":["AzureActivity"],"RoleAssignedActivity":["AzureActivity"],"RoleAssignedActivityWithCount":["AzureActivity"],"RoleAssignedActivitywithRoleDetails":["AzureActivity"],"createRoleAssignmentActivity":["AzureActivity"]},"kusto_lets":"let starttime = 14d;\nlet endtime = 1d;\nlet alertOperationThreshold = 5;\nlet AzureBuiltInRole = externaldata(Role:string,RoleDescription:string,ID:string) [@\"https://raw.githubusercontent.com/Azure/Azure-Sentinel/master/Sample%20Data/Feeds/AzureBuiltInRole.csv\"] with (format=\"csv\", ignoreFirstRecord=True);\nlet createRoleAssignmentActivity = AzureActivity <inlined as stages below>;\nlet RoleAssignedActivity = createRoleAssignmentActivity <inlined as stages below>;\nlet RoleAssignedActivitywithRoleDetails = RoleAssignedActivity <inlined as stages below>;\nlet CallerIPCountSummary = RoleAssignedActivitywithRoleDetails | summarize AssignmentCountbyCaller = count() by Caller, CallerIpAddress;\nlet RoleAssignedActivityWithCount = RoleAssignedActivitywithRoleDetails <inlined as stages below>;","kusto_source_arguments_version":1,"output_fields":[{"name":"AccountCreationTime","source":"project"},{"name":"AccountCustomEntity","source":"project"},{"name":"AccountUPN","source":"project"},{"name":"ActivityStatusValue","source":"project"},{"name":"ActivityTimeStamp","source":"project"},{"name":"AssignmentCountbyCaller","source":"project"},{"name":"Caller","source":"project"},{"name":"CallerIpAddress","source":"project"},{"name":"CorrelationId","source":"project"},{"name":"GroupMembership","source":"project"},{"name":"IPCustomEntity","source":"project"},{"name":"OperationNameValue","source":"project"},{"name":"PrincipalId","source":"project"},{"name":"PrincipalType","source":"project"},{"name":"ResourceGroup","source":"project"},{"name":"Role","source":"project"},{"name":"RoleAddedDetails","source":"project"},{"name":"RoleAssignedID","source":"project"},{"name":"RoleDescription","source":"project"},{"name":"Scope","source":"project"},{"name":"UserType","source":"project"},{"name":"timestamp","source":"project"},{"name":"Name","source":"extend"},{"name":"UPNSuffix","source":"extend"}],"parse_failed":false,"stage_summary":["source","where","where","summarize","where","join","extend","extend","join","join","summarize","join","where","project","extend"]},"unit":0,"url":"https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Azure Activity/Analytic Rules/Granting_Permissions_To_Account_detection.yaml"}
  • {"context":{"command":"source","index":0,"kusto_stage":{"physical_leg":{"classification":"unresolved","leg_id":"kusto:root/source"},"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d","table":"AzureActivity","unrepresented_source_calls":[{"arguments":[{"default":null,"name":"Role","node":"UdfParam","type_name":"string"},{"default":null,"name":"RoleDescription","node":"UdfParam","type_name":"string"},{"default":null,"name":"ID","node":"UdfParam","type_name":"string"}],"reason":"source_arguments_unrepresented","source_name":"externaldata"}]}},"stage":0,"unit":0}
  • {"context":{"command":"where","filter_pred":{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},"index":1,"kusto_stage":{"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"uses":["OperationNameValue"]},"stage":1,"unit":0}
  • {"context":{"command":"where","filter_pred":{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},"index":2,"kusto_stage":{"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"time_window":{"kind":"between","seconds":1123200},"uses":["TimeGenerated","endtime","starttime"]},"stage":2,"unit":0}
  • {"context":{"aggregation":{"function":"count"},"command":"summarize","group_by":["CallerIpAddress","Caller"],"index":3,"kusto_stage":{"bin_seconds":86400,"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"time_window":{"kind":"bin","seconds":86400},"uses":["TimeGenerated"]},"stage":3,"unit":0}
  • {"context":{"command":"where","filter_pred":{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]},"index":4,"kusto_stage":{"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"uses":["alertOperationThreshold","count_"]},"stage":4,"unit":0}
  • {"context":{"command":"join","filter_pred":{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">","86400"]}],"kind":"and"},"group_by":["CallerIpAddress","Caller"],"has_subsearch":true,"index":5,"kusto_stage":{"bound_physical_leg_id":"kusto:root/stage:4/right","join_resolved_source":"AzureActivity","join_source":"createRoleAssignmentActivity","physical_leg":{"classification":"telemetry","leg_id":"kusto:root/stage:4/right","table":"AzureActivity"},"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"lossy_notes":["rightanti/rightantisemi join: the anchor leg carries the actual exclusion and is rendered as a positive co-occurrence filter, not an anti-join"],"options":{"kind":"rightanti"},"source_text":"| join kind = rightanti ( \ncreateRoleAssignmentActivity\n| where TimeGenerated > ago(endtime)\n| extend parsed_property = tostring(parse_json(Properties).requestbody)\n| extend PrincipalId = case(parsed_property has_cs 'PrincipalId',parse_json(parsed_property).Properties.PrincipalId, parsed_property has_cs 'principalId',parse_json(parsed_property).properties.principalId,\"\")\n| extend PrincipalType = case(parsed_property has_cs 'PrincipalType',parse_json(parsed_property).Properties.PrincipalType, parsed_property has_cs 'principalType',parse_json(parsed_property).properties.principalType, \"\")\n| extend Scope = case(parsed_property has_cs 'Scope',parse_json(parsed_property).Properties.Scope, parsed_property has_cs 'scope',parse_json(parsed_property).properties.scope,\"\")\n| extend RoleAddedDetails = case(parsed_property has_cs 'RoleDefinitionId',parse_json(parsed_property).Properties.RoleDefinitionId,parsed_property has_cs 'roleDefinitionId',parse_json(parsed_property).properties.roleDefinitionId,\"\")\n| summarize StartTimeUtc = min(TimeGenerated), EndTimeUtc = max(TimeGenerated), ActivityTimeStamp = make_set(TimeGenerated), ActivityStatusValue = make_set(ActivityStatusValue), CorrelationId = make_set(CorrelationId), ActivityCountByCallerIPAddress = count() \nby ResourceId, CallerIpAddress, Caller, OperationNameValue, Resource, ResourceGroup, PrincipalId, PrincipalType, Scope, RoleAddedDetails\n) on CallerIpAddress, Caller"},"stage":5,"unit":0}
  • {"context":{"command":"extend","defs":["AccountCustomEntity","IPCustomEntity","timestamp"],"index":6,"uses":["Caller","CallerIpAddress","StartTimeUtc"]},"stage":6,"unit":0}
  • {"context":{"command":"extend","defs":["RoleAssignedID"],"index":7},"stage":7,"unit":0}
  • {"context":{"command":"join","group_by":["$left.RoleAssignedID","$right.ID"],"has_subsearch":true,"index":8,"kusto_stage":{"join_source":"AzureBuiltInRole","physical_leg":{"classification":"unresolved","leg_id":"kusto:root/stage:7/right"},"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d","unrepresented_source_calls":[{"arguments":[{"default":null,"name":"Role","node":"UdfParam","type_name":"string"},{"default":null,"name":"RoleDescription","node":"UdfParam","type_name":"string"},{"default":null,"name":"ID","node":"UdfParam","type_name":"string"}],"reason":"source_arguments_unrepresented","source_name":"externaldata"}]},"options":{"kind":"inner"}},"stage":8,"unit":0}
  • {"context":{"command":"join","filter_pred":{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">=","1209600","<=","86400"]},{"field":"count_","kind":"ge","transforms":["number"],"values":["5"]},{"children":[{"field":"OperationNameValue","kind":"eq","values":["microsoft.authorization/roleassignments/write"]},{"field":"TimeGenerated","kind":"time_range","values":[">","86400"]}],"kind":"and"}],"kind":"and"},"group_by":["Caller","CallerIpAddress"],"has_subsearch":true,"index":9,"kusto_stage":{"join_source":"CallerIPCountSummary","physical_leg":{"classification":"unresolved","leg_id":"kusto:root/stage:8/right"},"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d","unrepresented_source_calls":[{"arguments":[{"default":null,"name":"Role","node":"UdfParam","type_name":"string"},{"default":null,"name":"RoleDescription","node":"UdfParam","type_name":"string"},{"default":null,"name":"ID","node":"UdfParam","type_name":"string"}],"reason":"source_arguments_unrepresented","source_name":"externaldata"}]},"options":{"kind":"inner"}},"stage":9,"unit":0}
  • {"context":{"command":"summarize","group_by":["PrincipalId","RoleAssignedID"],"index":10,"uses":["*","StartTimeUtc"]},"stage":10,"unit":0}
  • {"context":{"command":"join","group_by":["$left.PrincipalId","$right.AccountObjectId"],"has_subsearch":true,"index":11,"kusto_stage":{"bound_physical_leg_id":"kusto:root/stage:10/right","catalog_event_pairs":[{"event_id":9035000,"provenance":"join","provider":"Defender-IdentityInfo"}],"join_resolved_source":"IdentityInfo","join_source":"IdentityInfo","physical_leg":{"classification":"telemetry","leg_id":"kusto:root/stage:10/right","table":"IdentityInfo"},"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"options":{"kind":"leftouter"},"source_text":"| join kind = leftouter( IdentityInfo\n| summarize arg_max(TimeGenerated, *) by AccountObjectId\n) on $left.PrincipalId == $right.AccountObjectId"},"stage":11,"unit":0}
  • {"context":{"command":"where","filter_pred":{"field":"AssignmentCountbyCaller","kind":"ge","transforms":["number"],"values":["5"]},"index":12,"kusto_stage":{"query_source_digest":"55a7fbbb7ccdfa9b0f57cbab0aa881777e6894e0178b7e32a8e6a15d87f76d9d"},"uses":["AssignmentCountbyCaller","alertOperationThreshold"]},"stage":12,"unit":0}
  • {"context":{"command":"project","defs":["AccountCreationTime","AccountCustomEntity","AccountUPN","ActivityStatusValue","ActivityTimeStamp","AssignmentCountbyCaller","Caller","CallerIpAddress","CorrelationId","GroupMembership","IPCustomEntity","OperationNameValue","PrincipalId","PrincipalType","ResourceGroup","Role","RoleAddedDetails","RoleAssignedID","RoleDescription","Scope","UserType","timestamp"],"index":13,"uses":["AccountCreationTime","AccountCustomEntity","AccountUPN","ActivityStatusValue","ActivityTimeStamp","AssignmentCountbyCaller","Caller","CallerIpAddress","CorrelationId","GroupMembership","IPCustomEntity","OperationNameValue","PrincipalId","PrincipalType","ResourceGroup","Role","RoleAddedDetails","RoleAssignedID","RoleDescription","Scope","UserType","timestamp"]},"stage":13,"unit":0}
  • {"context":{"command":"extend","defs":["Name","UPNSuffix"],"index":14},"stage":14,"unit":0}

Boolean scope resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:12/filter: opaque; retain partial analysis.

Boolean scope resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:2/filter: opaque; retain partial analysis.

Boolean scope resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:4/filter: opaque; retain partial analysis.

Boolean scope resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:5/filter: opaque; retain partial analysis.

Boolean scope resolved-unit-v1-167fb6368f5710b9d686bc2a1ffc3a47a50e79aef34fdecce4ddb8615f7d2e0f/stage:9/filter: opaque; retain partial analysis.

Consumer rule logic only; rule-selected role GUIDs are not role-definition authority.

Unsupported transform retained in rule context; analysis remains partial.

ambiguous_source_binding: no exact stage-local source among candidates [Azure-Microsoft.Authorization/8520038, Defender-IdentityInfo/9035000]

kusto_multi_input_lineage_unresolved: an unstamped predicate after a multi-input Kusto join has no single physical source leg

kusto_rightanti_anchor_exclusion: the retained right-anti result treats this left-anchor predicate as exclusion evidence

unsupported_selector_pattern_kind: predicate kind 'ge' has no supported registry selector pattern semantics

unsupported_selector_pattern_kind: predicate kind 'time_range' has no supported registry selector pattern semantics

Azure Privileged or Elevated Role Assignment Panther

Analysis: Partial. PANTHER consumer logic, not Azure platform authority.

Direct selector:

  • operationName eq MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[1,1,0],0]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    1, 1, 0
    DNF terms
    1, 2
    Stage
    0 panther_rule
    Transforms
    cased
Additional represented rule context
  • operationName.value is not null null optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[0,0],null]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    0, 0
    DNF terms
    0
    Stage
    0 panther_rule
  • operationName.value eq MICROSOFT.AUTHORIZATION/ELEVATEACCESS/ACTION optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[0,1,0],0]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    0, 1, 0
    DNF terms
    0
    Stage
    0 panther_rule
    Transforms
    cased
  • status.value eq Succeeded optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[0,1,1],0]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    0, 1, 1
    DNF terms
    0
    Stage
    0 panther_rule
    Transforms
    cased
  • isinstance func call operation_name, str optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[1,0],0]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    1, 0
    DNF terms
    1, 2
    Stage
    0 panther_rule
  • macro null_check optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[1,1,1,0],0]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    1, 1, 1, 0
    DNF terms
    1, 2
    Stage
    0 panther_rule
  • resultType in Success optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[1,1,1,1],0]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    1, 1, 1, 1
    DNF terms
    1
    Stage
    0 panther_rule
    Transforms
    cased
  • resultType in Succeeded optional Boolean branch
    Selector context
    Coordinate
    ["resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70",0,[1,1,1,1],1]
    Semantic scope
    resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter
    Predicate path
    1, 1, 1, 1
    DNF terms
    2
    Stage
    0 panther_rule
    Transforms
    cased
Stage, filter, grouping, or window context
  • {"metadata":{"analysis_type":"rule","dynamic_severity":[{"severity":"HIGH","when":{"field":"operationName.value","kind":"eq","transforms":["cased"],"values":["MICROSOFT.AUTHORIZATION/ELEVATEACCESS/ACTION"]}},{"severity":"HIGH","when":{"kind":"macro","values":["membership"]}},{"severity":"MEDIUM","when":{"kind":"macro","values":["membership"]}}],"example_event":{"callerIpAddress":"1.1.1.1","category":"Administrative","correlationId":"f1e2d3c4-b5a6-7890-bcde-f12345678901","identity":{"authorization":{"action":"Microsoft.Authorization/roleAssignments/write","evidence":{"principalId":"6b6d44f0-b13a-46a0-bfde-161324d4c34d","principalType":"User","role":"Owner","roleAssignmentId":"a1b2c3d4-e5f6-7890-abcd-ef1234567890","roleAssignmentScope":"/subscriptions/12345678-1234-1234-1234-123456789abc","roleDefinitionId":"8e3af657-a8ff-443c-a75c-2fe8c4bcb635"}}},"location":"","operationName":"Microsoft.Authorization/roleAssignments/write","operationVersion":"2021-04-01","properties":{"requestbody":"{\"Id\":\"a1b2c3d4-e5f6-7890-abcd-ef1234567890\",\"Properties\":{\"PrincipalId\":\"770797c4-e05a-43f9-bda2-1f1f379987ae\",\"PrincipalType\":\"ServicePrincipal\",\"RoleDefinitionId\":\"/providers/Microsoft.Authorization/roleDefinitions/8e3af657-a8ff-443c-a75c-2fe8c4bcb635\",\"Scope\":\"/subscriptions/12345678-1234-1234-1234-123456789abc\"}}"},"resourceId":"/subscriptions/12345678-1234-1234-1234-123456789abc/providers/Microsoft.Authorization/roleAssignments/a1b2c3d4-e5f6-7890-abcd-ef1234567890","resultSignature":"200","resultType":"Success","tenantId":"87654321-4321-4321-4321-111111111111","time":"2024-12-17T10:30:00.0000000Z"},"level":"medium","log_types":["Azure.MonitorActivity"],"mitre_tactics":["TA0003","TA0004","TA0005"],"mitre_techniques":["T1078.004","T1098","T1098.003"],"panther_tags":["AZT402","Persistence","Defense Evasion","Account Manipulation","Add Office 365 Global Administrator Role","Valid Accounts","Cloud Accounts"],"platform":["azure"],"reference":"https://learn.microsoft.com/en-us/azure/role-based-access-control/built-in-roles","runbook":"1. Find all Azure Monitor Activity role assignment and elevate access operations by the callerIpAddress in the 24 hours before and after the alert to identify if multiple privileged roles are being granted\n2. Query for all API calls by the principalId in the 6 hours after the role assignment to determine if newly granted permissions were immediately exploited\n3. Check if the callerIpAddress is associated with known VPN services or corporate IP ranges and compare to the caller's authentication patterns in the past 30 days","test_counts":{"negative":1,"positive":3}},"rule":{"field_usage":{"blockers":["panther: opaque helper match_role_name","panther: opaque predicate without source coordinate","panther: unsupported statement For"],"conditions":[{"blockers":["panther: opaque helper match_role_name","panther: opaque predicate without source coordinate","panther: unsupported statement For"],"category":"opaque","condition_id":"panther:rule:0","inputs":[{"authored_path":"operationName.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"operationName.value","source_table":"","transforms":[]},{"authored_path":"operationName.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"operationName.value","source_table":"","transforms":["toupper"]},{"authored_path":"status.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"status.value","source_table":"","transforms":[]},{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"operationName","source_table":"","transforms":[]},{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"operationName","source_table":"","transforms":["toupper"]},{"authored_path":"properties.requestbody","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"properties.requestbody.Properties","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"properties.requestbody.properties","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"properties.requestbody.Properties.RoleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties.RoleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"properties.requestbody.properties.RoleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties.RoleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"properties.requestbody.Properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties.roleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},{"authored_path":"resultType","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"resultType","source_table":"","transforms":["helper:azure_activity_success"]}],"operands":[{"authored_token":"operation_name_value","kind":"field","position":"lhs","predicate_path":[0,1,0],"reference":{"authored_path":"operationName.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"operationName.value","source_table":"","transforms":["toupper"]},"value":"operationName.value"},{"authored_token":"ELEVATE_ACCESS_ACTION","kind":"symbol","position":"rhs","predicate_path":[0,1,0],"reference":null,"value":"ELEVATE_ACCESS_ACTION"},{"authored_token":"event.deep_get(\"status\", \"value\")","kind":"field","position":"lhs","predicate_path":[0,1,1],"reference":{"authored_path":"status.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"status.value","source_table":"","transforms":[]},"value":"status.value"},{"authored_token":"\"Succeeded\"","kind":"literal","position":"rhs","predicate_path":[0,1,1],"reference":null,"value":"Succeeded"},{"authored_token":"operation_name","kind":"field","position":"lhs","predicate_path":[1,1,0],"reference":{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"operationName","source_table":"","transforms":["toupper"]},"value":"operationName"},{"authored_token":"ROLE_ASSIGNMENT_WRITE","kind":"symbol","position":"rhs","predicate_path":[1,1,0],"reference":null,"value":"ROLE_ASSIGNMENT_WRITE"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.Properties","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody.Properties"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.properties","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody.properties"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.Properties.RoleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties.RoleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody.Properties.RoleDefinitionId"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.properties.RoleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties.RoleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody.properties.RoleDefinitionId"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.Properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties.roleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody.Properties.roleDefinitionId"},{"authored_token":"extract_role_name(event)","kind":"field","position":"lhs","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"value":"properties.requestbody.properties.roleDefinitionId"},{"authored_token":"None","kind":"literal","position":"rhs","predicate_path":[1,1,1,0],"reference":null,"value":null}],"predecessors":[],"predicate":{"children":[{"children":[{"field":"operationName.value","kind":"is_not_null"},{"children":[{"field":"operationName.value","kind":"eq","transforms":["cased"],"values":["MICROSOFT.AUTHORIZATION/ELEVATEACCESS/ACTION"]},{"field":"status.value","kind":"eq","transforms":["cased"],"values":["Succeeded"]}],"kind":"and"}],"kind":"and"},{"children":[{"field":"isinstance","kind":"func_call","values":["operation_name, str"]},{"children":[{"field":"operationName","kind":"eq","transforms":["cased"],"values":["MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"]},{"children":[{"kind":"macro","transforms":["python_op:is not"],"values":["null_check"]},{"field":"resultType","kind":"in","transforms":["cased"],"values":["Success","Succeeded"]}],"kind":"and"}],"kind":"and"}],"kind":"and"}],"kind":"or"},"stage_index":0}],"coverage":"partial","occurrences":[{"condition_id":"panther:rule:0","dependency_path":[],"occurrence_id":"panther:rule:0:0:0","predicate_path":[0,0],"reference":{"authored_path":"operationName.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"operationName.value","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["toupper"],"occurrence_id":"panther:rule:0:1:0","predicate_path":[0,1,0],"reference":{"authored_path":"operationName.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"operationName.value","source_table":"","transforms":["toupper"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":[],"occurrence_id":"panther:rule:0:2:0","predicate_path":[0,1,1],"reference":{"authored_path":"status.value","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"status.value","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":[],"occurrence_id":"panther:rule:0:3:0","predicate_path":[1,0],"reference":{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"operationName","source_table":"","transforms":[]},"roles":["filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["toupper"],"occurrence_id":"panther:rule:0:4:0","predicate_path":[1,1,0],"reference":{"authored_path":"operationName","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"operationName","source_table":"","transforms":["toupper"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:5:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:6:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.Properties","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:7:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.properties","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:8:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.Properties.RoleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties.RoleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:9:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.properties.RoleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties.RoleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:10:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.Properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.Properties.roleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"],"occurrence_id":"panther:rule:0:11:0","predicate_path":[1,1,1,0],"reference":{"authored_path":"properties.requestbody.properties.roleDefinitionId","binding_id":"","expansion_ids":[],"origin":"nested","source_leg":"","source_path":"properties.requestbody.properties.roleDefinitionId","source_table":"","transforms":["json_decode","helper:get_role_definition_id","helper:match_role_name","helper:extract_role_name"]},"roles":["derived_filter"],"stage_index":0},{"condition_id":"panther:rule:0","dependency_path":["helper:azure_activity_success"],"occurrence_id":"panther:rule:0:12:0","predicate_path":[1,1,1,1],"reference":{"authored_path":"resultType","binding_id":"","expansion_ids":[],"origin":"source","source_leg":"","source_path":"resultType","source_table":"","transforms":["helper:azure_activity_success"]},"roles":["derived_filter"],"stage_index":0}],"source_digest":"a636a4b0d0f0a607a8576ade69ce6b8882669a0c2d95315df3e2cac31faa5fb0","version":1},"output_fields":[{"name":"name","source":"identity.claims.name"},{"name":"resourceId","source":"resourceId"}],"parse_failed":false,"stage_summary":["panther_rule"]},"unit":0,"url":"https://github.com/panther-labs/panther-analysis/blob/main/rules/azure_activity_rules/azure_role_assignment_privileged_or_elevated.yml"}
  • {"context":{"command":"panther_rule","filter_pred":{"children":[{"children":[{"field":"operationName.value","kind":"is_not_null"},{"children":[{"field":"operationName.value","kind":"eq","transforms":["cased"],"values":["MICROSOFT.AUTHORIZATION/ELEVATEACCESS/ACTION"]},{"field":"status.value","kind":"eq","transforms":["cased"],"values":["Succeeded"]}],"kind":"and"}],"kind":"and"},{"children":[{"field":"isinstance","kind":"func_call","values":["operation_name, str"]},{"children":[{"field":"operationName","kind":"eq","transforms":["cased"],"values":["MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE"]},{"children":[{"kind":"macro","values":["null_check"]},{"field":"resultType","kind":"in","transforms":["cased"],"values":["Success","Succeeded"]}],"kind":"and"}],"kind":"and"}],"kind":"and"}],"kind":"or"},"index":0,"source_text":"from panther_azureactivity_helpers import (\n add_role_assignment_fields,\n azure_activity_alert_context,\n azure_activity_success,\n azure_parse_json_string,\n get_role_definition_id,\n match_role_name,\n)\n\nROLE_ASSIGNMENT_WRITE = \"MICROSOFT.AUTHORIZATION/ROLEASSIGNMENTS/WRITE\"\nELEVATE_ACCESS_ACTION = \"MICROSOFT.AUTHORIZATION/ELEVATEACCESS/ACTION\"\n\n# Common privileged role definition IDs (subscription-level built-in roles)\nPRIVILEGED_ROLES = {\n \"8e3af657-a8ff-443c-a75c-2fe8c4bcb635\": \"Owner\",\n \"b24988ac-6180-42a0-ab88-20f7382dd24c\": \"Contributor\",\n \"18d7d88d-d35e-4fb5-a5c3-7773c20a72d9\": \"User Access Administrator\",\n \"fb1c8493-542b-48eb-b624-b4c8fea62acd\": \"Security Admin\",\n \"92b92042-07d9-4307-87f7-36a593fc5850\": \"Azure File Sync Administrator\",\n \"a8889054-8d42-49c9-bc1c-52486c10e7cd\": \"Reservations Administrator\",\n \"f58310d9-a9f6-439a-9e8d-f62e7b41a168\": \"Role Based Access Control Administrator\",\n \"150f5e0c-0603-4f03-8c7f-cf70034c4e90\": \"Data Purger\",\n}\n\nELEVATED_ROLES = {\n \"ba92f5b4-2d11-453d-a403-e96b0029c9fe\": \"Storage Blob Data Contributor\",\n \"b7e6dc6d-f1e8-4753-8033-0f276bb0955b\": \"Storage Blob Data Owner\",\n \"dffb1e0c-446f-4dde-a09f-99eb5cc68b96\": \"Azure Arc Kubernetes Admin\",\n \"a001fd3d-188f-4b5d-821b-7da978bf7442\": \"Cognitive Services OpenAI Contributor\",\n \"00482a5a-887f-4fb3-b363-3b7fe8e74483\": \"Key Vault Administrator\",\n \"8b54135c-b56d-4d72-a534-26097cfdc8d8\": \"Key Vault Data Access Administrator\",\n \"4633458b-17de-408a-b874-0445c86b69e6\": \"Key Vault Secrets User\",\n}\n\n# Combine all role mappings for lookup\nALL_ROLES = {**PRIVILEGED_ROLES, **ELEVATED_ROLES}\n\n\ndef extract_role_name(event):\n # Extract and return the role name being assigned from the event\n request_body = azure_parse_json_string(\n event.deep_get(\"properties\", \"requestbody\", default=None)\n )\n role_def_id = get_role_definition_id(request_body)\n return match_role_name(role_def_id, ALL_ROLES)\n\n\ndef rule(event):\n # For elevate access, operationName is a dict with \"value\" key\n operation_name_value = event.deep_get(\"operationName\", \"value\", default=\"\")\n if operation_name_value:\n operation_name_value = str(operation_name_value).upper()\n # Check if this is the elevate access action (subscription-level elevation)\n if (\n operation_name_value == ELEVATE_ACCESS_ACTION\n and event.deep_get(\"status\", \"value\") == \"Succeeded\"\n ):\n return True\n\n # For role assignments, operationName is a string\n operation_name = event.get(\"operationName\", \"\")\n if isinstance(operation_name, str):\n operation_name = operation_name.upper()\n # Check if this is a privileged/elevated role assignment\n if operation_name == ROLE_ASSIGNMENT_WRITE:\n return extract_role_name(event) is not None and azure_activity_success(event)\n\n return False\n\n\ndef title(event):\n operation_name_value = event.deep_get(\n \"operationName\", \"value\", default=\"<UNKNOWN_OP_VALUE>\"\n ).upper()\n\n # Handle elevate access action (subscription-level elevation)\n if operation_name_value == ELEVATE_ACCESS_ACTION:\n caller_identity = event.deep_get(\"identity\", \"claims\", \"name\", default=\"<UNKNOWN_USER>\")\n return f\"Azure subscription access elevated by [{caller_identity}]\"\n\n # Handle role assignment\n role_assignment = event.deep_get(\"resourceId\", default=\"<UNKNOWN_ASSIGNMENT>\")\n role_name = extract_role_name(event) or \"<UNKNOWN_ROLE>\"\n role_str = \"<UNKNOWN_ROLE_TYPE>\"\n if role_name in PRIVILEGED_ROLES.values():\n role_str = \"privileged\"\n if role_name in ELEVATED_ROLES.values():\n role_str = \"elevated\"\n return f\"Azure [{role_str}] role \" f\"[{role_name}] assigned on \" f\"[{role_assignment}]\"\n\n\ndef severity(event):\n operation_name_value = event.deep_get(\n \"operationName\", \"value\", default=\"<UNKNOWN_OP_VALUE>\"\n ).upper()\n\n # Elevate access action grants User Access Administrator at root scope\n if operation_name_value == ELEVATE_ACCESS_ACTION:\n return \"HIGH\"\n\n # Get the role name being assigned\n role_name = extract_role_name(event)\n\n if role_name:\n # Check if it's a privileged role\n if role_name in PRIVILEGED_ROLES.values():\n return \"HIGH\"\n # Check if it's an elevated role\n if role_name in ELEVATED_ROLES.values():\n return \"MEDIUM\"\n\n return \"DEFAULT\"\n\n\ndef alert_context(event):\n context = azure_activity_alert_context(event)\n\n # Parse and add request body fields\n request_body = azure_parse_json_string(\n event.deep_get(\"properties\", \"requestbody\", default=None)\n )\n add_role_assignment_fields(context, request_body)\n\n # Add role name\n role_name = extract_role_name(event)\n if role_name:\n context[\"role_name\"] = role_name\n\n return context\n"},"stage":0,"unit":0}

Boolean scope resolved-unit-v1-c1e03aac785089769442ee3f964f83c736b5d4a1e0644a7bd7d366a3e594eb70/stage:0/filter: opaque; retain partial analysis.

Consumer rule logic only; rule-selected role GUIDs are not role-definition authority.

Operation selector is optional in its represented Boolean branches.

unsupported_selector_pattern_kind: predicate kind 'func_call' has no supported registry selector pattern semantics

unsupported_selector_pattern_kind: predicate kind 'macro' has no supported registry selector pattern semantics

Reviewed related detections

No reviewed related detection is listed.

Analysis limitations
  • https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Azure Activity/Analytic Rules/Granting_Permissions_To_Account_detection.yaml: retained partial rule analysis.
  • https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Azure Activity/Analytic Rules/Machine_Learning_Creation.yaml: operation analysis unavailable or unsupported; no complete selector established.
  • https://github.com/panther-labs/panther-analysis/blob/main/rules/azure_activity_rules/azure_role_assignment_privileged_or_elevated.yml: retained partial rule analysis.

Research questions and evidence gaps

  • Unavailable The retained record has no request body or target role-assignment response. The recipient, granted role, grant scope and condition remain unverified; intended Reader is historical context only. [4] [1] [3]
  • Inferred The reviewed Monitor references describe a general authorization object but do not define its nested evidence fields. The Owner-versus-intended-Reader comparison supports only a caller-side interpretation of this historical context. [5] [7] [4] [1]
  • Historical context The AzureActivity reference calls Caller a GUID; the REST/portal schema allows email, UPN or SPN, and the retained Caller is email-shaped. The historical value cannot resolve a general format contract. [7] [5] [4]
  • Unavailable The v1 source registry admits no occurrence or value-presence claims for these historical samples. The embedded first-party label does not repair the missing capture provenance. [3] [4]
  • Unavailable No provenance-bearing target operation or grant-to-use chain is available. Assignment creation, continued assignment existence and later use are separate questions. [3] [4] [13]

Investigation guidance

  • Inferred Obtain independently sourced assignment request and resource evidence to identify the target principal, role-definition ID, scope and condition at the relevant time. [6] [13]
  • Inferred Separately inspect the actor's applicable assignments and their conditions, plus relevant deny assignments. Do not substitute the target role definition for the role that authorized the write. [9] [10]
  • Inferred Preserve operation identifiers, correlation, timestamps and result across the collected records. Establish any later target activity with separate evidence and a reviewed identity/time relationship. [5] [7]

Sources