Azure Sharepoint, SignalR, and SQL Tables

Tables

AzureADSharepointDriveFiles

Files stored in SharePoint document library drives.

Name	Type	Description
ID	string	A unique identifier for the SharePoint drive file.
Name	string	The name of the SharePoint drive file.
CreatedBy	string	The creator of the SharePoint drive file.
Description	string	A description of the SharePoint drive file.
ETag	string	The ETag value for the SharePoint drive file.
LastModifiedBy	string	The last user who modified the SharePoint drive file.
WebUrl	string	The URL to access the SharePoint drive file in a web browser.
LastModifiedDateTime	datetime	The date and time when the SharePoint drive file was last modified.
CreatedDateTime	datetime	The date and time when the SharePoint drive file was created.
BatchDate	datetime	The date and time when the batch operation for the SharePoint drive file was executed.
DriveId	integer	The identifier of the drive associated with the SharePoint file.
ConfigID	integer	A configuration ID for the SharePoint drive file.

AzureADSharepointDrives

SharePoint document library drive resources and their storage quota.

Name	Type	Description
ID	integer	A unique identifier for the SharePoint drive.
DriveId	string	The identifier for the SharePoint drive.
QuotaUsed	bigint	The amount of storage used by the SharePoint drive.
QuotaRemaining	bigint	The amount of remaining storage for the SharePoint drive.
QuotaState	string	The state of the quota for the SharePoint drive (e.g., `warning`, `over quota`).
Owner	string	The owner of the SharePoint drive.
LastModifiedBy	string	The last user who modified the SharePoint drive.
LastModifiedDate	datetime	The date and time when the SharePoint drive was last modified.
BatchID	integer	The batch operation identifier for the SharePoint drive.
BatchDate	datetime	The date and time when the batch operation for the SharePoint drive was executed.
SiteId	integer	The identifier for the SharePoint site that the drive belongs to.
ConfigID	integer	A configuration ID for the SharePoint drive.

AzureADSharepointSites

SharePoint Online site collections provisioned in the tenant.

Name	Type	Description
ID	integer	A unique identifier for the SharePoint site.
SiteId	string	The identifier for the SharePoint site.
Name	string	The name of the SharePoint site.
CreatedDate	datetime	The date and time when the SharePoint site was created.
LastModifiedDate	datetime	The date and time when the SharePoint site was last modified.
CreatedBy	string	The user who created the SharePoint site.
BatchID	integer	The batch operation identifier for the SharePoint site.
BatchDate	datetime	The date and time when the batch operation for the SharePoint site was executed.
ConfigID	integer	A configuration ID for the SharePoint site.

AzureADSignalRServices

Azure SignalR Service resources, including SKU, networking, and feature configuration.

Name	Type	Description
ConfigID	integer	A configuration ID for the SignalR service.
ID	string	A unique identifier for the SignalR service.
SkuName	string	The SKU name for the SignalR service.
SkuTier	string	The SKU tier for the SignalR service.
SkuSize	string	The SKU size for the SignalR service.
SkuCapacity	integer	The SKU capacity for the SignalR service.
IdentityType	string	The identity type for the SignalR service.
IdentityPrincipalId	string	The principal ID of the identity for the SignalR service.
IdentityTenantId	string	The tenant ID of the identity for the SignalR service.
Location	string	The location of the SignalR service.
TagsKey1	string	A tag key associated with the SignalR service.
Type	string	The type of the SignalR service.

AzureADSQLDatabases

Azure SQL Database resources hosted on Azure SQL logical servers, including encryption settings.

Name	Type	Description
ID	integer	A unique identifier for the SQL database.
AzureSQLServerID	integer	The identifier for the associated Azure SQL server.
Name	string	The name of the SQL database.
Type	string	The type of the SQL database.
Location	string	The location where the SQL database is hosted.
IsInfraEncryptionEnabled	boolean	Whether infrastructure encryptionis enabled for the SQL database.
TransparentDataEncryptionState	string	The state of Transparent Data Encryption (TDE) for the SQL database.
BatchID	integer	The batch operation identifier for the SQL database.
BatchDate	datetime	The date and time when the batch operation for the SQL database was executed.
ConfigID	integer	A configuration ID for the SQL database.

AzureADSQLManagedInstances

Azure SQL Managed Instance resources, including SKU, networking, and provisioning state.

Name	Type	Description
ConfigID	integer	A configuration ID for the SQL Managed Instance.
ID	string	A unique identifier for the SQL Managed Instance.
Location	string	The location of the SQL Managed Instance.
Type	string	The type of the SQL Managed Instance.
SkuName	string	The SKU name of the SQL Managed Instance.
SkuTier	string	The SKU tier of the SQL Managed Instance.
SkuCapacity	integer	The SKU capacity of the SQL Managed Instance.
SkuFamily	string	The SKU family of the SQL Managed Instance.
PropertiesFullyQualifiedDomainName	string	The fully qualified domain name for the SQL Managed Instance.
PropertiesAdministratorLogin	string	The administrator login for the SQL Managed Instance.
PropertiesSubnetId	string	The subnet ID for the SQL Managed Instance.
PropertiesState	string	The state of the SQL Managed Instance.

AzureADSQLServerBlobAuditingPolicies

Blob auditing policy configuration for Azure SQL logical servers.

Name	Type	Description
ID	integer	A unique identifier for the Blob Auditing policy.
AzureSQLServerID	integer	The identifier for the associated Azure SQL server.
Name	string	The name of the Blob Auditing policy.
Type	string	The type of the Blob Auditing policy.
IsAzureMonitorTargetEnabled	boolean	Whether Azure Monitor is enabled as a target for the Blob Auditing policy.
IsDevopsAuditEnabled	boolean	Whether DevOps auditingis enabled for the Blob Auditing policy.
IsManagedIdentityInUse	boolean	Whether managed identity is in use for the Blob Auditing policy.
State	string	The state of the Blob Auditing policy.
StorageEndpoint	string	The storage endpoint for the Blob Auditing policy.
RetentionDays	integer	The retention period for the Blob Auditing policy, in days.
BatchID	integer	The batch operation identifier for the Blob Auditing policy.
BatchDate	datetime	The date and time when the batch operation for the Blob Auditing policy was executed.
ConfigID	integer	A configuration ID for the Blob Auditing policy.

AzureADSQLServers

Azure SQL logical server resources, including TLS, network access, and threat protection settings.

Name	Type	Description
ID	integer	A unique identifier for the SQL server.
Name	string	The name of the SQL server.
Type	string	The type of the SQL server.
Location	string	The location where the SQL server is hosted.
MinimalTlsVersion	string	The minimum TLS version for the SQL server.
PublicNetworkAccess	string	Whether public network accessis enabled for the SQL server.
AdvanceThreadProtectionState	string	The state of advanced threat protection for the SQL server.
RestrictOutboundNetworkAccess	string	Whether outbound network access is restricted for the SQL server.
FullyQualifiedDomainName	string	The fully qualified domain name (FQDN) of the SQL server.
BatchID	integer	The batch operation identifier for the SQL server.
BatchDate	datetime	The date and time when the batch operation for the SQL server was executed.
ConfigID	integer	A configuration ID for the SQL server.

AzureADSQLServerVulnerabilityAssessments

Vulnerability assessment configuration for Azure SQL logical servers, including scan settings and recipients.

Name	Type	Description
ID	integer	A unique identifier for the SQL server vulnerability assessment.
AzureSQLServerID	integer	The identifier for the associated Azure SQL server.
Name	string	The name of the vulnerability assessment.
StorageContainerPath	string	The storage container path for the vulnerability assessment results.
SendScanReportsTo	string	The recipients to whom scan reports are sent.
RecurringScansEnabled	boolean	Whether recurring scans are `enabled` for the vulnerability assessment.
EmailSubscriptionAdmins	boolean	Whether email subscription for administratorsis enabled for the assessment.
BatchID	integer	The batch operation identifier for the vulnerability assessment.
BatchDate	datetime	The date and time when the batch operation for the vulnerability assessment was executed.
ConfigID	integer	A configuration ID for the vulnerability assessment.