📕 Azure SQL Server

• Contextual name: 📕 Azure SQL Server
• ID: /types/CA10__CaAzureSqlServer__c

Fields

	Label	API Name	Type	Help
🔒	Active Directory Admin: Azure Only Auth	CA10__activeDirectoryAdminAzureOnlyAuth__c	Text(255)	API Call: Microsoft.Sql/servers/administrators
🔒🔌	Active Directory Admin: Type	CA10__activeDirectoryAdminType__c	Text(255)	API Call: Microsoft.Sql/servers/administrators
🔒	Active Directory Admin: User ID	CA10__activeDirectoryAdminUserId__c	Text(255)	API Call: Microsoft.Sql/servers/administrators
🔒	Administrator User Name	CA10__administratorUserName__c	Text(255)	API Call: Microsoft.Sql/servers
🔒🧮	Application	CA10__application__c	Text(1300)
🔒	Application Tier Api Name	CA10__applicationTierApiName__c	Text(255)
🔒	Application Tier Cascade Attach	CA10__applicationTierCascadeAttach__c	Checkbox
🔒	Application Tier Client Name	CA10__applicationTierClientName__c	Text(255)
🔒	Application Tier Parent Type	CA10__applicationTierParentType__c	Text(255)
🔒	Application Tier Parent UUID	CA10__applicationTierParentUuid__c	Text(255)
🔒	Application Tier Unique Name	CA10__applicationTierUniqueName__c	Text(255)
🔒🔌	Auditing	CA10__auditing__c	Text(255)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒	Auditing: Audit Actions And Groups	CA10__auditingAuditActionsAndGroups__c	LongTextArea(131072)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒	Auditing: Is Azure Monitor Target	CA10__auditingIsAzureMonitorTarget__c	Text(255)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒	Auditing: Is Storage Secondary Key Use	CA10__auditingIsStorageSecondaryKeyUse__c	Text(255)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒	Auditing: Queue Delay, Millis	CA10__auditingQueueDelayMillis__c	Number(18, 0)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒🔌	Auditing: Retention Days	CA10__auditingRetentionDays__c	Number(18, 0)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒	Auditing: Storage Endpoint	CA10__auditingStorageEndpoint__c	Text(255)	API Call: Microsoft.Sql/servers/auditingSettings/read
🔒	Azure SQL Server Name	Name	Text(80)	API Call: Microsoft.Sql/servers
🔒	CloudAware UUID	CA10__caUuid__c	Text(36)
🔒	Cost: 30-Day	CA10__cost30d__c	Currency(18, 2)
🔒	Cost: MTD	CA10__costMtd__c	Currency(18, 2)
🔒	Created Date	CreatedDate	DateTime
🔒	Deleted	IsDeleted	Checkbox
🔒	Deleted From Azure	CA10__disappearanceTime__c	DateTime
🔒🔌	Encryption Protector: Kind	CA10__encryptionProtectorKind__c	Text(255)	API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒	Encryption Protector: Server Key Name	CA10__encryptionProtectorServerKeyName__c	Text(255)	API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒🔌	Encryption Protector: Server Key Type	CA10__encryptionProtectorServerKeyType__c	Text(255)	API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒	Encryption Protector: Subregion	CA10__encryptionProtectorSubregion__c	Text(255)	API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒	Encryption Protector: Thumbprint	CA10__encryptionProtectorThumbprint__c	Text(255)	API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒🔌	Encryption Protector: URI	CA10__encryptionProtectorUri__c	Text(255)	API Call: Microsoft.Sql/servers/encryptionProtector/read
🔒🔌	Firewall Rules JSON	CA10__firewallRulesJson__c	LongTextArea(131072) JSON	Inline Help: JSON Document API Call: Microsoft.Sql/servers/firewallRules/read
🔒	Fully Qualified Domain Name	CA10__fullyQualifiedDomainName__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	ID	CA10__id__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Identity: Principal ID	CA10__identityPrincipalId__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Identity: Tenant ID	CA10__identityTenantId__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Identity: Type	CA10__identityType__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Kind	CA10__kind__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Last Activity Date	LastActivityDate	Date
🔒	Last Modified Date	LastModifiedDate	DateTime
🔒	Location Name	CA10__locationName__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Minimal TLS Version	CA10__minimalTlsVersion__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Name	CA10__name__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Private Endpoint Connections	CA10__privateEndpointConnections__c	LongTextArea(131072) JSON	Inline Help: JSON Document API Call: Microsoft.Sql/servers
🔒🔌	Public Network Access	CA10__publicNetworkAccess__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Record ID	Id	Text
🔒	Resource Group ID	CA10__resourceGroupId__c	Text(255)
🔒	State	CA10__state__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	System Modstamp	SystemModstamp	DateTime
🔒	Tag Count	CA10__tagCount__c	Number(18, 0)	API Call: Microsoft.Sql/servers
🔒	Tags	CA10__tags__c	LongTextArea(32768)	API Call: Microsoft.Sql/servers
🔒	Tags JSON	CA10__tagsJson__c	LongTextArea(32768)	API Call: Microsoft.Sql/servers
🔒	Threat Detection	CA10__threatDetection__c	Text(255)	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Threat Detection: Creation Time	CA10__threatDetectionCreationTime__c	DateTime	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Threat Detection: Disabled Alerts	CA10__threatDetectionDisabledAlerts__c	LongTextArea(131072)	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Threat Detection: Retention Days	CA10__threatDetectionRetentionDays__c	Number(18, 0)	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Threat Detection: Send Alerts To	CA10__threatDetectionSendAlertsTo__c	LongTextArea(131072)	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Threat Detection: Send To Admin	CA10__threatDetectionSendToAdmin__c	Checkbox	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Threat Detection: Storage Endpoint	CA10__threatDetectionStorageEndpoint__c	Text(255)	API Call: Microsoft.Sql/servers/securityAlertPolicies/read
🔒	Type	CA10__type__c	Text(255)	API Call: Microsoft.Sql/servers
🔒	Version	CA10__version__c	Text(255)	API Call: Microsoft.Sql/servers

Extracts

	Name	Extracts 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__publicNetworkAccess__c	🔌 object.extracts.yaml
	caJsonFrom__firewallRulesJson__c	🔌 object.extracts.yaml

Lookups

	Label	API Name	Type
🔒	Active Directory Admin: User	CA10__activeDirectoryAdminUser__c / CA10__activeDirectoryAdminUser__r	CA10__CaAzureActiveDirectoryUser__c
🔒	Application Tier	CA10__applicationTier__c / CA10__applicationTier__r	CA10__CaApplicationTier__c
🔒	Created By ID	CreatedById / CreatedBy	User
🔒	Last Modified By ID	LastModifiedById / LastModifiedBy	User
🔒	Received Connection ID	ConnectionReceivedId / ConnectionReceived	PartnerNetworkConnection
🔒	Record Type ID	RecordTypeId / RecordType	RecordType
🔒	Resource	CA10__resource__c / CA10__resource__r	📕 Azure Resource
🔒	Resource Group	CA10__resourceGroup__c / CA10__resourceGroup__r	CA10__CaAzureResourceGroup__c
🔒	Sent Connection ID	ConnectionSentId / ConnectionSent	PartnerNetworkConnection
🔒	Subscription	CA10__account__c / CA10__account__r	📕 Azure Subscription

Related Lists

	Related Type	Related List API Name	Foreign Key Field
🔒	📕 Azure SQL Database	CA10__AzureSqlDatabases__r	CA10__sqlServer__c

Extract Files

Extract	Type	Flags
🔌 object.extracts.yaml	📕 Azure SQL Server

Logic Files

Logic	Policy	Flags
🧠 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