Skip to main content

📗 Azure SQL Server

  • ID: /types/CA10__CaAzureSqlServer__c

Fields

LabelAPI NameTypeHelp
🔒Active Directory Admin: Azure Only AuthCA10__activeDirectoryAdminAzureOnlyAuth__cText(255)API Call: Microsoft.Sql/servers/administrators
🔒🔌Active Directory Admin: TypeCA10__activeDirectoryAdminType__cText(255)API Call: Microsoft.Sql/servers/administrators
🔒Active Directory Admin: User IDCA10__activeDirectoryAdminUserId__cText(255)API Call: Microsoft.Sql/servers/administrators
🔒Administrator User NameCA10__administratorUserName__cText(255)API Call: Microsoft.Sql/servers
🔒🧮ApplicationCA10__application__cText(1300)
🔒Application Tier Api NameCA10__applicationTierApiName__cText(255)
🔒Application Tier Cascade AttachCA10__applicationTierCascadeAttach__cCheckbox
🔒Application Tier Client NameCA10__applicationTierClientName__cText(255)
🔒Application Tier Parent TypeCA10__applicationTierParentType__cText(255)
🔒Application Tier Parent UUIDCA10__applicationTierParentUuid__cText(255)
🔒Application Tier Unique NameCA10__applicationTierUniqueName__cText(255)
🔒🔌AuditingCA10__auditing__cText(255)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒Auditing: Audit Actions And GroupsCA10__auditingAuditActionsAndGroups__cLongTextArea(131072)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒Auditing: Is Azure Monitor TargetCA10__auditingIsAzureMonitorTarget__cText(255)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒Auditing: Is Storage Secondary Key UseCA10__auditingIsStorageSecondaryKeyUse__cText(255)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒Auditing: Queue Delay, MillisCA10__auditingQueueDelayMillis__cNumber(18, 0)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒🔌Auditing: Retention DaysCA10__auditingRetentionDays__cNumber(18, 0)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒Auditing: Storage EndpointCA10__auditingStorageEndpoint__cText(255)API Call: Microsoft.Sql/servers/auditingSettings/read
🔒Azure SQL Server NameNameText(80)API Call: Microsoft.Sql/servers
🔒CloudAware UUIDCA10__caUuid__cText(36)
🔒Cost: 30-DayCA10__cost30d__cCurrency(18, 2)
🔒Cost: MTDCA10__costMtd__cCurrency(18, 2)
🔒Created DateCreatedDateDateTime
🔒DeletedIsDeletedCheckbox
🔒Deleted From AzureCA10__disappearanceTime__cDateTime
🔒🔌Encryption Protector: KindCA10__encryptionProtectorKind__cText(255)API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒Encryption Protector: Server Key NameCA10__encryptionProtectorServerKeyName__cText(255)API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒🔌Encryption Protector: Server Key TypeCA10__encryptionProtectorServerKeyType__cText(255)API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒Encryption Protector: SubregionCA10__encryptionProtectorSubregion__cText(255)API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒Encryption Protector: ThumbprintCA10__encryptionProtectorThumbprint__cText(255)API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒🔌Encryption Protector: URICA10__encryptionProtectorUri__cText(255)API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒🔌Firewall Rules JSONCA10__firewallRulesJson__cLongTextArea(131072)
JSON
Inline Help: JSON Document
API Call: Microsoft.Sql/servers/firewallRules/read
🔒Fully Qualified Domain NameCA10__fullyQualifiedDomainName__cText(255)API Call: Microsoft.Sql/servers
🔒IDCA10__id__cText(255)API Call: Microsoft.Sql/servers
🔒Identity: Principal IDCA10__identityPrincipalId__cText(255)API Call: Microsoft.Sql/servers
🔒Identity: Tenant IDCA10__identityTenantId__cText(255)API Call: Microsoft.Sql/servers
🔒Identity: TypeCA10__identityType__cText(255)API Call: Microsoft.Sql/servers
🔒KindCA10__kind__cText(255)API Call: Microsoft.Sql/servers
🔒Last Activity DateLastActivityDateDate
🔒Last Modified DateLastModifiedDateDateTime
🔒🔌Location NameCA10__locationName__cText(255)API Call: Microsoft.Sql/servers
🔒Minimal TLS VersionCA10__minimalTlsVersion__cText(255)API Call: Microsoft.Sql/servers
🔒NameCA10__name__cText(255)API Call: Microsoft.Sql/servers
🔒Private Endpoint ConnectionsCA10__privateEndpointConnections__cLongTextArea(131072)
JSON
Inline Help: JSON Document
API Call: Microsoft.Sql/servers
🔒🔌Public Network AccessCA10__publicNetworkAccess__cText(255)API Call: Microsoft.Sql/servers
🔒Record IDIdText
🔒Resource Group IDCA10__resourceGroupId__cText(255)
🔒StateCA10__state__cText(255)API Call: Microsoft.Sql/servers
🔒System ModstampSystemModstampDateTime
🔒Tag CountCA10__tagCount__cNumber(18, 0)API Call: Microsoft.Sql/servers
🔒TagsCA10__tags__cLongTextArea(32768)API Call: Microsoft.Sql/servers
🔒Tags JSONCA10__tagsJson__cLongTextArea(32768)API Call: Microsoft.Sql/servers
🔒Threat DetectionCA10__threatDetection__cText(255)API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒Threat Detection: Creation TimeCA10__threatDetectionCreationTime__cDateTimeAPI Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒Threat Detection: Disabled AlertsCA10__threatDetectionDisabledAlerts__cLongTextArea(131072)API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒Threat Detection: Retention DaysCA10__threatDetectionRetentionDays__cNumber(18, 0)API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒Threat Detection: Send Alerts ToCA10__threatDetectionSendAlertsTo__cLongTextArea(131072)API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒Threat Detection: Send To AdminCA10__threatDetectionSendToAdmin__cCheckboxAPI Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒Threat Detection: Storage EndpointCA10__threatDetectionStorageEndpoint__cText(255)API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒TypeCA10__type__cText(255)API Call: Microsoft.Sql/servers
🔒VersionCA10__version__cText(255)API Call: Microsoft.Sql/servers

Extracts

NameExtracts File
🔒CA10__activeDirectoryAdminType__c🔌 object.extracts.yaml
🔒CA10__auditingRetentionDays__c🔌 object.extracts.yaml
🔒CA10__auditing__c🔌 object.extracts.yaml
🔒CA10__encryptionProtectorKind__c🔌 object.extracts.yaml
🔒CA10__encryptionProtectorServerKeyType__c🔌 object.extracts.yaml
🔒CA10__encryptionProtectorUri__c🔌 object.extracts.yaml
🔒CA10__firewallRulesJson__c🔌 object.extracts.yaml
🔒CA10__locationName__c🔌 object.extracts.yaml
🔒CA10__publicNetworkAccess__c🔌 object.extracts.yaml
caJsonFrom__firewallRulesJson__c🔌 object.extracts.yaml

Lookups

LabelAPI NameType
🔒Active Directory Admin: UserCA10__activeDirectoryAdminUser__c / CA10__activeDirectoryAdminUser__rCA10__CaAzureActiveDirectoryUser__c
🔒Application TierCA10__applicationTier__c / CA10__applicationTier__rCA10__CaApplicationTier__c
🔒Created By IDCreatedById / CreatedByUser
🔒Last Modified By IDLastModifiedById / LastModifiedByUser
🔒Received Connection IDConnectionReceivedId / ConnectionReceivedPartnerNetworkConnection
🔒Record Type IDRecordTypeId / RecordTypeRecordType
🔒ResourceCA10__resource__c / CA10__resource__r📗 Azure Resource
🔒Resource GroupCA10__resourceGroup__c / CA10__resourceGroup__rCA10__CaAzureResourceGroup__c
🔒Sent Connection IDConnectionSentId / ConnectionSentPartnerNetworkConnection
🔒SubscriptionCA10__account__c / CA10__account__r📗 Azure Subscription
Related TypeRelated List API NameForeign Key Field
🔒📗 Azure SQL DatabaseCA10__AzureSqlDatabases__rCA10__sqlServer__c
🔒📗 Azure SQL Elastic PoolCA10__Azure_SQL_Elastic_Pools__rCA10__sqlServer__c

Extract Files

ExtractParentFlags
🔌 object.extracts.yaml📗 Azure SQL Server

Logic Files

LogicPolicyFlags
🧠 prod.logic.yaml🟢🛡️ Azure SQL Database allows ingress from 0.0.0.0/0 (ANY IP)🟢🟢 x3
🧠 prod.logic.yaml🟢🛡️ Azure SQL Server Auditing is not enabled🟢🟢 x3
🧠 prod.logic.yaml🟢🛡️ Azure SQL Server Auditing Retention is less than 90 days🟢🟢 x3
🧠 prod.logic.yaml🟢🛡️ Azure SQL Server Microsoft Entra authentication is not configured🟢🟢 x3
🧠 prod.logic.yaml🟢🛡️ Azure SQL Server Public Network Access is not disabled🟢🟢 x3
🧠 prod.logic.yaml🟢🛡️ Azure SQL Server Transparent Data Encryption Protector is not encrypted with Customer-managed key🟢🟢 x3