Azure Alert Rules, API Management, and Applications Tables

Tables

AzureADAccessPackages

Entitlement Management access packages available for self-service assignment in the tenant's catalogs.

Name	Type	Description
ID	string	Entitlement Management access package id (PK with ConfigID)
ConfigID	integer	Azure integration config that collected the row (PK with ID)
DisplayName	string	Access package name
Description	string	Access package description
IsHidden	boolean	Whether the package is hidden from the my-access catalog
IsRoleScopesVisible	boolean	Whether role scopes are visible; Graph v1.0 does not populate this
CreatedDateTime	datetime	When the access package was created
ModifiedDateTime	datetime	When the access package was last modified
CatalogID	string	Catalog id from the expanded catalog navigation
BatchDate	datetime	UTC timestamp of the ETL load that wrote the row
ID	string	Entitlement Management access package id (PK with ConfigID)
ConfigID	integer	Azure integration config that collected the row (PK with ID)

AzureADAccessPackageAssignments

Assignments of access packages to subjects, including their state and assignment policy.

Name	Type	Description
ID	string	Access package assignment id (PK with ConfigID)
ConfigID	integer	Azure integration config that collected the row (PK with ID)
AccessPackageID	string	Assigned access package id (`accessPackage.id`)
AssignmentPolicyID	string	Policy that delivered the assignment (`assignmentPolicy.id`)
TargetID	string	Subject object id (`target.objectId`, else `target.id`)
State	string	Assignment state (`Delivered`, `Expired`, etc.)
Status	string	Assignment status string from Graph
ExpiredDateTime	datetime	When the assignment expired or will expire
ScheduleStartDateTime	datetime	Assignment schedule start
ScheduleEndDateTime	datetime	Assignment schedule expiration end
BatchDate	datetime	UTC timestamp of the ETL load that wrote the row

AzureADAlertRules

Azure Monitor alert rule definitions, including their scope, severity, and current state.

Name	Type	Description
ID	string	Azure Resource ID
Name	string	The resource name
Location	string	The Resource locatoin
Scope	string	The resource scope
Description	string	The resource description
State	string	The alert rule state
Severity	string	The alert rule severity
BatchID	integer	The alert rule severity

AzureADAPIManagementServices

Azure API Management service instances, including their SKU, gateway URLs, and provisioning state.

Name	Type	Description
ID	string	Resource ID
Type	string	Resource type for API Management resource is set to `Microsoft.ApiManagement`.
TagsOwner	string	Owner tags
TagsReleaseName	string	Release tags
Location	string	Resource location
Etag	string	ETag of the resource
SkuName	string	SKU name property
SkuCapacity	integer	SKU capacity property
IdentityType	string	Identity type
IdentityPrincipalId	string	Identity principal ID
IdentityTenantId	string	Identity tenant ID
SystemDataCreatedBy	string	The identity that created the resource

AzureADAppConfigurations

Azure App Configuration store instances, including their endpoint, encryption, and provisioning state.

Name	Type	Description
ID	string	Fully qualified resource ID for the resource. Ex: `subscriptions`, `{subscriptionId}`, `resourceGroups`, `{resourceGroupName}`, `providers`, `{resourceProviderNamespace}`, `{resourceType}`, `{resourceName}`
Type	string	The type of the resource. E.g. `Microsoft.Compute`, `virtualMachines` or `Microsoft.Storage`, `storageAccounts`
PropertiesProvisioningState	string	The provisioning state of the configuration store
PropertiesCreationDate	datetime	The creation date of configuration store
PropertiesEndpoint	string	The DNS endpoint where the configuration store API will be available
EncryptionKeyIdentifier	string	The URI of the key vault key used to encrypt data
EncryptionIdentityClientId	string	The client id of the identity which will be used to access key vault
PropertiesDisableLocalAuth	boolean	Disables all authentication methods other than AAD authentication
PrivateEndpointConnections	string	A reference to a related private endpoint connection
PropertiesPublicNetworkAccess	string	Control permission for data plane traffic coming from public networks while private endpoint is enabled
SystemDataCreatedBy	string	The identity that created the resource
SystemDataCreatedByType	string	The type of identity that created the resource

AzureADApplicationGateways

Azure Application Gateway instances and their listeners, routing rules, backend pools, and SSL configuration.

Name	Type	Description
ID	string	Resource ID
Type	string	Resource Type
Location	string	Resource location
ProvisioningState	string	The provisioning state of the application gateway resource
SkuName	string	Name of an application gateway SKU
SkuTier	string	Tier of an application gateway
SkuCapacity	integer	Capacity (instance count) of an application gateway
OperationalState	string	Operational state of the application gateway resource
GatewayIPConfigurations	string	Subnets of the application gateway resource
ListSslCertificates	string	SSL certificates of the application gateway resource
ListTrustedClientCertificates	string	Trusted client certificates of the application gateway resource
ListAuthenticationCertificates	string	Authentication certificates of the application gateway resource

AzureADApplicationSecurityGroups

Application Security Groups used to group network interfaces for network security rule targeting.

Name	Type	Description
ID	string	Resource ID
Name	string	Resource name
Type	string	Rsource type
Location	string	Resource location
PropertiesProvisioningState	string	The provisioning state of the application security group resource
PropertiesResourceGuid	string	The resource GUID property of the application security group resource. It uniquely identifies a resource, even if the user changes its name or migrate the resource across subscriptions or resource groups

AzureADApps

Azure AD application (app registration) objects registered in the tenant.

Name	Type	Description
ID	string	A unique identifier for the Azure Active Directory application.
AppId	string	The application ID assigned to the Azure AD app.
DisplayName	string	The display name of the Azure AD application.
BatchID	integer	The identifier for the batch operation related to the Azure AD application.
BatchDate	datetime	The date and time when the batch operation was executed.
ConfigID	integer	A unique configuration identifier for the Azure AD application settings.

AzureADAppServiceEnvironments

App Service Environments hosting isolated App Service plans, including scaling and network configuration.

Name	Type	Description
ID	string	Unique string identifier for the App Service Environment.
Type	string	The type of the App Service Environment (e.g., `Microsoft.Web`).
Kind	string	Type of service (e.g., `app`, `linux`).
Location	string	Geographic location where the App Service Environment is hosted.
PropertiesTags	string	Tags associated with the App Service Environment for categorization.
PropertiesProvisioningState	string	Current provisioning state of the App Service Environment (e.g., `Succeeded`, `InProgress`).
PropertiesStatus	string	Current status of the App Service Environment (e.g., `Ready`, `Unavailable`).
PropertiesInternalLoadBalancingMode	string	Specifies the internal load balancing mode used in the environment (e.g., `None`, `Outbound`).
PropertiesMultiSize	string	Configuration related to multiple sizes in the environment (e.g., `Small`, `Medium`, `Large`).
PropertiesMultiRoleCount	integer	Number of roles deployed within the environment.
PropertiesIpsslAddressCount	integer	Number of IP SSL addresses allocated to the environment.
PropertiesDnsSuffix	string	DNS suffix for the App Service Environment.

AzureADAppServiceWebApps

Azure App Service web apps, including their runtime, hostnames, networking, and site configuration.

Name	Type	Description
ID	string	Unique string identifier for the App Service Web App.
Type	string	Type of the App Service Web App (e.g., `Microsoft.Web`).
Kind	string	Type of service (e.g., `app`, `linux`).
Location	string	Geographic location where the App Service Web App is hosted.
IdentityType	string	The identity type used by the web app (e.g., `SystemAssigned`).
IdentityTenantId	string	Tenant ID associated with the App Service Web App identity.
IdentityPrincipalId	string	Principal ID associated with the App Service Web App identity.
PropertiesName	string	Name of the App Service Web App property.
PropertiesState	string	Current state of the App Service Web App (e.g., `Running`, `Stopped`).
PropertiesJsonHostNames	string	JSON list of host names for the App Service Web App.
PropertiesWebSpace	string	Web space for the App Service Web App.
PropertiesSelfLink	string	Link to the App Service Web App's resource.