Microsoft Defender XDR
Hunting and detection

Advanced Hunting Identityaccountinfo Table

In brief

The table now removes two Defender risk fields, adds SourceProviderRiskLevelDetails, SourceSystem, and TimeGenerated, corrects field names, and changes SourceProviderRiskLevel from dynamic to string.

What Defender admins need to know

Review hunting queries or integrations that reference the changed, removed, or newly typed fields.

Summaries are generated from the documentation change itself.

Documentation change

The comparison below shows only the changed extract. Use the full-page view for complete context.

ms.custom:

  • cx-ti
  • cx-ah
  • msecd-doc-authoring-1032 ms.topic: reference ms.date: 2026-02-04T00:11-19T00:00:00.0000000Z ai-usage: ai-assisted locale: en-us document_id: 668172cc-f654-de43-3c93-8e63359d0742 document_version_independent_id: 668172cc-f654-de43-3c93-8e63359d0742
Column name Data type Description
Timestamp datetime The dateDate and time thatwhen the linerecord was written to the database.This is used when there are multiple lines for each identity, such as when a change is detected, or if 24 hours have passed since the last database line was added.generated
ReportId string Unique identifier for the event
SourceProviderAccountId string Identifier for the account in the source provider (for example, object ID for a Microsoft Entra ID account)
AccountId string Internal identifier for the account
IdentityId string Identifier for the identity that the account is linked to
IsPrimary bool Indicates if this account is considered as primary account for the linked identity
IdentityLinkType string Type of linkage between the account and identity; possible values: Manual, Strong identifiers
IdentityLinkReason string Reason for linking the account and identity. If the linkage type is manual, the value will be the justification comment added by the user.
IdentityLinkTime datetime Date and time the account was linked to the identity
AccountUpn string User principal name (UPN) of the account
EmailAddress string SMTP address of the account
CriticalityLevel int The criticality score of the account
DefenderRiskLevelintThe risk level of the account as calculated by Microsoft Defender
DefenderRiskUpdateTimedatetimeDate and time Microsoft Defender last updated the risk level of the account
Type string Type of identity; possible values: User, ServiceAccount
GivenName string Given name or first name of the account user
Surname string Surname, family name, or last name of the account user
SourceProviderInstanceId string The identifier of the source application or service of the account. For example, in Microsoft Entra ID, this is the organization Globally Unique Identifier (GUID).
SourceProviderInstanceDisplayName string The display name of the source application or service of the account
AuthenticationMethod string Authentication method used to allow the account user to sign into the account; possible values: Credentials, Federated, Hybrid
AuthenticationSourceAcccountIdAuthenticationSourceAccountId string The identifier of the federating account, if the authentication method is Federated
EnrolledMfas dynamic Types of multifactor authentication methods configured for the account user and their status
LastPasswordChangeTime datetime Date and time the account password was last changed
GroupMembership dynamic Group identifiers assigned to the account
AssignedRoles dynamic Role identifiers assigned to the account
EligibleRoles dynamic Identifiers for roles the account are eligible to use (for example, Microsoft Entra Privileged Identity Management roles)
TenantMembershipType string User type; possible values: Guest, Member
CreatedDateTime datetime Date and time when the user account was created
DeletedDateTime datetime Date and time when the user account was deleted
Tags dynamic Tags assigned to the account by Defender for Identity
SourceProvderRiskLevelSourceProviderRiskLevel dynamicstring Risk level of the account as it appears in the source provider; possible values: Low, Medium, High
SourceProviderRiskLevelDetailsstringDetails regarding the risk level in the source provider
AdditionalFields dynamic Additional information about the entity or event
\ No newline at end of file
TenantId string Universally unique identifier (UUID) for the tenant
\ No newline at end of fileSourceSystem string The source system for the record
TimeGenerateddatetimeTime when the event was generated (UTC)
\ No newline at end of file