📗 Azure SQL Elastic Pool

ID: /types/CA10__CaAzureSqlElasticPool__c

Fields

	Label	API Name	Type	Help
🔒🧮	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)`
🔒	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`
🔒🔌	Creation Date	`CA10__creationDate__c`	`DateTime`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Deleted	`IsDeleted`	`Checkbox`
🔒	Deleted From Azure	`CA10__disappearanceTime__c`	`DateTime`
🔒	Deprecated: DTU	`CA10__dtu__c`	`Number(18, 0)`
🔒	Deprecated: Database DTU Max	`CA10__databaseDtuMax__c`	`Number(18, 0)`
🔒	Deprecated: Database DTU Min	`CA10__databaseDtuMin__c`	`Number(18, 0)`
🔒	Deprecated: Edition	`CA10__edition__c`	`Text(255)`
🔒	Deprecated: Storage, MB	`CA10__storageMb__c`	`Number(18, 0)`
🔒	Elastic Pool Name	`Name`	`Text(80)`
🔒	Kind	`CA10__kind__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Last Activity Date	`LastActivityDate`	`Date`
🔒	Last Modified Date	`LastModifiedDate`	`DateTime`
🔒	License Type	`CA10__licenseType__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Location Name	`CA10__locationName__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Max Size, Bytes	`CA10__maxSizeBytes__c`	`Number(18, 0)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Monitor: CPU Limit, 1-Day	`CA10__monitorCpuLimitAvg01Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Limit, 14-Day	`CA10__monitorCpuLimitAvg14Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Limit, 30-Day	`CA10__monitorCpuLimitAvg30Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Limit, 60-Day	`CA10__monitorCpuLimitAvg60Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Limit, 7-Day	`CA10__monitorCpuLimitAvg07Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Limit, 90-Day	`CA10__monitorCpuLimitAvg90Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Percent, 1-Day	`CA10__monitorCpuPercentAvg01Day__c`	`Percent(18, 2)`
🔒	Monitor: CPU Percent, 14-Day	`CA10__monitorCpuPercentAvg14Day__c`	`Percent(18, 2)`
🔒🔌	Monitor: CPU Percent, 30-Day	`CA10__monitorCpuPercentAvg30Day__c`	`Percent(18, 2)`
🔒	Monitor: CPU Percent, 60-Day	`CA10__monitorCpuPercentAvg60Day__c`	`Percent(18, 2)`
🔒	Monitor: CPU Percent, 7-Day	`CA10__monitorCpuPercentAvg07Day__c`	`Percent(18, 2)`
🔒	Monitor: CPU Percent, 90-Day	`CA10__monitorCpuPercentAvg90Day__c`	`Percent(18, 2)`
🔒	Monitor: CPU Used, 1-Day	`CA10__monitorCpuUsedAvg01Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Used, 14-Day	`CA10__monitorCpuUsedAvg14Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Used, 30-Day	`CA10__monitorCpuUsedAvg30Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Used, 60-Day	`CA10__monitorCpuUsedAvg60Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Used, 7-Day	`CA10__monitorCpuUsedAvg07Day__c`	`Number(18, 0)`
🔒	Monitor: CPU Used, 90-Day	`CA10__monitorCpuUsedAvg90Day__c`	`Number(18, 0)`
🔒	Monitor: DTU Consumption Percent, 1-Day	`CA10__monitorDtuConsumptionPercentAvg01Day__c`	`Percent(18, 2)`
🔒	Monitor: DTU Consumption Percent, 14-Day	`CA10__monitorDtuConsumptionPercentAvg14Day__c`	`Percent(18, 2)`
🔒🔌	Monitor: DTU Consumption Percent, 30-Day	`CA10__monitorDtuConsumptionPercentAvg30Day__c`	`Percent(18, 2)`
🔒	Monitor: DTU Consumption Percent, 60-Day	`CA10__monitorDtuConsumptionPercentAvg60Day__c`	`Percent(18, 2)`
🔒	Monitor: DTU Consumption Percent, 7-Day	`CA10__monitorDtuConsumptionPercentAvg07Day__c`	`Percent(18, 2)`
🔒	Monitor: DTU Consumption Percent, 90-Day	`CA10__monitorDtuConsumptionPercentAvg90Day__c`	`Percent(18, 2)`
🔒	Monitor: Data IO, Percent, 1-Day	`CA10__monitorDataIoPercentAvg01Day__c`	`Percent(18, 2)`
🔒	Monitor: Data IO, Percent, 14-Day	`CA10__monitorDataIoPercentAvg14Day__c`	`Percent(18, 2)`
🔒	Monitor: Data IO, Percent, 30-Day	`CA10__monitorDataIoPercentAvg30Day__c`	`Percent(18, 2)`
🔒	Monitor: Data IO, Percent, 60-Day	`CA10__monitorDataIoPercentAvg60Day__c`	`Percent(18, 2)`
🔒	Monitor: Data IO, Percent, 7-Day	`CA10__monitorDataIoPercentAvg07Day__c`	`Percent(18, 2)`
🔒	Monitor: Data IO, Percent, 90-Day	`CA10__monitorDataIoPercentAvg90Day__c`	`Percent(18, 2)`
🔒	Monitor: Storage Percent, 1-Day	`CA10__monitorStoragePercentAvg01Day__c`	`Percent(18, 2)`
🔒	Monitor: Storage Percent, 14-Day	`CA10__monitorStoragePercentAvg14Day__c`	`Percent(18, 2)`
🔒🔌	Monitor: Storage Percent, 30-Day	`CA10__monitorStoragePercentAvg30Day__c`	`Percent(18, 2)`
🔒	Monitor: Storage Percent, 60-Day	`CA10__monitorStoragePercentAvg60Day__c`	`Percent(18, 2)`
🔒	Monitor: Storage Percent, 7-Day	`CA10__monitorStoragePercentAvg07Day__c`	`Percent(18, 2)`
🔒	Monitor: Storage Percent, 90-Day	`CA10__monitorStoragePercentAvg90Day__c`	`Percent(18, 2)`
🔒	Monitor: Storage Used, Bytes, 1-Day	`CA10__monitorStorageUsedBytesAvg01Day__c`	`Number(18, 0)`
🔒	Monitor: Storage Used, Bytes, 14-Day	`CA10__monitorStorageUsedBytesAvg14Day__c`	`Number(18, 0)`
🔒	Monitor: Storage Used, Bytes, 30-Day	`CA10__monitorStorageUsedBytesAvg30Day__c`	`Number(18, 0)`
🔒	Monitor: Storage Used, Bytes, 60-Day	`CA10__monitorStorageUsedBytesAvg60Day__c`	`Number(18, 0)`
🔒	Monitor: Storage Used, Bytes, 7-Day	`CA10__monitorStorageUsedBytesAvg07Day__c`	`Number(18, 0)`
🔒	Monitor: Storage Used, Bytes, 90-Day	`CA10__monitorStorageUsedBytesAvg90Day__c`	`Number(18, 0)`
🔒🧮	Monitor: Storage Used, MB, 1-Day	`CA10__monitorStorageUsedMbAvg01Day__c`	`Number(18, 0)`
🔒🧮	Monitor: Storage Used, MB, 14-Day	`CA10__monitorStorageUsedMbAvg14Day__c`	`Number(18, 0)`
🔒🧮	Monitor: Storage Used, MB, 30-Day	`CA10__monitorStorageUsedMbAvg30Day__c`	`Number(18, 0)`
🔒🧮	Monitor: Storage Used, MB, 60-Day	`CA10__monitorStorageUsedMbAvg60Day__c`	`Number(18, 0)`
🔒🧮	Monitor: Storage Used, MB, 7-Day	`CA10__monitorStorageUsedMbAvg07Day__c`	`Number(18, 0)`
🔒🧮	Monitor: Storage Used, MB, 90-Day	`CA10__monitorStorageUsedMbAvg90Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Limit, 1-Day	`CA10__monitorEdtuLimitAvg01Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Limit, 14-Day	`CA10__monitorEdtuLimitAvg14Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Limit, 30-Day	`CA10__monitorEdtuLimitAvg30Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Limit, 60-Day	`CA10__monitorEdtuLimitAvg60Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Limit, 7-Day	`CA10__monitorEdtuLimitAvg07Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Limit, 90-Day	`CA10__monitorEdtuLimitAvg90Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Used, 1-Day	`CA10__monitorEdtuUsedAvg01Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Used, 14-Day	`CA10__monitorEdtuUsedAvg14Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Used, 30-Day	`CA10__monitorEdtuUsedAvg30Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Used, 60-Day	`CA10__monitorEdtuUsedAvg60Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Used, 7-Day	`CA10__monitorEdtuUsedAvg07Day__c`	`Number(18, 0)`
🔒	Monitor: eDTU Used, 90-Day	`CA10__monitorEdtuUsedAvg90Day__c`	`Number(18, 0)`
🔒	Name	`CA10__name__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Object Dimension UUID	`CA10__objectDimUuid__c`	`Text(36)`
🔒	Per Database Settings: Max Capacity	`CA10__perDatabaseSettingsMaxCapacity__c`	`Number(18, 2)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Per Database Settings: Min Capacity	`CA10__perDatabaseSettingsMinCapacity__c`	`Number(18, 2)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Record ID	`Id`	`Text`
🔒	Resource Group ID	`CA10__resourceGroupId__c`	`Text(255)`
🔒	Resource ID	`CA10__resourceId__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	SKU: Capacity	`CA10__skuCapacity__c`	`Number(18, 2)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	SKU: Family	`CA10__skuFamily__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	SKU: Name	`CA10__skuName__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	SKU: Size	`CA10__skuSize__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	SKU: Tier	`CA10__skuTier__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	SQL Server Name	`CA10__sqlServerName__c`	`Text(255)`
🔒🔌	State	`CA10__state__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	System Modstamp	`SystemModstamp`	`DateTime`
🔒	Tag Count	`CA10__tagCount__c`	`Number(18, 0)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Tags	`CA10__tags__c`	`LongTextArea(32768)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Tags JSON	`CA10__tagsJson__c`	`LongTextArea(32768)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Type	`CA10__type__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools
🔒	Zone Redundant	`CA10__zoneRedundant__c`	`Text(255)`	API Call: Microsoft.Sql/servers/elasticPools

Extracts

	Name	Extracts File
🔒	`CA10__creationDate__c`	🔌 object.extracts.yaml
🔒	`CA10__monitorCpuPercentAvg30Day__c`	🔌 object.extracts.yaml
🔒	`CA10__monitorDtuConsumptionPercentAvg30Day__c`	🔌 object.extracts.yaml
🔒	`CA10__monitorStoragePercentAvg30Day__c`	🔌 object.extracts.yaml
🔒	`CA10__state__c`	🔌 object.extracts.yaml

Lookups

	Label	API Name	Type
🔒	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 Group	`CA10__resourceGroup__c` / `CA10__resourceGroup__r`	`CA10__CaAzureResourceGroup__c`
🔒	SQL Server	`CA10__sqlServer__c` / `CA10__sqlServer__r`	📗 Azure SQL Server
🔒	Sent Connection ID	`ConnectionSentId` / `ConnectionSent`	`PartnerNetworkConnection`
🔒	Subscription	`CA10__subscription__c` / `CA10__subscription__r`	📗 Azure Subscription

	Related Type	Related List API Name	Foreign Key Field
🔒	📗 Azure SQL Database	`CA10__Azure_SQL_Databases__r`	`CA10__elasticPool__c`

Extract Files

Extract	Parent	Flags
🔌 object.extracts.yaml	📗 Azure SQL Elastic Pool

Logic Files

Logic	Policy	Flags
🧠 prod.logic.yaml🟢	🛡️ Azure SQL Elastic Pool is underutilized🟢	🟢 x3

Fields​

Extracts​

Lookups​

Related Lists​

Extract Files​

Logic Files​

Fields

Extracts

Lookups

Related Lists

Extract Files

Logic Files