schema

Microsoft Schema

graph LR
    AzureTenant -- RESOURCE --> DefenderAlert
    AzureTenant -- RESOURCE --> DefenderMachine
    AzureTenant -- RESOURCE --> EntraAppRoleAssignment
    AzureTenant -- RESOURCE --> EntraApplication
    AzureTenant -- RESOURCE --> EntraDomain
    AzureTenant -- RESOURCE --> EntraGroup
    AzureTenant -- RESOURCE --> EntraOU
    AzureTenant -- RESOURCE --> EntraRoleAssignment
    AzureTenant -- RESOURCE --> EntraRoleDefinition
    AzureTenant -- RESOURCE --> EntraServicePrincipal
    AzureTenant -- RESOURCE --> EntraUser
    AzureTenant -- RESOURCE --> IntuneCompliancePolicy
    AzureTenant -- RESOURCE --> IntuneDetectedApp
    AzureTenant -- RESOURCE --> IntuneManagedDevice
    AzureTenant -- RESOURCE --> M365License
    AzureTenant -- RESOURCE --> M365ServicePlan
    DefenderAlert -- AFFECTS --> DefenderMachine
    DefenderMachine -- ASSOCIATED_WITH --> IntuneManagedDevice
    EntraAppRoleAssignment -- ASSIGNED_TO --> EntraApplication
    EntraApplication -- SERVICE_PRINCIPAL --> EntraServicePrincipal
    EntraGroup -- HAS_APP_ROLE --> EntraAppRoleAssignment
    EntraGroup -- HAS_ROLE --> EntraRoleAssignment
    EntraGroup -- MEMBER_OF --> EntraGroup
    EntraRoleAssignment -- ASSIGNED_TO --> EntraRoleDefinition
    EntraServicePrincipal -- HAS_ROLE --> EntraRoleAssignment
    EntraUser -- ASSIGNED_LICENSE --> M365License
    EntraUser -- ENROLLED_TO --> IntuneManagedDevice
    EntraUser -- HAS_APP_ROLE --> EntraAppRoleAssignment
    EntraUser -- HAS_ROLE --> EntraRoleAssignment
    EntraUser -- IN_DOMAIN --> EntraDomain
    EntraUser -- MEMBER_OF --> EntraGroup
    EntraUser -- REPORTS_TO --> EntraUser
    IntuneCompliancePolicy -- APPLIES_TO --> IntuneManagedDevice
    IntuneCompliancePolicy -- ASSIGNED_TO --> EntraGroup
    IntuneManagedDevice -- HAS_APP --> IntuneDetectedApp
    M365License -- HAS_SERVICE_PLAN --> M365ServicePlan

AzureTenant

A Microsoft tenant, with EntraTenant retained as a compatibility label.

Ontology Mapping: This node uses the ontology label Tenant.

Additional Labels: This node also uses EntraTenant.

Additional Label Definitions:

  • EntraTenant: A microsoft node participating in the shared EntraTenant graph interface.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Microsoft tenant ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
created_date_time Timestamp when the tenant was created.
default_usage_location Default tenant usage location.
deleted_date_time Timestamp when the tenant was deleted.
display_name Display name of the tenant.
marketing_notification_emails Email addresses that receive marketing notifications.
mobile_device_management_authority Mobile device management authority for the tenant.
on_premises_last_sync_date_time Timestamp of the latest on-premises directory synchronization.
on_premises_sync_enabled Whether on-premises directory synchronization is enabled.
partner_tenant_type Partner relationship type of the tenant.
postal_code Postal code of the tenant address.
preferred_language Preferred language of the tenant.
state State or province of the tenant address.
street Street portion of the tenant address.
tenant_type Microsoft directory tenant type.
_ont_name Yes Normalized field sourced from display_name.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:AzureManagementGroup)-[:PARENT]->(:AzureTenant): A root Azure management group has the tenant as its parent.

  • (:AzureTenant)-[:RESOURCE]->(:AzureManagementGroup): An Azure tenant contains the management group as a resource.

  • (:AzureTenant)-[:RESOURCE]->(:AzurePrincipal): An Azure tenant contains the principal as a resource.

  • (:AzureTenant)-[:RESOURCE]->(:AzureSubscription): An Azure tenant contains the subscription as a resource.

  • (:AzureTenant)-[:RESOURCE]->(:DefenderAlert): Links a Microsoft tenant to a Defender alert.

  • (:AzureTenant)-[:RESOURCE]->(:DefenderMachine): Links a Microsoft tenant to a Defender for Endpoint machine.

  • (:AzureTenant)-[:RESOURCE]->(:EntraAppRoleAssignment): Links a Microsoft tenant to one of its app role assignments.

  • (:AzureTenant)-[:RESOURCE]->(:EntraApplication): Links a Microsoft tenant to one of its Entra applications.

  • (:AzureTenant)-[:RESOURCE]->(:EntraDomain): Links a Microsoft tenant to one of its domains.

  • (:AzureTenant)-[:RESOURCE]->(:EntraGroup): Links a Microsoft tenant to one of its Entra groups.

  • (:AzureTenant)-[:RESOURCE]->(:EntraOU): Links a Microsoft tenant to one of its administrative units.

  • (:AzureTenant)-[:RESOURCE]->(:EntraRoleAssignment): Links a Microsoft tenant to one of its directory role assignments.

  • (:AzureTenant)-[:RESOURCE]->(:EntraRoleDefinition): Links a Microsoft tenant to one of its directory role definitions.

  • (:AzureTenant)-[:RESOURCE]->(:EntraServicePrincipal): Links a Microsoft tenant to one of its service principals.

  • (:AzureTenant)-[:RESOURCE]->(:EntraUser): Links a Microsoft tenant to one of its Entra users.

  • (:AzureTenant)-[:RESOURCE]->(:IntuneCompliancePolicy): Links a Microsoft tenant to one of its Intune compliance policies.

  • (:AzureTenant)-[:RESOURCE]->(:IntuneDetectedApp): Links a Microsoft tenant to a detected Intune application.

  • (:AzureTenant)-[:RESOURCE]->(:IntuneManagedDevice): Links a Microsoft tenant to one of its Intune managed devices.

  • (:AzureTenant)-[:RESOURCE]->(:M365License): Links a Microsoft tenant to one of its Microsoft 365 licenses.

  • (:AzureTenant)-[:RESOURCE]->(:M365ServicePlan): Links a Microsoft tenant to one of its Microsoft 365 service plans.

DefenderAlert

An unresolved Defender for Endpoint alert returned by Microsoft Graph security alerts v2.

Ontology Mapping: The SecurityIssue label enables cross-provider security issue queries with normalized title, severity, status, type, and first-seen values. Unknown severity and status values stay unmapped.

Ontology Mapping: This node uses the ontology label SecurityIssue.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Tenant ID and Graph alert ID, separated by a slash.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
alert_id Microsoft Graph security alert ID.
alert_web_url Alert URL in the Microsoft Defender portal.
category MITRE ATT&CK category of the suspicious activity.
classification Analyst classification of the alert.
created_date_time Native datetime from createdDateTime: when the alert was created.
detection_source Detection source that produced the alert.
determination Analyst determination of the alert.
incident_id Incident ID associated with the alert.
last_update_date_time Native datetime from lastUpdateDateTime: when the alert was last updated.
mitre_techniques MITRE ATT&CK techniques identified in the alert.
provider_alert_id Alert ID assigned by Defender for Endpoint.
service_source Microsoft Defender service that produced the alert.
severity Alert severity reported by Microsoft Graph.
status Alert status; only unresolved alerts are ingested.
tenant_id Microsoft tenant ID.
threat_family_name Threat family identified in the alert.
title Alert title.
_ont_first_seen Yes Normalized field sourced from created_date_time.
_ont_severity Yes Normalized field sourced from severity.
_ont_source Module that populated this node's ontology fields.
_ont_status Yes Normalized field sourced from status.
_ont_title Yes Normalized field sourced from title.
_ont_type Yes Normalized field sourced from detection_source.

Relationships

  • (:DefenderAlert)-[:AFFECTS]->(:DefenderMachine): Links an alert to each Defender machine identified in its device evidence.

Machines outside the inventory's retention period aren't created as placeholders.

  • (:AzureTenant)-[:RESOURCE]->(:DefenderAlert): Links a Microsoft tenant to a Defender alert.

DefenderMachine

A machine observed by Microsoft Defender for Endpoint within the tenant's retention period.

Presence in the inventory doesn't prove the endpoint is protected; see onboarding_status. The API provides no hardware serial number, so machines don't create canonical Device nodes; canonical devices are reachable through the linked IntuneManagedDevice.

Properties

Field Index Description
id Yes Tenant ID and Defender machine ID, separated by a slash.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
aad_device_id Yes Microsoft Entra device ID, when available.
aad_device_id_normalized Yes Lowercase aadDeviceId used for inventory joins; empty and all-zero IDs are excluded.
computer_dns_name Yes Fully qualified DNS name of the machine.
exposure_level Defender exposure level.
first_seen Native datetime from firstSeen: when Defender first observed the machine.
health_status Defender sensor health status.
is_aad_joined Whether the machine is joined to Microsoft Entra ID.
last_external_ip_address Last external IP address reported by the machine.
last_ip_address Last internal IP address reported by the machine.
last_seen Native datetime from lastSeen: when Defender last received a full device report (typically every 24 hours); not the portal's last-seen timestamp.
machine_id Machine ID assigned by Defender for Endpoint.
machine_tags Tags assigned to the machine.
onboarding_status Defender onboarding status; inventory presence alone does not imply protection.
os_build Operating system build number.
os_platform Operating system platform reported by Defender.
os_version Operating system version reported by Defender.
rbac_group_id Defender device group ID.
rbac_group_name Defender device group name.
risk_score Defender device risk score.
tenant_id Microsoft tenant ID.

Relationships

  • (:DefenderAlert)-[:AFFECTS]->(:DefenderMachine): Links an alert to each Defender machine identified in its device evidence.

Machines outside the inventory's retention period aren't created as placeholders.

  • (:DefenderMachine)-[:ASSOCIATED_WITH]->(:IntuneManagedDevice): Matches Defender and Intune inventory by Entra device ID within the same tenant.

Both producers write the same lowercase key; empty and all-zero device IDs never link. Entra users are reachable through the Intune enrollment.

  • (:AzureTenant)-[:RESOURCE]->(:DefenderMachine): Links a Microsoft tenant to a Defender for Endpoint machine.

EntraApplication

An application registration in Microsoft Entra ID.

Ontology Mapping: This node uses the ontology label ThirdPartyApp.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Entra application object ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
_ont_enabled Property generated by analysis job: Ontology - Entra application projection.
app_id Application client ID.
display_name Display name of the application.
publisher_domain Verified publisher domain of the application.
sign_in_audience Accounts allowed to sign in to the application.
_ont_client_id Yes Normalized field sourced from app_id.
_ont_name Yes Normalized field sourced from display_name.
_ont_protocol Yes Property generated by the ontology mapping.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:EntraAppRoleAssignment)-[:ASSIGNED_TO]->(:EntraApplication): Links an app role assignment to its Entra application.

  • (:User)-[:AUTHORIZED]->(:EntraApplication): generated by analysis job Ontology - User AUTHORIZED ThirdPartyApp linking.

    • Properties:

      Field Description
      scopes Property generated by analysis job: Ontology - User AUTHORIZED ThirdPartyApp linking.
  • (:AzureTenant)-[:RESOURCE]->(:EntraApplication): Links a Microsoft tenant to one of its Entra applications.

  • (:EntraApplication)-[:SERVICE_PRINCIPAL]->(:EntraServicePrincipal): Links an Entra application to its deployed service principal.

EntraAppRoleAssignment

An application role assignment in Microsoft Entra ID.

Properties

Field Index Description
id Yes Entra app role assignment ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
app_role_id ID of the assigned application role.
application_app_id Client ID of the assigned application.
created_date_time Timestamp when the assignment was created.
principal_display_name Display name of the assigned principal.
principal_id ID of the principal receiving the role.
principal_type Type of the assigned principal.
resource_display_name Display name of the resource service principal.
resource_id ID of the resource service principal.

Relationships

  • (:EntraAppRoleAssignment)-[:ASSIGNED_TO]->(:EntraApplication): Links an app role assignment to its Entra application.

  • (:EntraGroup)-[:HAS_APP_ROLE]->(:EntraAppRoleAssignment): Links an Entra group to an app role assignment it holds.

  • (:EntraUser)-[:HAS_APP_ROLE]->(:EntraAppRoleAssignment): Links an Entra user to an app role assignment they hold.

  • (:AzureTenant)-[:RESOURCE]->(:EntraAppRoleAssignment): Links a Microsoft tenant to one of its app role assignments.

EntraDomain

A domain name added to a Microsoft Entra tenant.

Properties

Field Index Description
id Yes Tenant ID and lowercase domain name, joined by a slash.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
authentication_type Managed when Entra ID authenticates the domain's users, Federated when an external identity provider such as AD FS or Okta does.
is_admin_managed False when DNS record management for the domain is delegated to Microsoft 365, true otherwise.
is_default Whether the domain is the tenant's default for new users.
is_initial Whether the domain is the onmicrosoft.com domain Microsoft created with the tenant.
is_root Whether the domain is a verified root domain. False for a subdomain or an unverified domain.
is_verified Whether the tenant has proven ownership of the domain.
name Yes Lowercase fully qualified domain name.
supported_services Services the domain is configured for, such as Email or OfficeCommunicationsOnline.
tenant_id ID of the Entra tenant the domain belongs to.

Relationships

  • (:EntraUser)-[:IN_DOMAIN]->(:EntraDomain): Links an Entra user to the tenant domain of its user principal name.

The domain's authentication type says whether Entra ID or an external identity provider signs the user in.

  • (:AzureTenant)-[:RESOURCE]->(:EntraDomain): Links a Microsoft tenant to one of its domains.

EntraGroup

A group in Microsoft Entra ID.

Ontology Mapping: This node uses the ontology label UserGroup.

Additional Labels: This node also uses EntraIdentity, EntraPrincipal.

Additional Label Definitions:

  • EntraIdentity: A microsoft node participating in the shared EntraIdentity graph interface.
  • EntraPrincipal: A Microsoft identity participating in the shared EntraPrincipal graph interface.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Entra group ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
created_date_time Timestamp when the group was created.
deleted_date_time Timestamp when the group was deleted.
description Description of the group.
display_name Display name of the group.
group_types Microsoft Graph group type values.
is_assignable_to_role Whether directory roles can be assigned to the group.
mail Primary email address of the group.
mail_enabled Whether the group has mail enabled.
mail_nickname Mail alias of the group.
membership_rule Rule that sets the members of a dynamic group, e.g. user.department -eq "Sales". Null for assigned groups.
membership_rule_processing_state Whether the dynamic membership rule is applied: On or Paused.
security_enabled Whether the group has security enabled.
visibility Visibility setting of the group.
_ont_description Normalized field sourced from description.
_ont_email Yes Normalized field sourced from mail.
_ont_name Yes Normalized field sourced from display_name.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:IntuneCompliancePolicy)-[:ASSIGNED_TO]->(:EntraGroup): Links an Intune compliance policy to an assigned Entra group.

  • (:EntraGroup)-[:CAN_ADMINISTER]->(:AzureKeyVault): EntraGroup receives evaluated CAN_ADMINISTER access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: Microsoft.KeyVault/vaults/accessPolicies/write, Microsoft.KeyVault/vaults/write
  • (:EntraGroup)-[:CAN_ADMINISTER]->(:AzureKubernetesCluster): EntraGroup receives evaluated CAN_ADMINISTER access to AzureKubernetesCluster from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerService/managedClusters/listClusterAdminCredential/action
  • (:EntraGroup)-[:CAN_DECRYPT]->(:AzureKeyVault): EntraGroup receives evaluated CAN_DECRYPT access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/keys/decrypt/action, Microsoft.KeyVault/vaults/keys/unwrap/action
  • (:EntraGroup)-[:CAN_DELETE]->(:AzureCosmosDBAccount): EntraGroup receives evaluated CAN_DELETE access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/delete
  • (:EntraGroup)-[:CAN_DELETE]->(:AzureStorageAccount): EntraGroup receives evaluated CAN_DELETE access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/delete, Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/delete, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/delete, Microsoft.Storage/storageAccounts/queueServices/queues/messages/delete, Microsoft.Storage/storageAccounts/tableServices/tables/entities/delete
  • (:EntraGroup)-[:CAN_EXEC]->(:AzureAppService): EntraGroup receives evaluated CAN_EXEC access to AzureAppService from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Web/sites/extensions/write, Microsoft.Web/sites/publishxml/action, Microsoft.Web/sites/write
  • (:EntraGroup)-[:CAN_EXEC]->(:AzureFunctionApp): EntraGroup receives evaluated CAN_EXEC access to AzureFunctionApp from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Web/sites/extensions/write, Microsoft.Web/sites/publishxml/action, Microsoft.Web/sites/write
  • (:EntraGroup)-[:CAN_EXEC]->(:AzureGroupContainer): EntraGroup receives evaluated CAN_EXEC access to AzureGroupContainer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerInstance/containerGroups/containers/exec/action
  • (:EntraGroup)-[:CAN_EXEC]->(:AzureKubernetesCluster): EntraGroup receives evaluated CAN_EXEC access to AzureKubernetesCluster from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerService/managedClusters/runCommand/action
  • (:EntraGroup)-[:CAN_EXEC]->(:AzureVirtualMachine): EntraGroup receives evaluated CAN_EXEC access to AzureVirtualMachine from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Compute/virtualMachines/extensions/write, Microsoft.Compute/virtualMachines/runCommand/action, Microsoft.Compute/virtualMachines/runCommands/write
  • (:EntraGroup)-[:CAN_LOGIN]->(:AzureVirtualMachine): EntraGroup receives evaluated CAN_LOGIN access to AzureVirtualMachine from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.Compute/virtualMachines/login/action, Microsoft.Compute/virtualMachines/loginAsAdmin/action
  • (:EntraGroup)-[:CAN_MANAGE]->(:AzureSQLServer): EntraGroup receives evaluated CAN_MANAGE access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/delete
  • (:EntraGroup)-[:CAN_READ]->(:AzureCosmosDBAccount): EntraGroup receives evaluated CAN_READ access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/listConnectionStrings/action, Microsoft.DocumentDB/databaseAccounts/listKeys/action, Microsoft.DocumentDB/databaseAccounts/readonlykeys/action
  • (:EntraGroup)-[:CAN_READ]->(:AzureKeyVault): EntraGroup receives evaluated CAN_READ access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/secrets/getSecret/action
  • (:EntraGroup)-[:CAN_READ]->(:AzureSQLServer): EntraGroup receives evaluated CAN_READ access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/read
  • (:EntraGroup)-[:CAN_READ]->(:AzureStorageAccount): EntraGroup receives evaluated CAN_READ access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/read, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/read, Microsoft.Storage/storageAccounts/queueServices/queues/messages/read, Microsoft.Storage/storageAccounts/tableServices/tables/entities/read
  • (:EntraGroup)-[:CAN_WRITE]->(:AzureCosmosDBAccount): EntraGroup receives evaluated CAN_WRITE access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/listConnectionStrings/action, Microsoft.DocumentDB/databaseAccounts/listKeys/action
  • (:EntraGroup)-[:CAN_WRITE]->(:AzureKeyVault): EntraGroup receives evaluated CAN_WRITE access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/secrets/setSecret/action
  • (:EntraGroup)-[:CAN_WRITE]->(:AzureSQLServer): EntraGroup receives evaluated CAN_WRITE access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/write
  • (:EntraGroup)-[:CAN_WRITE]->(:AzureStorageAccount): EntraGroup receives evaluated CAN_WRITE access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/add/action, Microsoft.Storage/storageAccounts/blobServices/containers/blobs/write, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/write, Microsoft.Storage/storageAccounts/queueServices/queues/messages/add/action, Microsoft.Storage/storageAccounts/queueServices/queues/messages/write, Microsoft.Storage/storageAccounts/tableServices/tables/entities/add/action, Microsoft.Storage/storageAccounts/tableServices/tables/entities/update/action, Microsoft.Storage/storageAccounts/tableServices/tables/entities/write
  • (:EntraGroup)-[:HAS_APP_ROLE]->(:EntraAppRoleAssignment): Links an Entra group to an app role assignment it holds.

  • (:EntraGroup)-[:HAS_ROLE]->(:EntraRoleAssignment): Links an Entra group to a directory role assignment it holds.

  • (:EntraGroup)-[:HAS_ROLE_ASSIGNMENT]->(:AzureRoleAssignment): A Microsoft Entra group has the Azure role assignment.

  • (:EntraGroup)-[:MEMBER_OF]->(:EntraGroup): Links nested Entra groups to their parent group.

  • (:EntraUser)-[:MEMBER_OF]->(:EntraGroup): Links Entra users to a group they belong to.

  • (:EntraIdentity)-[:OWNER_OF]->(:EntraGroup): Links Entra identities to a group they own.

  • (:AzureTenant)-[:RESOURCE]->(:EntraGroup): Links a Microsoft tenant to one of its Entra groups.

EntraOU

An administrative unit in Microsoft Entra ID.

Properties

Field Index Description
id Yes Entra administrative unit ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
deleted_date_time Timestamp when the administrative unit was deleted.
description Description of the administrative unit.
display_name Display name of the administrative unit.
is_member_management_restricted Whether member management is restricted.
membership_type Membership type of the administrative unit.
visibility Visibility setting of the administrative unit.

Relationships

  • (:AzureTenant)-[:RESOURCE]->(:EntraOU): Links a Microsoft tenant to one of its administrative units.

EntraRoleAssignment

A directory role assignment in Microsoft Entra ID.

Properties

Field Index Description
id Yes Entra role assignment ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
app_scope_id Application-specific scope of the assignment.
directory_scope_id Directory scope of the assignment.
principal_id Yes ID of the principal granted the role.
role_definition_id Yes ID of the assigned role definition.

Relationships

  • (:EntraRoleAssignment)-[:ASSIGNED_TO]->(:EntraRoleDefinition): Links a role assignment to the directory role it grants.

  • (:EntraGroup)-[:HAS_ROLE]->(:EntraRoleAssignment): Links an Entra group to a directory role assignment it holds.

  • (:EntraServicePrincipal)-[:HAS_ROLE]->(:EntraRoleAssignment): Links a service principal to a directory role assignment it holds.

  • (:EntraUser)-[:HAS_ROLE]->(:EntraRoleAssignment): Links an Entra user to a directory role assignment they hold.

  • (:AzureTenant)-[:RESOURCE]->(:EntraRoleAssignment): Links a Microsoft tenant to one of its directory role assignments.

EntraRoleDefinition

A directory role definition in Microsoft Entra ID.

Properties

Field Index Description
id Yes Entra role definition ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
description Description of the permissions granted by the role.
display_name Display name of the directory role.
is_built_in Whether this is a Microsoft built-in role.
is_enabled Whether the role definition is enabled.
template_id Template ID of the directory role.

Relationships

  • (:EntraRoleAssignment)-[:ASSIGNED_TO]->(:EntraRoleDefinition): Links a role assignment to the directory role it grants.

  • (:AzureTenant)-[:RESOURCE]->(:EntraRoleDefinition): Links a Microsoft tenant to one of its directory role definitions.

EntraServicePrincipal

A service principal in Microsoft Entra ID.

Ontology Mapping: This node uses the ontology label ServiceAccount.

Additional Labels: This node also uses EntraPrincipal.

Additional Label Definitions:

  • EntraPrincipal: A Microsoft identity participating in the shared EntraPrincipal graph interface.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Entra service principal ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
account_enabled Whether the service principal is enabled.
app_id Client ID of the associated application.
app_owner_organization_id Tenant ID of the application's owning organization.
aws_identity_center_instance_id AWS Identity Center instance ID derived from reply URLs.
display_name Display name of the service principal.
login_url Login URL of the service principal.
preferred_single_sign_on_mode Preferred single sign-on mode.
preferred_token_signing_key_thumbprint Thumbprint of the preferred token-signing certificate.
reply_urls Reply URLs registered for the service principal.
risk_available Whether the latest sync could read the riskyServicePrincipals report. When false, the risk properties are null because Graph denied access, not because the service principal carries no risk.
risk_detail Reason for the latest risk state change, such as adminConfirmedServicePrincipalCompromised. Null when unknown.
risk_last_updated_date_time UTC datetime the risk state last changed. Null when unknown.
risk_level Yes Entra ID Protection workload identity risk level, such as low, medium, high, hidden, or none. Null when the service principal is not in the riskyServicePrincipals report, or when that report is unavailable (it requires Workload Identities Premium).
risk_state Entra ID Protection risk state, such as atRisk, confirmedCompromised, remediated, or dismissed. Null when unknown.
service_principal_type Type of service principal.
sign_in_audience Accounts allowed to sign in.
tags Tags assigned to the service principal.
token_encryption_key_id Key ID used to encrypt issued tokens.
_ont_active Yes Normalized field sourced from account_enabled.
_ont_name Yes Normalized field sourced from display_name.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:EntraServicePrincipal)-[:CAN_ADMINISTER]->(:AzureKeyVault): EntraServicePrincipal receives evaluated CAN_ADMINISTER access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: Microsoft.KeyVault/vaults/accessPolicies/write, Microsoft.KeyVault/vaults/write
  • (:EntraServicePrincipal)-[:CAN_ADMINISTER]->(:AzureKubernetesCluster): EntraServicePrincipal receives evaluated CAN_ADMINISTER access to AzureKubernetesCluster from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerService/managedClusters/listClusterAdminCredential/action
  • (:EntraServicePrincipal)-[:CAN_DECRYPT]->(:AzureKeyVault): EntraServicePrincipal receives evaluated CAN_DECRYPT access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/keys/decrypt/action, Microsoft.KeyVault/vaults/keys/unwrap/action
  • (:EntraServicePrincipal)-[:CAN_DELETE]->(:AzureCosmosDBAccount): EntraServicePrincipal receives evaluated CAN_DELETE access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/delete
  • (:EntraServicePrincipal)-[:CAN_DELETE]->(:AzureStorageAccount): EntraServicePrincipal receives evaluated CAN_DELETE access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/delete, Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/delete, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/delete, Microsoft.Storage/storageAccounts/queueServices/queues/messages/delete, Microsoft.Storage/storageAccounts/tableServices/tables/entities/delete
  • (:EntraServicePrincipal)-[:CAN_EXEC]->(:AzureAppService): EntraServicePrincipal receives evaluated CAN_EXEC access to AzureAppService from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Web/sites/extensions/write, Microsoft.Web/sites/publishxml/action, Microsoft.Web/sites/write
  • (:EntraServicePrincipal)-[:CAN_EXEC]->(:AzureFunctionApp): EntraServicePrincipal receives evaluated CAN_EXEC access to AzureFunctionApp from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Web/sites/extensions/write, Microsoft.Web/sites/publishxml/action, Microsoft.Web/sites/write
  • (:EntraServicePrincipal)-[:CAN_EXEC]->(:AzureGroupContainer): EntraServicePrincipal receives evaluated CAN_EXEC access to AzureGroupContainer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerInstance/containerGroups/containers/exec/action
  • (:EntraServicePrincipal)-[:CAN_EXEC]->(:AzureKubernetesCluster): EntraServicePrincipal receives evaluated CAN_EXEC access to AzureKubernetesCluster from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerService/managedClusters/runCommand/action
  • (:EntraServicePrincipal)-[:CAN_EXEC]->(:AzureVirtualMachine): EntraServicePrincipal receives evaluated CAN_EXEC access to AzureVirtualMachine from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Compute/virtualMachines/extensions/write, Microsoft.Compute/virtualMachines/runCommand/action, Microsoft.Compute/virtualMachines/runCommands/write
  • (:EntraServicePrincipal)-[:CAN_LOGIN]->(:AzureVirtualMachine): EntraServicePrincipal receives evaluated CAN_LOGIN access to AzureVirtualMachine from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.Compute/virtualMachines/login/action, Microsoft.Compute/virtualMachines/loginAsAdmin/action
  • (:EntraServicePrincipal)-[:CAN_MANAGE]->(:AzureSQLServer): EntraServicePrincipal receives evaluated CAN_MANAGE access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/delete
  • (:EntraServicePrincipal)-[:CAN_READ]->(:AzureCosmosDBAccount): EntraServicePrincipal receives evaluated CAN_READ access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/listConnectionStrings/action, Microsoft.DocumentDB/databaseAccounts/listKeys/action, Microsoft.DocumentDB/databaseAccounts/readonlykeys/action
  • (:EntraServicePrincipal)-[:CAN_READ]->(:AzureKeyVault): EntraServicePrincipal receives evaluated CAN_READ access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/secrets/getSecret/action
  • (:EntraServicePrincipal)-[:CAN_READ]->(:AzureSQLServer): EntraServicePrincipal receives evaluated CAN_READ access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/read
  • (:EntraServicePrincipal)-[:CAN_READ]->(:AzureStorageAccount): EntraServicePrincipal receives evaluated CAN_READ access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/read, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/read, Microsoft.Storage/storageAccounts/queueServices/queues/messages/read, Microsoft.Storage/storageAccounts/tableServices/tables/entities/read
  • (:EntraServicePrincipal)-[:CAN_WRITE]->(:AzureCosmosDBAccount): EntraServicePrincipal receives evaluated CAN_WRITE access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/listConnectionStrings/action, Microsoft.DocumentDB/databaseAccounts/listKeys/action
  • (:EntraServicePrincipal)-[:CAN_WRITE]->(:AzureKeyVault): EntraServicePrincipal receives evaluated CAN_WRITE access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/secrets/setSecret/action
  • (:EntraServicePrincipal)-[:CAN_WRITE]->(:AzureSQLServer): EntraServicePrincipal receives evaluated CAN_WRITE access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/write
  • (:EntraServicePrincipal)-[:CAN_WRITE]->(:AzureStorageAccount): EntraServicePrincipal receives evaluated CAN_WRITE access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/add/action, Microsoft.Storage/storageAccounts/blobServices/containers/blobs/write, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/write, Microsoft.Storage/storageAccounts/queueServices/queues/messages/add/action, Microsoft.Storage/storageAccounts/queueServices/queues/messages/write, Microsoft.Storage/storageAccounts/tableServices/tables/entities/add/action, Microsoft.Storage/storageAccounts/tableServices/tables/entities/update/action, Microsoft.Storage/storageAccounts/tableServices/tables/entities/write
  • (:GCPBigQueryConnection)-[:CONNECTS_WITH]->(:EntraServicePrincipal)

  • (:EntraServicePrincipal)-[:FEDERATES_TO]->(:AWSIdentityCenter): Links an Entra service principal to its federated AWS Identity Center.

  • (:EntraServicePrincipal)-[:HAS_ROLE]->(:EntraRoleAssignment): Links a service principal to a directory role assignment it holds.

  • (:EntraServicePrincipal)-[:HAS_ROLE_ASSIGNMENT]->(:AzureRoleAssignment): A Microsoft Entra service principal has the Azure role assignment.

  • (:AzureTenant)-[:RESOURCE]->(:EntraServicePrincipal): Links a Microsoft tenant to one of its service principals.

  • (:AzureFunctionApp)-[:RUNS_AS]->(:EntraServicePrincipal): An Azure Function App runs as one of its managed identities.

  • (:AzureVirtualMachine)-[:RUNS_AS]->(:EntraServicePrincipal): The virtual machine runs as a managed identity's service principal.

  • (:EntraApplication)-[:SERVICE_PRINCIPAL]->(:EntraServicePrincipal): Links an Entra application to its deployed service principal.

EntraUser

A user account in Microsoft Entra ID.

Ontology Mapping: This node uses the ontology label UserAccount.

Additional Labels: This node also uses EntraIdentity, EntraPrincipal.

Additional Label Definitions:

  • EntraIdentity: A microsoft node participating in the shared EntraIdentity graph interface.
  • EntraPrincipal: A Microsoft identity participating in the shared EntraPrincipal graph interface.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Entra user ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
account_enabled Whether the user account is enabled.
age_group Age group classification of the user.
business_phones Business phone numbers of the user.
city City in the user's address.
company_name Company name associated with the user.
country Country or region in the user's address.
department Department of the user.
display_name Display name of the user.
email Yes Primary email address of the user.
employee_id Employee identifier of the user.
employee_type Employment type of the user.
external_user_state Invitation state of an external user, such as PendingAcceptance or Accepted. Null for users that were not invited.
given_name Given name of the user.
is_mfa_capable Whether the user has registered a strong authentication method that the authentication methods policy allows for MFA. Null when unknown.
is_mfa_registered Whether the user has registered a strong authentication method for MFA. Null when unknown.
job_title Job title of the user.
last_non_interactive_sign_in_date_time Yes UTC datetime from signInActivity.lastNonInteractiveSignInDateTime: last non-interactive sign-in attempt, including failures. Null means unknown.
last_sign_in_date_time Yes UTC datetime from signInActivity.lastSignInDateTime: last interactive sign-in attempt, including failures. Null means unknown.
last_successful_sign_in_date_time Yes UTC datetime from signInActivity.lastSuccessfulSignInDateTime: last successful interactive or non-interactive sign-in. Not backfilled before December 2023. Null when activity was unavailable, or when Graph has no recorded successful sign-in for the user.
manager_id Entra user ID of the user's manager.
mfa_methods_registered Authentication methods the user has registered, such as microsoftAuthenticatorPush or fido2. Null when unknown.
mfa_registration_available Whether the latest sync could read the userRegistrationDetails report. When false, the MFA properties are null because Graph denied access, not because the user has no MFA.
mobile_phone Mobile phone number of the user.
office_location Office location of the user.
preferred_language Preferred language of the user.
risk_available Whether the latest sync could read the riskyUsers report. When false, the risk properties are null because Graph denied access, not because the user carries no risk.
risk_detail Reason for the latest risk state change, such as adminConfirmedUserCompromised. Null when unknown.
risk_last_updated_date_time UTC datetime the risk state last changed. Null when unknown.
risk_level Yes Entra ID Protection user risk level, such as low, medium, high, hidden, or none. Null when the user is not in the riskyUsers report, or when that report is unavailable (it requires Entra ID P2).
risk_state Entra ID Protection risk state, such as atRisk, confirmedCompromised, remediated, or dismissed. Null when unknown.
sign_in_activity_available Whether the latest user inventory request could read signInActivity. When false, sign-in timestamps are null because Graph denied access, not because the user never signed in.
state State or province in the user's address.
surname Surname of the user.
user_principal_name User principal name.
user_type Graph userType: Member for internal users or Guest for external (B2B) users.
_ont_active Yes Normalized field sourced from account_enabled.
_ont_email Yes Normalized field sourced from email.
_ont_firstname Yes Normalized field sourced from given_name.
_ont_fullname Yes Normalized field sourced from display_name.
_ont_lastactivity Yes Normalized field sourced from last_successful_sign_in_date_time.
_ont_lastname Yes Normalized field sourced from surname.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:EntraUser)-[:ASSIGNED_LICENSE]->(:M365License): Links an Entra user to a Microsoft 365 license assigned to them.

  • (:EntraUser)-[:CAN_ADMINISTER]->(:AzureKeyVault): EntraUser receives evaluated CAN_ADMINISTER access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: Microsoft.KeyVault/vaults/accessPolicies/write, Microsoft.KeyVault/vaults/write
  • (:EntraUser)-[:CAN_ADMINISTER]->(:AzureKubernetesCluster): EntraUser receives evaluated CAN_ADMINISTER access to AzureKubernetesCluster from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerService/managedClusters/listClusterAdminCredential/action
  • (:EntraUser)-[:CAN_DECRYPT]->(:AzureKeyVault): EntraUser receives evaluated CAN_DECRYPT access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/keys/decrypt/action, Microsoft.KeyVault/vaults/keys/unwrap/action
  • (:EntraUser)-[:CAN_DELETE]->(:AzureCosmosDBAccount): EntraUser receives evaluated CAN_DELETE access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/delete
  • (:EntraUser)-[:CAN_DELETE]->(:AzureStorageAccount): EntraUser receives evaluated CAN_DELETE access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/delete, Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/delete, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/delete, Microsoft.Storage/storageAccounts/queueServices/queues/messages/delete, Microsoft.Storage/storageAccounts/tableServices/tables/entities/delete
  • (:EntraUser)-[:CAN_EXEC]->(:AzureAppService): EntraUser receives evaluated CAN_EXEC access to AzureAppService from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Web/sites/extensions/write, Microsoft.Web/sites/publishxml/action, Microsoft.Web/sites/write
  • (:EntraUser)-[:CAN_EXEC]->(:AzureFunctionApp): EntraUser receives evaluated CAN_EXEC access to AzureFunctionApp from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Web/sites/extensions/write, Microsoft.Web/sites/publishxml/action, Microsoft.Web/sites/write
  • (:EntraUser)-[:CAN_EXEC]->(:AzureGroupContainer): EntraUser receives evaluated CAN_EXEC access to AzureGroupContainer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerInstance/containerGroups/containers/exec/action
  • (:EntraUser)-[:CAN_EXEC]->(:AzureKubernetesCluster): EntraUser receives evaluated CAN_EXEC access to AzureKubernetesCluster from AZURE IAM policies.

    • Evaluated permissions: Microsoft.ContainerService/managedClusters/runCommand/action
  • (:EntraUser)-[:CAN_EXEC]->(:AzureVirtualMachine): EntraUser receives evaluated CAN_EXEC access to AzureVirtualMachine from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Compute/virtualMachines/extensions/write, Microsoft.Compute/virtualMachines/runCommand/action, Microsoft.Compute/virtualMachines/runCommands/write
  • (:EntraUser)-[:CAN_LOGIN]->(:AzureVirtualMachine): EntraUser receives evaluated CAN_LOGIN access to AzureVirtualMachine from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.Compute/virtualMachines/login/action, Microsoft.Compute/virtualMachines/loginAsAdmin/action
  • (:EntraUser)-[:CAN_MANAGE]->(:AzureSQLServer): EntraUser receives evaluated CAN_MANAGE access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/delete
  • (:EntraUser)-[:CAN_READ]->(:AzureCosmosDBAccount): EntraUser receives evaluated CAN_READ access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/listConnectionStrings/action, Microsoft.DocumentDB/databaseAccounts/listKeys/action, Microsoft.DocumentDB/databaseAccounts/readonlykeys/action
  • (:EntraUser)-[:CAN_READ]->(:AzureKeyVault): EntraUser receives evaluated CAN_READ access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/secrets/getSecret/action
  • (:EntraUser)-[:CAN_READ]->(:AzureSQLServer): EntraUser receives evaluated CAN_READ access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/read
  • (:EntraUser)-[:CAN_READ]->(:AzureStorageAccount): EntraUser receives evaluated CAN_READ access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/read, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/read, Microsoft.Storage/storageAccounts/queueServices/queues/messages/read, Microsoft.Storage/storageAccounts/tableServices/tables/entities/read
  • (:EntraUser)-[:CAN_SIGN_ON_TO]->(:AWSSSOUser): Links an Entra user to their federated AWS Identity Center user.

  • (:EntraUser)-[:CAN_WRITE]->(:AzureCosmosDBAccount): EntraUser receives evaluated CAN_WRITE access to AzureCosmosDBAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.DocumentDB/databaseAccounts/listConnectionStrings/action, Microsoft.DocumentDB/databaseAccounts/listKeys/action
  • (:EntraUser)-[:CAN_WRITE]->(:AzureKeyVault): EntraUser receives evaluated CAN_WRITE access to AzureKeyVault from AZURE IAM policies.

    • Evaluated permissions: data plane only: Microsoft.KeyVault/vaults/secrets/setSecret/action
  • (:EntraUser)-[:CAN_WRITE]->(:AzureSQLServer): EntraUser receives evaluated CAN_WRITE access to AzureSQLServer from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Sql/servers/write
  • (:EntraUser)-[:CAN_WRITE]->(:AzureStorageAccount): EntraUser receives evaluated CAN_WRITE access to AzureStorageAccount from AZURE IAM policies.

    • Evaluated permissions: Microsoft.Storage/storageAccounts/listKeys/action; data plane only: Microsoft.Storage/storageAccounts/blobServices/containers/blobs/add/action, Microsoft.Storage/storageAccounts/blobServices/containers/blobs/write, Microsoft.Storage/storageAccounts/fileServices/fileshares/files/write, Microsoft.Storage/storageAccounts/queueServices/queues/messages/add/action, Microsoft.Storage/storageAccounts/queueServices/queues/messages/write, Microsoft.Storage/storageAccounts/tableServices/tables/entities/add/action, Microsoft.Storage/storageAccounts/tableServices/tables/entities/update/action, Microsoft.Storage/storageAccounts/tableServices/tables/entities/write
  • (:EntraUser)-[:ENROLLED_TO]->(:IntuneManagedDevice): Links an Entra user to a device they enrolled in Intune.

  • (:User)-[:HAS_ACCOUNT]->(:EntraUser)

  • (:EntraUser)-[:HAS_APP_ROLE]->(:EntraAppRoleAssignment): Links an Entra user to an app role assignment they hold.

  • (:EntraUser)-[:HAS_ROLE]->(:EntraRoleAssignment): Links an Entra user to a directory role assignment they hold.

  • (:EntraUser)-[:HAS_ROLE_ASSIGNMENT]->(:AzureRoleAssignment): A Microsoft Entra user has the Azure role assignment.

  • (:EntraUser)-[:IN_DOMAIN]->(:EntraDomain): Links an Entra user to the tenant domain of its user principal name.

The domain's authentication type says whether Entra ID or an external identity provider signs the user in.

  • (:EntraUser)-[:MEMBER_OF]->(:EntraGroup): Links Entra users to a group they belong to.

  • (:EntraUser)-[:REPORTS_TO]->(:EntraUser): Links an Entra user to their manager.

  • (:AzureTenant)-[:RESOURCE]->(:EntraUser): Links a Microsoft tenant to one of its Entra users.

IntuneCompliancePolicy

A device compliance policy configured in Microsoft Intune.

Properties

Field Index Description
id Yes Intune compliance policy ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
applies_to_all_devices Whether the policy applies to all managed devices.
applies_to_all_users Whether the policy applies to all licensed users.
created_date_time Timestamp when the policy was created.
description Administrator-provided policy description.
display_name Display name of the compliance policy.
last_modified_date_time Timestamp when the policy was last modified.
platform Device platform targeted by the policy.
version Version of the compliance policy.

Relationships

  • (:IntuneCompliancePolicy)-[:APPLIES_TO]->(:IntuneManagedDevice): generated by analysis job Intune compliance policy to device resolution.

  • (:IntuneCompliancePolicy)-[:ASSIGNED_TO]->(:EntraGroup): Links an Intune compliance policy to an assigned Entra group.

  • (:AzureTenant)-[:RESOURCE]->(:IntuneCompliancePolicy): Links a Microsoft tenant to one of its Intune compliance policies.

IntuneDetectedApp

An application detected on devices managed by Microsoft Intune.

Properties

Field Index Description
id Yes Intune report application key for the detected app.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
application_id Application ID reported by Intune when available.
device_count Number of devices with the application detected.
display_name Display name of the detected application.
platform Platform on which the application was detected.
publisher Publisher of the detected application.
version Detected application version.

Relationships

  • (:IntuneManagedDevice)-[:HAS_APP]->(:IntuneDetectedApp): Links an Intune managed device to an application detected on it.

  • (:AzureTenant)-[:RESOURCE]->(:IntuneDetectedApp): Links a Microsoft tenant to a detected Intune application.

IntuneManagedDevice

A device managed by Microsoft Intune.

Ontology Projection: IntuneManagedDevice contributes data to canonical Device nodes.

Properties

Field Index Description
id Yes Intune managed device ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
azure_ad_device_id Microsoft Entra device ID.
azure_ad_device_id_normalized Yes Lowercase azureADDeviceId used for inventory joins; empty and all-zero IDs are excluded.
azure_ad_registered Whether the device is registered in Entra ID.
compliance_state Intune compliance state of the device.
device_enrollment_type Method used to enroll the device.
device_name Yes Name of the managed device.
device_registration_state Registration state of the device.
eas_activated Whether Exchange ActiveSync is activated.
eas_device_id Exchange ActiveSync device ID.
enrolled_date_time Timestamp when the device was enrolled.
ethernet_mac_address Ethernet MAC address of the device.
free_storage_space_in_bytes Available device storage in bytes.
imei International Mobile Equipment Identity of the device.
is_encrypted Whether the device storage is encrypted.
is_supervised Whether the device is supervised.
jail_broken Whether the device is jailbroken or rooted.
last_sync_date_time Timestamp of the latest Intune synchronization.
managed_device_owner_type Ownership type of the managed device.
management_agent Management channel used by the device.
manufacturer Manufacturer of the device.
meid Mobile Equipment Identifier of the device.
model Model of the device.
operating_system Operating system of the device.
os_version Operating system version of the device.
partner_reported_threat_state Threat state reported by a mobile threat defense partner.
physical_memory_in_bytes Physical memory capacity in bytes.
serial_number Yes Serial number of the device.
tenant_id Microsoft tenant ID.
total_storage_space_in_bytes Total device storage capacity in bytes.
user_id Entra user ID associated with the device.
user_principal_name User principal name associated with the device.
wifi_mac_address Wi-Fi MAC address of the device.

Relationships

  • (:IntuneCompliancePolicy)-[:APPLIES_TO]->(:IntuneManagedDevice): generated by analysis job Intune compliance policy to device resolution.

  • (:DefenderMachine)-[:ASSOCIATED_WITH]->(:IntuneManagedDevice): Matches Defender and Intune inventory by Entra device ID within the same tenant.

Both producers write the same lowercase key; empty and all-zero device IDs never link. Entra users are reachable through the Intune enrollment.

  • (:EntraUser)-[:ENROLLED_TO]->(:IntuneManagedDevice): Links an Entra user to a device they enrolled in Intune.

  • (:IntuneManagedDevice)-[:HAS_APP]->(:IntuneDetectedApp): Links an Intune managed device to an application detected on it.

  • (:Device)-[:OBSERVED_AS]->(:IntuneManagedDevice)

  • (:AzureTenant)-[:RESOURCE]->(:IntuneManagedDevice): Links a Microsoft tenant to one of its Intune managed devices.

M365License

A Microsoft 365 license subscription held by a tenant.

Properties

Field Index Description
id Yes Tenant-scoped identifier for the subscribed Microsoft 365 SKU.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
applies_to Resource type to which the subscribed SKU applies.
capability_status Current capability status of the subscribed SKU.
consumed_units Number of licenses currently assigned.
prepaid_enabled Number of prepaid licenses currently enabled.
prepaid_suspended Number of prepaid licenses currently suspended.
prepaid_warning Number of prepaid licenses in warning state.
sku_id Yes Microsoft product SKU GUID.
sku_part_number Yes Microsoft product SKU part number.

Relationships

  • (:EntraUser)-[:ASSIGNED_LICENSE]->(:M365License): Links an Entra user to a Microsoft 365 license assigned to them.

  • (:M365License)-[:HAS_SERVICE_PLAN]->(:M365ServicePlan): Links a Microsoft 365 license to one of its included service plans.

  • (:AzureTenant)-[:RESOURCE]->(:M365License): Links a Microsoft tenant to one of its Microsoft 365 licenses.

M365ServicePlan

A service entitlement included in a Microsoft 365 license.

Properties

Field Index Description
id Yes Tenant-scoped Microsoft 365 service plan identifier.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
applies_to Resource type to which the service plan applies.
provisioning_status Current provisioning status of the service plan.
service_plan_id Yes Microsoft service plan GUID.
service_plan_name Yes Microsoft service plan name.

Relationships

  • (:M365License)-[:HAS_SERVICE_PLAN]->(:M365ServicePlan): Links a Microsoft 365 license to one of its included service plans.

  • (:AzureTenant)-[:RESOURCE]->(:M365ServicePlan): Links a Microsoft tenant to one of its Microsoft 365 service plans.