Azure Synapse, Tenants, Users, Virtual Machine, and WebApp Tables

Tables

AzureADSynapseWorkspaces

Azure Synapse Analytics workspace resources, including data lake, SQL, and connectivity configuration.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration.
ID	string	The unique identifier for the Synapse workspace.
Name	string	The name of the Synapse workspace.
Type	string	The type of the Synapse workspace.
Location	string	The geographical location where the workspace is hosted.
TagsKey	string	The key for tags associated with the workspace.
PropertiesDefaultDataLakeStorageAccountUrl	string	The URL of the default Data Lake Storage account associated with the workspace.
PropertiesDefaultDataLakeStorageFilesystem	string	The filesystem associated with the default Data Lake Storage account.
PropertiesConnectivityEndpointsDev	string	The development endpoints for connectivity to the workspace.
PropertiesConnectivityEndpointsSql	string	The SQL connectivity endpoints for the workspace.
PropertiesSqlAdministratorLogin	string	The SQL administrator login for the workspace.
PropertiesManagedResourceGroupName	string	The name of the managed resource group for the workspace.
PropertiesProvisioningState	string	The provisioning state of the workspace.
PropertiesWorkspaceUID	string	The unique workspace identifier.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADTenants

Azure AD tenant resources associated with the subscription, including domain and branding metadata.

Name	Type	Description
ConfigID	integer	A unique identifier for the tenant configuration.
ID	string	The unique identifier for the tenant.
TenantId	string	The tenant ID for the Azure Active Directory tenant.
CountryCode	string	The country code associated with the tenant.
DisplayName	string	The display name of the tenant.
ListDomains	string	The list of domains associated with the tenant.
TenantCategory	string	The category of the tenant (e.g., `organization`, `school`).
DefaultDomain	string	The default domain of the tenant.
TenantType	string	The type of the tenant (e.g., `business`, `government`, etc.).
TenantBrandingLogoUrl	string	The URL of the tenant's branding logo.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADUserRegistrationDetails

Per-user MFA and self-service password reset registration status in Azure AD.

Name	Type	Description
ConfigID	integer	A unique identifier for the user registration configuration.
ID	string	The unique identifier for the user registration record.
UserPrincipalName	string	The user’s principal name (UPN), typically their email address.
UserDisplayName	string	The display name of the user.
IsAdmin	boolean	Whether the user has administrative privileges.
IsSsprRegistered	boolean	Whether the user is registered for self-service password reset (SSPR).
IsSsprEnabled	boolean	Whether self-service password reset (SSPR)is enabled for the user.
IsSsprCapable	boolean	Whether the user is capable of using self-service password reset (SSPR).
IsMfaRegistered	boolean	Whether multi-factor authentication (MFA) is registered for the user.
IsMfaCapable	boolean	Whether the user is capable of using multi-factor authentication (MFA).
IsPasswordlessCapable	boolean	Whether the user is capable of using passwordless authentication.
LastUpdatedDateTime	datetime	The date and time when the user registration details were last updated.

AzureADUsers

Azure AD user objects, including profile attributes and sign-in activity.

Name	Type	Description
ID	integer	A unique identifier for the user record.
UserId	string	The unique identifier for the user.
DisplayName	string	The display name of the user.
Mail	string	The email address of the user.
UserPrincipalName	string	The user principal name (UPN) of the user.
IsAccountEnabled	boolean	Whether the user’s account is enabled.
ExternalUserState	string	The state of the external user (e.g., `invited`, `accepted`, etc.).
MailNickname	string	The mail nickname for the user.
BatchID	integer	The unique identifier for the batch operation.
BatchDate	datetime	The date and time when the batch operation was executed.
ConfigID	integer	A unique configuration identifier.
GivenName	string	The given name (first name) of the user.

AzureADVirtualMachineExtensions

Extensions installed on Azure virtual machines.

Name	Type	Description
ID	integer	A unique identifier for the virtual machine extension record.
AzureVirtualMachinetID	integer	The unique identifier for the Azure Virtual Machine associated with the extension.
Name	string	The name of the virtual machine extension.
Type	string	The type of the virtual machine extension.
Location	string	The location of the virtual machine extension.
Publisher	string	The publisher of the virtual machine extension.
BatchID	integer	The unique identifier for the batch operation.
BatchDate	datetime	The date and time when the batch operation was executed.
ConfigID	integer	A unique configuration identifier.

AzureADVirtualMachines

Azure virtual machine resources, including their location, resource group, and subscription.

Name	Type	Description
ID	integer	A unique identifier for the virtual machine record.
Name	string	The name of the virtual machine.
Type	string	The type of the virtual machine.
Location	string	The location of the virtual machine.
BatchID	integer	The unique identifier for the batch operation.
BatchDate	datetime	The date and time when the batch operation was executed.
ConfigID	integer	A unique configuration identifier.
ResourceGroup	string	The resource group associated with the virtual machine.
SubscriptionId	string	The subscription ID associated with the virtual machine.

AzureADVirtualNetworkRouteTables

Route table resources used to control routing within Azure virtual networks.

Name	Type	Description
ConfigID	integer	A unique identifier for the virtual network route table record.
ID	string	The unique identifier for the virtual network route table.
Name	string	The name of the virtual network route table.
Type	string	The type of the virtual network route table.
Location	string	The location of the virtual network route table.
PropertiesProvisioningState	string	The provisioning state of the virtual network route table.
PropertiesRoutes	string	The routes defined for the virtual network route table.
PropertiesAddressPrefix	string	The address prefix used in the virtual network route table.
PropertiesNextHopType	string	The type of the next hop for the routes in the virtual network route table.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADVirtualNetworks

Azure virtual network resources, including address space, subnets, and peering configuration.

Name	Type	Description
ConfigID	integer	A unique identifier for the virtual network record.
ID	string	The unique identifier for the virtual network.
Etag	string	The ETag value for the virtual network.
Type	string	The type of the virtual network.
Location	string	The location of the virtual network.
PropertiesProvisioningState	string	The provisioning state of the virtual network.
PropertiesResourceGuid	string	The resource GUID for the virtual network.
JsonPropertiesAddressSpace	string	The address space used by the virtual network.
PropertiesPrivateEndpointVNetPolicies	string	The policies for private endpoints on the virtual network.
JsonPropertiesSubnets	string	The subnets defined in the virtual network.
PropertiesVirtualNetworkPeerings	string	The virtual network peerings in the virtual network.
PropertiesEnableDdosProtection	boolean	Whether DDoS protectionis enabled for the virtual network.

AzureADWebAppIdentities

Managed identity assignments configured on Azure App Service web apps.

Name	Type	Description
ID	integer	A unique identifier for the web app identity record.
PrincipalId	string	The principal ID of the web app identity.
TenantId	string	The tenant ID associated with the web app identity.
Type	string	The type of the web app identity.
AzureADWebAppId	integer	The unique identifier for the Azure Web App.
ConfigID	integer	A unique configuration identifier.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebApplicationFirewallPolicies

Web Application Firewall policy resources, including managed and custom rule configuration.

Name	Type	Description
ConfigID	integer	A unique configuration identifier for the web application firewall policy.
ID	string	The unique identifier for the web application firewall policy.
Name	string	The name of the web application firewall policy.
Type	string	The type of the web application firewall policy.
TagsKey1	string	A key for tagging the web application firewall policy.
TagsKey2	string	A secondary key for tagging the web application firewall policy.
Location	string	The location of the web application firewall policy.
PropertiesResourceState	string	The resource state of the web application firewall policy.
PropertiesProvisioningState	string	The provisioning state of the web application firewall policy.
JsonPropertiesPolicySettings	string	The policy settings in JSON format for the web application firewall policy.
JsonPropertiesCustomRules	string	The custom rules in JSON format for the web application firewall policy.
JsonPropertiesManagedRules	string	The managed rules in JSON format for the web application firewall policy.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebAppProperties

HTTPS and client certificate configuration properties of Azure App Service web apps.

Name	Type	Description
ID	integer	A unique identifier for the web application properties record.
HttpsOnly	boolean	Whether HTTPS is enforced for the web application.
ClientCertMode	string	The client certificate mode for the web application.
AzureADWebAppId	integer	The unique identifier for the Azure web application.
ConfigID	integer	A unique configuration identifier.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebAppPropertySiteConfigs

Site configuration settings (TLS, FTP state) of Azure App Service web apps.

Name	Type	Description
ID	integer	A unique identifier for the web application property site configuration record.
MinTlsVersion	decimal	The minimum TLS version allowed for the web application property site.
HttpEnabled	boolean	Whether HTTPis enabled for the web application property site.
FtpState	string	The FTP state for the web application property site.
AzureADWebAppPropertyId	integer	The unique identifier for the web application property associated with the site config.
ConfigID	integer	A unique configuration identifier.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebApps

Azure App Service web app resources, including their kind and location.

Name	Type	Description
ID	integer	A unique identifier for the web application.
Kind	string	The kind or type of the web application (e.g., `web app`, `API`).
Location	string	The location where the web application is hosted.
Name	string	The name of the web application.
BatchID	integer	A unique identifier for the batch operation.
ConfigID	integer	A unique configuration identifier for the web application.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebAppsAuthSettingProperties

Junction table linking App Service authentication settings to their configured identity providers.

Name	Type	Description
ID	integer	A unique identifier for the web app authentication setting property.
AzureADWebAppsAuthSettingId	integer	The unique identifier for the authentication setting associated with the web app.
AzureADWebAppsIdentityProviderId	integer	The unique identifier for the identity provider associated with the authentication setting.
ConfigID	integer	A unique configuration identifier for the authentication settings.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebAppsAuthSettings

Authentication/authorization settings (Easy Auth) configured on Azure App Service web apps.

Name	Type	Description
ID	integer	A unique identifier for the web application authentication settings.
Location	string	The location of the web application authentication settings.
Name	string	The name of the web application authentication settings.
Tags	string	A set of tags associated with the web application authentication settings.
Type	string	The type of the web application authentication settings.
AzureADWebAppId	integer	The unique identifier for the web application associated with the authentication settings.
ConfigID	integer	A unique configuration identifier for the authentication settings.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebAppsAzureActiveDirectories

Azure AD identity provider configuration for App Service authentication settings.

Name	Type	Description
ID	integer	A unique identifier for the Azure Active Directory settings associated with the web app.
Enabled	boolean	Indicates whether the Azure Active Directoryis enabled for the web application.
AzureADWebAppsIdentityProviderId	integer	The unique identifier for the identity provider associated with the web app's Azure Active Directory.
ConfigID	integer	A unique configuration identifier for the Azure Active Directory settings.
BatchDate	datetime	The date and time when the batch operation was executed.

AzureADWebAppsIdentityProviders

Identity providers configured within App Service authentication settings.

Name	Type	Description
ID	integer	A unique identifier for the web app's identity provider settings.
AzureADWebAppsAuthSettingPropertyId	integer	The unique identifier for the Azure Web Apps Authentication Setting Property associated with the identity provider.
ConfigID	integer	A unique configuration identifier for the identity provider settings.
BatchDate	datetime	The date and time when the batch operation was executed.