Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native
  3. API Docs
  4. azurearcdata
  5. getSqlServerInstance
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
pulumi/pulumi-azure-native

azure-native.azurearcdata.getSqlServerInstance

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
pulumi/pulumi-azure-native

    Retrieves a SQL Server Instance resource Azure REST API version: 2023-01-15-preview.

    Other available API versions: 2024-01-01, 2024-05-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>
    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]
    func LookupSqlServerInstance(ctx *Context, args *LookupSqlServerInstanceArgs, opts ...InvokeOption) (*LookupSqlServerInstanceResult, error)
func LookupSqlServerInstanceOutput(ctx *Context, args *LookupSqlServerInstanceOutputArgs, opts ...InvokeOption) LookupSqlServerInstanceResultOutput

    > 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)
}
    public static CompletableFuture<GetSqlServerInstanceResult> getSqlServerInstance(GetSqlServerInstanceArgs args, InvokeOptions options)
public static Output<GetSqlServerInstanceResult> getSqlServerInstance(GetSqlServerInstanceArgs args, InvokeOptions options)

    fn::invoke:
  function: azure-native:azurearcdata:getSqlServerInstance
  arguments:
    # arguments dictionary

    The following arguments are supported:

    ResourceGroupName string
    The name of the Azure resource group
    SqlServerInstanceName string
    Name of SQL Server Instance
    ResourceGroupName string
    The name of the Azure resource group
    SqlServerInstanceName string
    Name of SQL Server Instance
    resourceGroupName String
    The name of the Azure resource group
    sqlServerInstanceName String
    Name of SQL Server Instance
    resourceGroupName string
    The name of the Azure resource group
    sqlServerInstanceName string
    Name of SQL Server Instance
    resource_group_name str
    The name of the Azure resource group
    sql_server_instance_name str
    Name of SQL Server Instance
    resourceGroupName String
    The name of the Azure resource group
    sqlServerInstanceName 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
    Azure Resource Manager metadata containing createdBy and modifiedBy information.
    Type string
    The type of the resource. E.g. "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
    Azure Resource Manager metadata containing createdBy and modifiedBy information.
    Type string
    The type of the resource. E.g. "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
    Azure Resource Manager metadata containing createdBy and modifiedBy information.
    type String
    The type of the resource. E.g. "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
    Azure Resource Manager metadata containing createdBy and modifiedBy information.
    type string
    The type of the resource. E.g. "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
    Azure Resource Manager metadata containing createdBy and modifiedBy information.
    type str
    The type of the resource. E.g. "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
    Azure Resource Manager metadata containing createdBy and modifiedBy information.
    type String
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
    tags Map<String>
    Resource tags.

    Supporting Types

    SqlServerInstancePropertiesResponse

    ContainerResourceId string
    ARM Resource id of the container resource (Azure Arc for Servers).
    CreateTime string
    The time when the resource was created.
    ProvisioningState string
    The provisioning state of the Arc-enabled SQL Server resource.
    Status string
    The cloud connectivity status.
    AzureDefenderStatus string
    Status of Azure Defender.
    AzureDefenderStatusLastUpdated string
    Timestamp of last Azure Defender status update.
    Collation string
    SQL Server collation.
    Cores string
    The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
    CurrentVersion string
    SQL Server current version.
    Edition string
    SQL Server edition.
    HostType string
    Type of host for Azure Arc SQL Server
    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 string
    ARM Resource id of the container resource (Azure Arc for Servers).
    CreateTime string
    The time when the resource was created.
    ProvisioningState string
    The provisioning state of the Arc-enabled SQL Server resource.
    Status string
    The cloud connectivity status.
    AzureDefenderStatus string
    Status of Azure Defender.
    AzureDefenderStatusLastUpdated string
    Timestamp of last Azure Defender status update.
    Collation string
    SQL Server collation.
    Cores string
    The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
    CurrentVersion string
    SQL Server current version.
    Edition string
    SQL Server edition.
    HostType string
    Type of host for Azure Arc SQL Server
    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 String
    ARM Resource id of the container resource (Azure Arc for Servers).
    createTime String
    The time when the resource was created.
    provisioningState String
    The provisioning state of the Arc-enabled SQL Server resource.
    status String
    The cloud connectivity status.
    azureDefenderStatus String
    Status of Azure Defender.
    azureDefenderStatusLastUpdated String
    Timestamp of last Azure Defender status update.
    collation String
    SQL Server collation.
    cores String
    The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
    currentVersion String
    SQL Server current version.
    edition String
    SQL Server edition.
    hostType String
    Type of host for Azure Arc SQL Server
    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 string
    ARM Resource id of the container resource (Azure Arc for Servers).
    createTime string
    The time when the resource was created.
    provisioningState string
    The provisioning state of the Arc-enabled SQL Server resource.
    status string
    The cloud connectivity status.
    azureDefenderStatus string
    Status of Azure Defender.
    azureDefenderStatusLastUpdated string
    Timestamp of last Azure Defender status update.
    collation string
    SQL Server collation.
    cores string
    The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
    currentVersion string
    SQL Server current version.
    edition string
    SQL Server edition.
    hostType string
    Type of host for Azure Arc SQL Server
    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 str
    ARM Resource id of the container resource (Azure Arc for Servers).
    create_time str
    The time when the resource was created.
    provisioning_state str
    The provisioning state of the Arc-enabled SQL Server resource.
    status str
    The cloud connectivity status.
    azure_defender_status str
    Status of Azure Defender.
    azure_defender_status_last_updated str
    Timestamp of last Azure Defender status update.
    collation str
    SQL Server collation.
    cores str
    The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
    current_version str
    SQL Server current version.
    edition str
    SQL Server edition.
    host_type str
    Type of host for Azure Arc SQL Server
    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 String
    ARM Resource id of the container resource (Azure Arc for Servers).
    createTime String
    The time when the resource was created.
    provisioningState String
    The provisioning state of the Arc-enabled SQL Server resource.
    status String
    The cloud connectivity status.
    azureDefenderStatus String
    Status of Azure Defender.
    azureDefenderStatusLastUpdated String
    Timestamp of last Azure Defender status update.
    collation String
    SQL Server collation.
    cores String
    The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
    currentVersion String
    SQL Server current version.
    edition String
    SQL Server edition.
    hostType String
    Type of host for Azure Arc SQL Server
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    The identity that last modified the resource.
    lastModifiedByType String
    The type of identity that last modified the resource.

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
    pulumi/pulumi-azure-native