Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native v1
  3. API Docs
  4. azurearcdata
  5. getSqlServerInstance
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

azure-native.azurearcdata.getSqlServerInstance

Explore with Pulumi AI

These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

Retrieves a SQL Server Instance resource API Version: 2021-06-01-preview.

Using getSqlServerInstance

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getSqlServerInstance(args: GetSqlServerInstanceArgs, opts?: InvokeOptions): Promise<GetSqlServerInstanceResult>
function getSqlServerInstanceOutput(args: GetSqlServerInstanceOutputArgs, opts?: InvokeOptions): Output<GetSqlServerInstanceResult>
Copy
def get_sql_server_instance(resource_group_name: Optional[str] = None,
                            sql_server_instance_name: Optional[str] = None,
                            opts: Optional[InvokeOptions] = None) -> GetSqlServerInstanceResult
def get_sql_server_instance_output(resource_group_name: Optional[pulumi.Input[str]] = None,
                            sql_server_instance_name: Optional[pulumi.Input[str]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetSqlServerInstanceResult]
Copy
func LookupSqlServerInstance(ctx *Context, args *LookupSqlServerInstanceArgs, opts ...InvokeOption) (*LookupSqlServerInstanceResult, error)
func LookupSqlServerInstanceOutput(ctx *Context, args *LookupSqlServerInstanceOutputArgs, opts ...InvokeOption) LookupSqlServerInstanceResultOutput
Copy

> Note: This function is named LookupSqlServerInstance in the Go SDK.

public static class GetSqlServerInstance 
{
    public static Task<GetSqlServerInstanceResult> InvokeAsync(GetSqlServerInstanceArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlServerInstanceResult> Invoke(GetSqlServerInstanceInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetSqlServerInstanceResult> getSqlServerInstance(GetSqlServerInstanceArgs args, InvokeOptions options)
public static Output<GetSqlServerInstanceResult> getSqlServerInstance(GetSqlServerInstanceArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: azure-native:azurearcdata:getSqlServerInstance
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ResourceGroupName
This property is required.
Changes to this property will trigger replacement.
string
The name of the Azure resource group
SqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
string
Name of SQL Server Instance
ResourceGroupName
This property is required.
Changes to this property will trigger replacement.
string
The name of the Azure resource group
SqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
string
Name of SQL Server Instance
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
String
The name of the Azure resource group
sqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
String
Name of SQL Server Instance
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
string
The name of the Azure resource group
sqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
string
Name of SQL Server Instance
resource_group_name
This property is required.
Changes to this property will trigger replacement.
str
The name of the Azure resource group
sql_server_instance_name
This property is required.
Changes to this property will trigger replacement.
str
Name of SQL Server Instance
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
String
The name of the Azure resource group
sqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
String
Name of SQL Server Instance

getSqlServerInstance Result

The following output properties are available:

Id string
Fully qualified resource Id for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
Location string
The geo-location where the resource lives
Name string
The name of the resource
Properties Pulumi.AzureNative.AzureArcData.Outputs.SqlServerInstancePropertiesResponse
null
SystemData Pulumi.AzureNative.AzureArcData.Outputs.SystemDataResponse
Read only system data
Type string
The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.
Tags Dictionary<string, string>
Resource tags.
Id string
Fully qualified resource Id for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
Location string
The geo-location where the resource lives
Name string
The name of the resource
Properties SqlServerInstancePropertiesResponse
null
SystemData SystemDataResponse
Read only system data
Type string
The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.
Tags map[string]string
Resource tags.
id String
Fully qualified resource Id for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location String
The geo-location where the resource lives
name String
The name of the resource
properties SqlServerInstancePropertiesResponse
null
systemData SystemDataResponse
Read only system data
type String
The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.
tags Map<String,String>
Resource tags.
id string
Fully qualified resource Id for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location string
The geo-location where the resource lives
name string
The name of the resource
properties SqlServerInstancePropertiesResponse
null
systemData SystemDataResponse
Read only system data
type string
The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.
tags {[key: string]: string}
Resource tags.
id str
Fully qualified resource Id for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location str
The geo-location where the resource lives
name str
The name of the resource
properties SqlServerInstancePropertiesResponse
null
system_data SystemDataResponse
Read only system data
type str
The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.
tags Mapping[str, str]
Resource tags.
id String
Fully qualified resource Id for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location String
The geo-location where the resource lives
name String
The name of the resource
properties Property Map
null
systemData Property Map
Read only system data
type String
The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.
tags Map<String>
Resource tags.

Supporting Types

SqlServerInstancePropertiesResponse

ContainerResourceId This property is required. string
ARM Resource id of the container resource (Azure Arc for Servers).
CreateTime This property is required. string
The time when the resource was created.
ProvisioningState This property is required. string
Status This property is required. string
The cloud connectivity status.
Collation string
SQL Server collation.
CurrentVersion string
SQL Server current version.
Edition string
SQL Server edition.
InstanceName string
SQL Server instance name.
LicenseType string
SQL Server license type.
PatchLevel string
SQL Server update level.
ProductId string
SQL Server product ID.
TcpDynamicPorts string
Dynamic TCP ports used by SQL Server.
TcpStaticPorts string
Static TCP ports used by SQL Server.
VCore string
The number of logical processors used by the SQL Server instance.
Version string
SQL Server version.
ContainerResourceId This property is required. string
ARM Resource id of the container resource (Azure Arc for Servers).
CreateTime This property is required. string
The time when the resource was created.
ProvisioningState This property is required. string
Status This property is required. string
The cloud connectivity status.
Collation string
SQL Server collation.
CurrentVersion string
SQL Server current version.
Edition string
SQL Server edition.
InstanceName string
SQL Server instance name.
LicenseType string
SQL Server license type.
PatchLevel string
SQL Server update level.
ProductId string
SQL Server product ID.
TcpDynamicPorts string
Dynamic TCP ports used by SQL Server.
TcpStaticPorts string
Static TCP ports used by SQL Server.
VCore string
The number of logical processors used by the SQL Server instance.
Version string
SQL Server version.
containerResourceId This property is required. String
ARM Resource id of the container resource (Azure Arc for Servers).
createTime This property is required. String
The time when the resource was created.
provisioningState This property is required. String
status This property is required. String
The cloud connectivity status.
collation String
SQL Server collation.
currentVersion String
SQL Server current version.
edition String
SQL Server edition.
instanceName String
SQL Server instance name.
licenseType String
SQL Server license type.
patchLevel String
SQL Server update level.
productId String
SQL Server product ID.
tcpDynamicPorts String
Dynamic TCP ports used by SQL Server.
tcpStaticPorts String
Static TCP ports used by SQL Server.
vCore String
The number of logical processors used by the SQL Server instance.
version String
SQL Server version.
containerResourceId This property is required. string
ARM Resource id of the container resource (Azure Arc for Servers).
createTime This property is required. string
The time when the resource was created.
provisioningState This property is required. string
status This property is required. string
The cloud connectivity status.
collation string
SQL Server collation.
currentVersion string
SQL Server current version.
edition string
SQL Server edition.
instanceName string
SQL Server instance name.
licenseType string
SQL Server license type.
patchLevel string
SQL Server update level.
productId string
SQL Server product ID.
tcpDynamicPorts string
Dynamic TCP ports used by SQL Server.
tcpStaticPorts string
Static TCP ports used by SQL Server.
vCore string
The number of logical processors used by the SQL Server instance.
version string
SQL Server version.
container_resource_id This property is required. str
ARM Resource id of the container resource (Azure Arc for Servers).
create_time This property is required. str
The time when the resource was created.
provisioning_state This property is required. str
status This property is required. str
The cloud connectivity status.
collation str
SQL Server collation.
current_version str
SQL Server current version.
edition str
SQL Server edition.
instance_name str
SQL Server instance name.
license_type str
SQL Server license type.
patch_level str
SQL Server update level.
product_id str
SQL Server product ID.
tcp_dynamic_ports str
Dynamic TCP ports used by SQL Server.
tcp_static_ports str
Static TCP ports used by SQL Server.
v_core str
The number of logical processors used by the SQL Server instance.
version str
SQL Server version.
containerResourceId This property is required. String
ARM Resource id of the container resource (Azure Arc for Servers).
createTime This property is required. String
The time when the resource was created.
provisioningState This property is required. String
status This property is required. String
The cloud connectivity status.
collation String
SQL Server collation.
currentVersion String
SQL Server current version.
edition String
SQL Server edition.
instanceName String
SQL Server instance name.
licenseType String
SQL Server license type.
patchLevel String
SQL Server update level.
productId String
SQL Server product ID.
tcpDynamicPorts String
Dynamic TCP ports used by SQL Server.
tcpStaticPorts String
Static TCP ports used by SQL Server.
vCore String
The number of logical processors used by the SQL Server instance.
version String
SQL Server version.

SystemDataResponse

CreatedAt string
The timestamp of resource creation (UTC)
CreatedBy string
An identifier for the identity that created the resource
CreatedByType string
The type of identity that created the resource
LastModifiedAt string
The timestamp of resource last modification (UTC)
LastModifiedBy string
An identifier for the identity that last modified the resource
LastModifiedByType string
The type of identity that last modified the resource
CreatedAt string
The timestamp of resource creation (UTC)
CreatedBy string
An identifier for the identity that created the resource
CreatedByType string
The type of identity that created the resource
LastModifiedAt string
The timestamp of resource last modification (UTC)
LastModifiedBy string
An identifier for the identity that last modified the resource
LastModifiedByType string
The type of identity that last modified the resource
createdAt String
The timestamp of resource creation (UTC)
createdBy String
An identifier for the identity that created the resource
createdByType String
The type of identity that created the resource
lastModifiedAt String
The timestamp of resource last modification (UTC)
lastModifiedBy String
An identifier for the identity that last modified the resource
lastModifiedByType String
The type of identity that last modified the resource
createdAt string
The timestamp of resource creation (UTC)
createdBy string
An identifier for the identity that created the resource
createdByType string
The type of identity that created the resource
lastModifiedAt string
The timestamp of resource last modification (UTC)
lastModifiedBy string
An identifier for the identity that last modified the resource
lastModifiedByType string
The type of identity that last modified the resource
created_at str
The timestamp of resource creation (UTC)
created_by str
An identifier for the identity that created the resource
created_by_type str
The type of identity that created the resource
last_modified_at str
The timestamp of resource last modification (UTC)
last_modified_by str
An identifier for the identity that last modified the resource
last_modified_by_type str
The type of identity that last modified the resource
createdAt String
The timestamp of resource creation (UTC)
createdBy String
An identifier for the identity that created the resource
createdByType String
The type of identity that created the resource
lastModifiedAt String
The timestamp of resource last modification (UTC)
lastModifiedBy String
An identifier for the identity that last modified the resource
lastModifiedByType String
The type of identity that last modified the resource

Package Details

Repository
azure-native-v1 pulumi/pulumi-azure-native
License
Apache-2.0
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native