GetManagedInstanceResult

Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).

The Azure Active Directory administrator of the instance. This can only be used at instance create time. If used for instance update, it will be ignored or it will result in an error. For updates individual APIs will need to be used.

The managed instance's authentication metadata lookup mode.

The Azure API version of the resource.

Collation of the managed instance.

Specifies the point in time (ISO8601 format) of the Managed Instance creation.

The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)

Specifies the internal format of instance databases specific to the SQL engine version.

The Dns Zone that the managed instance is in.

Status of external governance.

The fully qualified domain name of the managed instance.

Hybrid secondary usage. Possible values are 'Active' (default value) and 'Passive' (customer uses the secondary as Passive DR).

Hybrid secondary usage detected. Possible values are 'Active' (customer does not meet the requirements to use the secondary as Passive DR) and 'Passive' (customer meets the requirements to use the secondary as Passive DR).

Resource ID.

The Azure Active Directory identity of the managed instance.

The Id of the instance pool this managed server belongs to.

Whether or not this is a GPv2 variant of General Purpose edition.

A CMK URI of the key to use for encryption.

The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).

Resource location.

Specifies maintenance configuration id to apply to this managed instance.

Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'

Resource name.

Pricing model of Managed Instance.

The resource id of a user assigned identity to be used by default.

List of private endpoint connections on a managed instance.

Provisioning state of managed instance.

Connection type used for connecting to the instance.

Whether or not the public data endpoint is enabled.

The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)

The managed instance's service principal.

Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH

The state of the managed instance.

Storage IOps. Minimum value: 300. Maximum value: 80000. Increments of 1 IOps allowed only. Maximum value depends on the selected hardware family and number of vCores.

Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.

Storage throughput MBps parameter is not supported in the instance create/update operation.

Subnet resource ID for the managed instance.

Resource tags.

Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing System.TimeZoneInfo::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".

Resource type.

The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.

Virtual cluster resource id for the Managed Instance.

Whether or not the multi-az is enabled.