OAuthAppInfo

OAuthAppInfo Schema #

Table description #

TableSection TableType TableSectionName Description
Itp Regular This table will hold inventory information about apps that have OAuth access to Microsoft 365 resources

Table retention #

HotDays ColdDays TotalInteractiveDays
30 0 30

Schema #

Name Description Type
AddedOnTime Date and time when the application was registered DateTime
AppName The application’s display name as exposed by the associated service principal String
AppOrigin Specifies whether was the app is internal to the organization or registered in an external tenant String
AppOwnerTenantId Specifies the ID of the tenant where the app was registered String
AppStatus Status of the app; can be: Enabled, DisabledByMicrosoft, DisabledByAppGovernancePolicy, DisabledByUser, Deleted (information for apps with Deleted status is only available for 30 days since the app was deleted) String
ConsentedUsersCount Count of users who have consented to the app; this information is only available when the app is not admin consented Int32
IsAdminConsented Value is True if a user has provided admin consent to the app on behalf of all the users in the org, otherwise the value is False Boolean
LastModifiedTime Timestamp when the app was last modified DateTime
LastUsedTime Date and time when the app was last used DateTime
OAuthAppId The unique identifier for the app as assigned by Microsoft Entra ID String
Permissions Contains an array of permission objects; each permission object includes PermissionName, TargetAppId, TargetAppDisplayName, PermissionType, PrivilegeLevel, UsageStatus Object
PrivilegeLevel The privilege level of the app based on the highest classified permission granted to the app String
ReportId Unique identifier for the record String
ServicePrincipalId The unique identifier for the service principal instance of the application in the tenant String
SourceSystem String
TenantId String
TimeGenerated DateTime
Timestamp Date and time when the record was created DateTime
Type String
VerifiedPublisher Specifies details about the verified publisher of the application which this service principal represents. It includes information such as: DisplayName, VerifiedPublisherId, AddedDateTime Object

Schema changes #

Date Action
2026-01-02 Table added to tracking