Skip to main content

Repository

📗 Azure SQL Managed Instance

  • ID: /types/CA10Z1__CaAzureSqlManagedInstance__c

Fields

LabelAPI NameTypeHelp
🔒Administrator LoginCA10Z1__administratorLogin__cText(255)API Call: Microsoft.Sql/managedInstances
🔒🧮ApplicationCA10Z1__application__cText(1300)
🔒Application Tier Api NameCA10Z1__applicationTierApiName__cText(255)
🔒Application Tier Cascade AttachCA10Z1__applicationTierCascadeAttach__cCheckbox
🔒Application Tier Client NameCA10Z1__applicationTierClientName__cText(255)
🔒Application Tier Parent TypeCA10Z1__applicationTierParentType__cText(255)
🔒Application Tier Parent UUIDCA10Z1__applicationTierParentUuid__cText(255)
🔒Application Tier Unique NameCA10Z1__applicationTierUniqueName__cText(255)
🔒CloudAware UUIDCA10Z1__caUuid__cText(36)
🔒CollationCA10Z1__collation__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Create ModeCA10Z1__createMode__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Created DateCreatedDateDateTime
🔒DNS ZoneCA10Z1__dnsZone__cText(255)API Call: Microsoft.Sql/managedInstances
🔒DNS Zone PartnerCA10Z1__dnsZonePartner__cText(255)API Call: Microsoft.Sql/managedInstances
🔒DeletedIsDeletedCheckbox
🔒Deleted From AzureCA10Z1__disappearanceTime__cDateTime
🔒FQDNCA10Z1__fqdn__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Instance NameNameText(80)API Call: Microsoft.Sql/managedInstances
🔒Instance Pool IDCA10Z1__instancePoolId__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Last Modified DateLastModifiedDateDateTime
🔒License TypeCA10Z1__licenseType__cText(255)API Call: Microsoft.Sql/managedInstances
🔒🔌Location NameCA10Z1__locationName__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Maintenance Configuration IDCA10Z1__maintenanceConfigurationId__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Minimal TLS VersionCA10Z1__minimalTlsVersion__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Monitor: Average CPU Percent, 1-DayCA10Z1__monitorCpuPercentAvg01Day__cPercent(18, 2)
🔒Monitor: Average CPU Percent, 14-DayCA10Z1__monitorCpuPercentAvg14Day__cPercent(18, 2)
🔒🔌Monitor: Average CPU Percent, 30-DayCA10Z1__monitorCpuPercentAvg30Day__cPercent(18, 2)
🔒Monitor: Average CPU Percent, 60-DayCA10Z1__monitorCpuPercentAvg60Day__cPercent(18, 2)
🔒Monitor: Average CPU Percent, 7-DayCA10Z1__monitorCpuPercentAvg07Day__cPercent(18, 2)
🔒Monitor: Average CPU Percent, 90-DayCA10Z1__monitorCpuPercentAvg90Day__cPercent(18, 2)
🔒Monitor: IO Read, Bytes, 1-DayCA10Z1__monitorIoReadBytesAvg01Day__cNumber(18, 0)
🔒Monitor: IO Read, Bytes, 14-DayCA10Z1__monitorIoReadBytesAvg14Day__cNumber(18, 0)
🔒Monitor: IO Read, Bytes, 30-DayCA10Z1__monitorIoReadBytesAvg30Day__cNumber(18, 0)
🔒Monitor: IO Read, Bytes, 60-DayCA10Z1__monitorIoReadBytesAvg60Day__cNumber(18, 0)
🔒Monitor: IO Read, Bytes, 7-DayCA10Z1__monitorIoReadBytesAvg07Day__cNumber(18, 0)
🔒Monitor: IO Read, Bytes, 90-DayCA10Z1__monitorIoReadBytesAvg90Day__cNumber(18, 0)
🔒🧮Monitor: IO Read, MB, 1-DayCA10Z1__monitorIoReadMbAvg01Day__cNumber(18, 0)
🔒🧮Monitor: IO Read, MB, 14-DayCA10Z1__monitorIoReadMbAvg14Day__cNumber(18, 0)
🔒🧮🔌Monitor: IO Read, MB, 30-DayCA10Z1__monitorIoReadMbAvg30Day__cNumber(18, 0)
🔒🧮Monitor: IO Read, MB, 60-DayCA10Z1__monitorIoReadMbAvg60Day__cNumber(18, 0)
🔒🧮Monitor: IO Read, MB, 7-DayCA10Z1__monitorIoReadMbAvg07Day__cNumber(18, 0)
🔒🧮Monitor: IO Read, MB, 90-DayCA10Z1__monitorIoReadMbAvg90Day__cNumber(18, 0)
🔒Monitor: IO Written, Bytes, 1-DayCA10Z1__monitorIoWrittenBytesAvg01Day__cNumber(18, 0)
🔒Monitor: IO Written, Bytes, 14-DayCA10Z1__monitorIoWrittenBytesAvg14Day__cNumber(18, 0)
🔒Monitor: IO Written, Bytes, 30-DayCA10Z1__monitorIoWrittenBytesAvg30Day__cNumber(18, 0)
🔒Monitor: IO Written, Bytes, 60-DayCA10Z1__monitorIoWrittenBytesAvg60Day__cNumber(18, 0)
🔒Monitor: IO Written, Bytes, 7-DayCA10Z1__monitorIoWrittenBytesAvg07Day__cNumber(18, 0)
🔒Monitor: IO Written, Bytes, 90-DayCA10Z1__monitorIoWrittenBytesAvg90Day__cNumber(18, 0)
🔒🧮Monitor: IO Written, MB, 1-DayCA10Z1__monitorIoWrittenMbAvg01Day__cNumber(18, 0)
🔒🧮Monitor: IO Written, MB, 14-DayCA10Z1__monitorIoWrittenMbAvg14Day__cNumber(18, 0)
🔒🧮🔌Monitor: IO Written, MB, 30-DayCA10Z1__monitorIoWrittenMbAvg30Day__cNumber(18, 0)
🔒🧮Monitor: IO Written, MB, 60-DayCA10Z1__monitorIoWrittenMbAvg60Day__cNumber(18, 0)
🔒🧮Monitor: IO Written, MB, 7-DayCA10Z1__monitorIoWrittenMbAvg07Day__cNumber(18, 0)
🔒🧮Monitor: IO Written, MB, 90-DayCA10Z1__monitorIoWrittenMbAvg90Day__cNumber(18, 0)
🔒Monitor: Storage Space Used, MB, 1-DayCA10Z1__monitorStorageSpaceUsedMbAvg01Day__cNumber(18, 0)
🔒Monitor: Storage Space Used, MB, 14-DayCA10Z1__monitorStorageSpaceUsedMbAvg14Day__cNumber(18, 0)
🔒Monitor: Storage Space Used, MB, 30-DayCA10Z1__monitorStorageSpaceUsedMbAvg30Day__cNumber(18, 0)
🔒Monitor: Storage Space Used, MB, 60-DayCA10Z1__monitorStorageSpaceUsedMbAvg60Day__cNumber(18, 0)
🔒Monitor: Storage Space Used, MB, 7-DayCA10Z1__monitorStorageSpaceUsedMbAvg07Day__cNumber(18, 0)
🔒Monitor: Storage Space Used, MB, 90-DayCA10Z1__monitorStorageSpaceUsedMbAvg90Day__cNumber(18, 0)
🔒NameCA10Z1__name__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Proxy OverrideCA10Z1__proxyOverride__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Public Data EndpointCA10Z1__publicDataEndpoint__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Record IDIdText
🔒Resource Group IDCA10Z1__resourceGroupId__cText(255)
🔒Resource IDCA10Z1__resourceId__cText(255)
🔒Restore Point In TimeCA10Z1__restorePointInTime__cDateTimeAPI Call: Microsoft.Sql/managedInstances
🔒Sku: CapacityCA10Z1__skuCapacity__cNumber(18, 0)API Call: Microsoft.Sql/managedInstances
🔒Sku: FamilyCA10Z1__skuFamily__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Sku: NameCA10Z1__skuName__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Sku: TierCA10Z1__skuTier__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Source Managed Instance IDCA10Z1__sourceManagedInstanceId__cText(255)API Call: Microsoft.Sql/managedInstances
🔒🔌StateCA10Z1__state__cText(255)API Call: Microsoft.Sql/managedInstances
🔒Storage Size, GbCA10Z1__storageSizeGb__cNumber(18, 0)API Call: Microsoft.Sql/managedInstances
🔒Subnet IDCA10Z1__subnetId__cText(255)API Call: Microsoft.Sql/managedInstances
🔒System ModstampSystemModstampDateTime
🔒Tag CountCA10Z1__tagCount__cNumber(18, 0)API Call: Microsoft.Sql/managedInstances
🔒TagsCA10Z1__tags__cLongTextArea(131072)API Call: Microsoft.Sql/managedInstances
🔒Tags JSONCA10Z1__tagsJson__cLongTextArea(131072)API Call: Microsoft.Sql/managedInstances
🔒TimezoneCA10Z1__timezone__cText(255)API Call: Microsoft.Sql/managedInstances
🔒vCoresCA10Z1__vCores__cNumber(18, 0)API Call: Microsoft.Sql/managedInstances

Extracts

NameExtracts File
🔒CA10Z1__locationName__c🔌 object.extracts.yaml
🔒CA10Z1__monitorCpuPercentAvg30Day__c🔌 object.extracts.yaml
🔒CA10Z1__monitorIoReadMbAvg30Day__c🔌 object.extracts.yaml
🔒CA10Z1__monitorIoWrittenMbAvg30Day__c🔌 object.extracts.yaml
🔒CA10Z1__state__c🔌 object.extracts.yaml

Lookups

LabelAPI NameType
🔒Application TierCA10Z1__applicationTier__c / CA10Z1__applicationTier__rCA10__CaApplicationTier__c
🔒Created By IDCreatedById / CreatedByUser
🔒Instance PoolCA10Z1__instancePool__c / CA10Z1__instancePool__rCA10Z1__CaAzureSqlManagedInstancePool__c
🔒Last Modified By IDLastModifiedById / LastModifiedByUser
🔒Received Connection IDConnectionReceivedId / ConnectionReceivedPartnerNetworkConnection
🔒Record Type IDRecordTypeId / RecordTypeRecordType
🔒Resource GroupCA10Z1__resourceGroup__c / CA10Z1__resourceGroup__rCA10__CaAzureResourceGroup__c
🔒Sent Connection IDConnectionSentId / ConnectionSentPartnerNetworkConnection
🔒Source Managed InstanceCA10Z1__sourceManagedInstance__c / CA10Z1__sourceManagedInstance__r📗 Azure SQL Managed Instance
🔒SubnetCA10Z1__subnet__c / CA10Z1__subnet__rCA10__CaAzureNetworkSubnet__c
🔒SubscriptionCA10Z1__subscription__c / CA10Z1__subscription__r📗 Azure Subscription
Related TypeRelated List API NameForeign Key Field
🔒📗 Azure SQL Managed InstanceCA10Z1__Azure_SQL_Managed_Instances__rCA10Z1__sourceManagedInstance__c

Extract Files

ExtractParentFlags
🔌 object.extracts.yaml📗 Azure SQL Managed Instance

Logic Files

LogicPolicyFlags
🧠 prod.logic.yaml🟢🛡️ Azure SQL Managed Instance is located in a less cost-effective region🟢🟢 x3
🧠 prod.logic.yaml🟢🛡️ Azure SQL Managed Instance is underutilized🟢🟢 x3