tencentcloud 1.82.34 published on Wednesday, Nov 5, 2025 by tencentcloudstack
tencentcloud.getSqlserverBasicInstances
Start a Neo task
Explain and create a tencentcloud.getSqlserverBasicInstances resource
tencentcloud 1.82.34 published on Wednesday, Nov 5, 2025 by tencentcloudstack
Use this data source to query SQL Server basic instances
Example Usage
Filter instance by Id
import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";
const exampleId = tencentcloud.getSqlserverBasicInstances({
id: "mssql-3l3fgqn7",
});
import pulumi
import pulumi_tencentcloud as tencentcloud
example_id = tencentcloud.get_sqlserver_basic_instances(id="mssql-3l3fgqn7")
package main
import (
"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := tencentcloud.GetSqlserverBasicInstances(ctx, &tencentcloud.GetSqlserverBasicInstancesArgs{
Id: pulumi.StringRef("mssql-3l3fgqn7"),
}, nil)
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;
return await Deployment.RunAsync(() =>
{
var exampleId = Tencentcloud.GetSqlserverBasicInstances.Invoke(new()
{
Id = "mssql-3l3fgqn7",
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetSqlserverBasicInstancesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var exampleId = TencentcloudFunctions.getSqlserverBasicInstances(GetSqlserverBasicInstancesArgs.builder()
.id("mssql-3l3fgqn7")
.build());
}
}
variables:
exampleId:
fn::invoke:
function: tencentcloud:getSqlserverBasicInstances
arguments:
id: mssql-3l3fgqn7
Filter instance by project Id
import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";
const exampleProject = tencentcloud.getSqlserverBasicInstances({
projectId: 0,
});
import pulumi
import pulumi_tencentcloud as tencentcloud
example_project = tencentcloud.get_sqlserver_basic_instances(project_id=0)
package main
import (
"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := tencentcloud.GetSqlserverBasicInstances(ctx, &tencentcloud.GetSqlserverBasicInstancesArgs{
ProjectId: pulumi.Float64Ref(0),
}, nil)
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;
return await Deployment.RunAsync(() =>
{
var exampleProject = Tencentcloud.GetSqlserverBasicInstances.Invoke(new()
{
ProjectId = 0,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetSqlserverBasicInstancesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var exampleProject = TencentcloudFunctions.getSqlserverBasicInstances(GetSqlserverBasicInstancesArgs.builder()
.projectId(0)
.build());
}
}
variables:
exampleProject:
fn::invoke:
function: tencentcloud:getSqlserverBasicInstances
arguments:
projectId: 0
Filter instance by VPC/Subnet
import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";
const exampleVpc = tencentcloud.getSqlserverBasicInstances({
vpcId: "vpc-409mvdvv",
subnetId: "subnet-nf9n81ps",
});
import pulumi
import pulumi_tencentcloud as tencentcloud
example_vpc = tencentcloud.get_sqlserver_basic_instances(vpc_id="vpc-409mvdvv",
subnet_id="subnet-nf9n81ps")
package main
import (
"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := tencentcloud.GetSqlserverBasicInstances(ctx, &tencentcloud.GetSqlserverBasicInstancesArgs{
VpcId: pulumi.StringRef("vpc-409mvdvv"),
SubnetId: pulumi.StringRef("subnet-nf9n81ps"),
}, nil)
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;
return await Deployment.RunAsync(() =>
{
var exampleVpc = Tencentcloud.GetSqlserverBasicInstances.Invoke(new()
{
VpcId = "vpc-409mvdvv",
SubnetId = "subnet-nf9n81ps",
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetSqlserverBasicInstancesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var exampleVpc = TencentcloudFunctions.getSqlserverBasicInstances(GetSqlserverBasicInstancesArgs.builder()
.vpcId("vpc-409mvdvv")
.subnetId("subnet-nf9n81ps")
.build());
}
}
variables:
exampleVpc:
fn::invoke:
function: tencentcloud:getSqlserverBasicInstances
arguments:
vpcId: vpc-409mvdvv
subnetId: subnet-nf9n81ps
Using getSqlserverBasicInstances
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 getSqlserverBasicInstances(args: GetSqlserverBasicInstancesArgs, opts?: InvokeOptions): Promise<GetSqlserverBasicInstancesResult>
function getSqlserverBasicInstancesOutput(args: GetSqlserverBasicInstancesOutputArgs, opts?: InvokeOptions): Output<GetSqlserverBasicInstancesResult>def get_sqlserver_basic_instances(id: Optional[str] = None,
name: Optional[str] = None,
project_id: Optional[float] = None,
result_output_file: Optional[str] = None,
subnet_id: Optional[str] = None,
vpc_id: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetSqlserverBasicInstancesResult
def get_sqlserver_basic_instances_output(id: Optional[pulumi.Input[str]] = None,
name: Optional[pulumi.Input[str]] = None,
project_id: Optional[pulumi.Input[float]] = None,
result_output_file: Optional[pulumi.Input[str]] = None,
subnet_id: Optional[pulumi.Input[str]] = None,
vpc_id: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetSqlserverBasicInstancesResult]func GetSqlserverBasicInstances(ctx *Context, args *GetSqlserverBasicInstancesArgs, opts ...InvokeOption) (*GetSqlserverBasicInstancesResult, error)
func GetSqlserverBasicInstancesOutput(ctx *Context, args *GetSqlserverBasicInstancesOutputArgs, opts ...InvokeOption) GetSqlserverBasicInstancesResultOutput> Note: This function is named GetSqlserverBasicInstances in the Go SDK.
public static class GetSqlserverBasicInstances
{
public static Task<GetSqlserverBasicInstancesResult> InvokeAsync(GetSqlserverBasicInstancesArgs args, InvokeOptions? opts = null)
public static Output<GetSqlserverBasicInstancesResult> Invoke(GetSqlserverBasicInstancesInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetSqlserverBasicInstancesResult> getSqlserverBasicInstances(GetSqlserverBasicInstancesArgs args, InvokeOptions options)
public static Output<GetSqlserverBasicInstancesResult> getSqlserverBasicInstances(GetSqlserverBasicInstancesArgs args, InvokeOptions options)
fn::invoke:
function: tencentcloud:index/getSqlserverBasicInstances:getSqlserverBasicInstances
arguments:
# arguments dictionaryThe following arguments are supported:
- Id string
- ID of the SQL Server basic instance to be query.
- Name string
- Name of the SQL Server basic instance to be query.
- Project
Id double - Project ID of the SQL Server basic instance to be query.
- Result
Output stringFile - Used to save results.
- Subnet
Id string - Subnet ID of the SQL Server basic instance to be query.
- Vpc
Id string - Vpc ID of the SQL Server basic instance to be query.
- Id string
- ID of the SQL Server basic instance to be query.
- Name string
- Name of the SQL Server basic instance to be query.
- Project
Id float64 - Project ID of the SQL Server basic instance to be query.
- Result
Output stringFile - Used to save results.
- Subnet
Id string - Subnet ID of the SQL Server basic instance to be query.
- Vpc
Id string - Vpc ID of the SQL Server basic instance to be query.
- id String
- ID of the SQL Server basic instance to be query.
- name String
- Name of the SQL Server basic instance to be query.
- project
Id Double - Project ID of the SQL Server basic instance to be query.
- result
Output StringFile - Used to save results.
- subnet
Id String - Subnet ID of the SQL Server basic instance to be query.
- vpc
Id String - Vpc ID of the SQL Server basic instance to be query.
- id string
- ID of the SQL Server basic instance to be query.
- name string
- Name of the SQL Server basic instance to be query.
- project
Id number - Project ID of the SQL Server basic instance to be query.
- result
Output stringFile - Used to save results.
- subnet
Id string - Subnet ID of the SQL Server basic instance to be query.
- vpc
Id string - Vpc ID of the SQL Server basic instance to be query.
- id str
- ID of the SQL Server basic instance to be query.
- name str
- Name of the SQL Server basic instance to be query.
- project_
id float - Project ID of the SQL Server basic instance to be query.
- result_
output_ strfile - Used to save results.
- subnet_
id str - Subnet ID of the SQL Server basic instance to be query.
- vpc_
id str - Vpc ID of the SQL Server basic instance to be query.
- id String
- ID of the SQL Server basic instance to be query.
- name String
- Name of the SQL Server basic instance to be query.
- project
Id Number - Project ID of the SQL Server basic instance to be query.
- result
Output StringFile - Used to save results.
- subnet
Id String - Subnet ID of the SQL Server basic instance to be query.
- vpc
Id String - Vpc ID of the SQL Server basic instance to be query.
getSqlserverBasicInstances Result
The following output properties are available:
- Instance
Lists List<GetSqlserver Basic Instances Instance List> - A list of SQL Server basic instances. Each element contains the following attributes.
- Id string
- ID of the SQL Server basic instance.
- Name string
- Name of the SQL Server basic instance.
- Project
Id double - Project ID, default value is
0. - Result
Output stringFile - Subnet
Id string - ID of subnet.
- Vpc
Id string - ID of VPC.
- Instance
Lists []GetSqlserver Basic Instances Instance List - A list of SQL Server basic instances. Each element contains the following attributes.
- Id string
- ID of the SQL Server basic instance.
- Name string
- Name of the SQL Server basic instance.
- Project
Id float64 - Project ID, default value is
0. - Result
Output stringFile - Subnet
Id string - ID of subnet.
- Vpc
Id string - ID of VPC.
- instance
Lists List<GetSqlserver Basic Instances Instance List> - A list of SQL Server basic instances. Each element contains the following attributes.
- id String
- ID of the SQL Server basic instance.
- name String
- Name of the SQL Server basic instance.
- project
Id Double - Project ID, default value is
0. - result
Output StringFile - subnet
Id String - ID of subnet.
- vpc
Id String - ID of VPC.
- instance
Lists GetSqlserver Basic Instances Instance List[] - A list of SQL Server basic instances. Each element contains the following attributes.
- id string
- ID of the SQL Server basic instance.
- name string
- Name of the SQL Server basic instance.
- project
Id number - Project ID, default value is
0. - result
Output stringFile - subnet
Id string - ID of subnet.
- vpc
Id string - ID of VPC.
- instance_
lists Sequence[GetSqlserver Basic Instances Instance List] - A list of SQL Server basic instances. Each element contains the following attributes.
- id str
- ID of the SQL Server basic instance.
- name str
- Name of the SQL Server basic instance.
- project_
id float - Project ID, default value is
0. - result_
output_ strfile - subnet_
id str - ID of subnet.
- vpc_
id str - ID of VPC.
- instance
Lists List<Property Map> - A list of SQL Server basic instances. Each element contains the following attributes.
- id String
- ID of the SQL Server basic instance.
- name String
- Name of the SQL Server basic instance.
- project
Id Number - Project ID, default value is
0. - result
Output StringFile - subnet
Id String - ID of subnet.
- vpc
Id String - ID of VPC.
Supporting Types
GetSqlserverBasicInstancesInstanceList
- Availability
Zone string - Availability zone.
- Charge
Type string - Pay type of the SQL Server basic instance. For now, only
POSTPAID_BY_HOURis valid. - Cpu double
- The CPU number of the SQL Server basic instance.
- Create
Time string - Create time of the SQL Server basic instance.
- Engine
Version string - Version of the SQL Server basic database engine. Allowed values are
2008R2(SQL Server 2008 Enterprise),2012SP3(SQL Server 2012 Enterprise),2016SP1(SQL Server 2016 Enterprise),201602(SQL Server 2016 Standard) and2017(SQL Server 2017 Enterprise). Default is2008R2. - Id string
- ID of the SQL Server basic instance to be query.
- Memory double
- Memory size (in GB). Allowed value must be larger than
memorythat data sourcetencentcloud_sqlserver_specinfosprovides. - Name string
- Name of the SQL Server basic instance to be query.
- Project
Id double - Project ID of the SQL Server basic instance to be query.
- Status double
- Status of the SQL Server basic instance.
1for applying,2for running,3for running with limit,4for isolated,5for recycling,6for recycled,7for running with task,8for off-line,9for expanding,10for migrating,11for readonly,12for rebooting. - Storage double
- Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of
storage_minandstorage_maxwhich data sourcetencentcloud_sqlserver_specinfosprovides. - Subnet
Id string - Subnet ID of the SQL Server basic instance to be query.
- Dictionary<string, string>
- Tags of the SQL Server basic instance.
- Used
Storage double - Used storage.
- Vip string
- IP for private access.
- Vpc
Id string - Vpc ID of the SQL Server basic instance to be query.
- Vport double
- Port for private access.
- Availability
Zone string - Availability zone.
- Charge
Type string - Pay type of the SQL Server basic instance. For now, only
POSTPAID_BY_HOURis valid. - Cpu float64
- The CPU number of the SQL Server basic instance.
- Create
Time string - Create time of the SQL Server basic instance.
- Engine
Version string - Version of the SQL Server basic database engine. Allowed values are
2008R2(SQL Server 2008 Enterprise),2012SP3(SQL Server 2012 Enterprise),2016SP1(SQL Server 2016 Enterprise),201602(SQL Server 2016 Standard) and2017(SQL Server 2017 Enterprise). Default is2008R2. - Id string
- ID of the SQL Server basic instance to be query.
- Memory float64
- Memory size (in GB). Allowed value must be larger than
memorythat data sourcetencentcloud_sqlserver_specinfosprovides. - Name string
- Name of the SQL Server basic instance to be query.
- Project
Id float64 - Project ID of the SQL Server basic instance to be query.
- Status float64
- Status of the SQL Server basic instance.
1for applying,2for running,3for running with limit,4for isolated,5for recycling,6for recycled,7for running with task,8for off-line,9for expanding,10for migrating,11for readonly,12for rebooting. - Storage float64
- Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of
storage_minandstorage_maxwhich data sourcetencentcloud_sqlserver_specinfosprovides. - Subnet
Id string - Subnet ID of the SQL Server basic instance to be query.
- map[string]string
- Tags of the SQL Server basic instance.
- Used
Storage float64 - Used storage.
- Vip string
- IP for private access.
- Vpc
Id string - Vpc ID of the SQL Server basic instance to be query.
- Vport float64
- Port for private access.
- availability
Zone String - Availability zone.
- charge
Type String - Pay type of the SQL Server basic instance. For now, only
POSTPAID_BY_HOURis valid. - cpu Double
- The CPU number of the SQL Server basic instance.
- create
Time String - Create time of the SQL Server basic instance.
- engine
Version String - Version of the SQL Server basic database engine. Allowed values are
2008R2(SQL Server 2008 Enterprise),2012SP3(SQL Server 2012 Enterprise),2016SP1(SQL Server 2016 Enterprise),201602(SQL Server 2016 Standard) and2017(SQL Server 2017 Enterprise). Default is2008R2. - id String
- ID of the SQL Server basic instance to be query.
- memory Double
- Memory size (in GB). Allowed value must be larger than
memorythat data sourcetencentcloud_sqlserver_specinfosprovides. - name String
- Name of the SQL Server basic instance to be query.
- project
Id Double - Project ID of the SQL Server basic instance to be query.
- status Double
- Status of the SQL Server basic instance.
1for applying,2for running,3for running with limit,4for isolated,5for recycling,6for recycled,7for running with task,8for off-line,9for expanding,10for migrating,11for readonly,12for rebooting. - storage Double
- Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of
storage_minandstorage_maxwhich data sourcetencentcloud_sqlserver_specinfosprovides. - subnet
Id String - Subnet ID of the SQL Server basic instance to be query.
- Map<String,String>
- Tags of the SQL Server basic instance.
- used
Storage Double - Used storage.
- vip String
- IP for private access.
- vpc
Id String - Vpc ID of the SQL Server basic instance to be query.
- vport Double
- Port for private access.
- availability
Zone string - Availability zone.
- charge
Type string - Pay type of the SQL Server basic instance. For now, only
POSTPAID_BY_HOURis valid. - cpu number
- The CPU number of the SQL Server basic instance.
- create
Time string - Create time of the SQL Server basic instance.
- engine
Version string - Version of the SQL Server basic database engine. Allowed values are
2008R2(SQL Server 2008 Enterprise),2012SP3(SQL Server 2012 Enterprise),2016SP1(SQL Server 2016 Enterprise),201602(SQL Server 2016 Standard) and2017(SQL Server 2017 Enterprise). Default is2008R2. - id string
- ID of the SQL Server basic instance to be query.
- memory number
- Memory size (in GB). Allowed value must be larger than
memorythat data sourcetencentcloud_sqlserver_specinfosprovides. - name string
- Name of the SQL Server basic instance to be query.
- project
Id number - Project ID of the SQL Server basic instance to be query.
- status number
- Status of the SQL Server basic instance.
1for applying,2for running,3for running with limit,4for isolated,5for recycling,6for recycled,7for running with task,8for off-line,9for expanding,10for migrating,11for readonly,12for rebooting. - storage number
- Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of
storage_minandstorage_maxwhich data sourcetencentcloud_sqlserver_specinfosprovides. - subnet
Id string - Subnet ID of the SQL Server basic instance to be query.
- {[key: string]: string}
- Tags of the SQL Server basic instance.
- used
Storage number - Used storage.
- vip string
- IP for private access.
- vpc
Id string - Vpc ID of the SQL Server basic instance to be query.
- vport number
- Port for private access.
- availability_
zone str - Availability zone.
- charge_
type str - Pay type of the SQL Server basic instance. For now, only
POSTPAID_BY_HOURis valid. - cpu float
- The CPU number of the SQL Server basic instance.
- create_
time str - Create time of the SQL Server basic instance.
- engine_
version str - Version of the SQL Server basic database engine. Allowed values are
2008R2(SQL Server 2008 Enterprise),2012SP3(SQL Server 2012 Enterprise),2016SP1(SQL Server 2016 Enterprise),201602(SQL Server 2016 Standard) and2017(SQL Server 2017 Enterprise). Default is2008R2. - id str
- ID of the SQL Server basic instance to be query.
- memory float
- Memory size (in GB). Allowed value must be larger than
memorythat data sourcetencentcloud_sqlserver_specinfosprovides. - name str
- Name of the SQL Server basic instance to be query.
- project_
id float - Project ID of the SQL Server basic instance to be query.
- status float
- Status of the SQL Server basic instance.
1for applying,2for running,3for running with limit,4for isolated,5for recycling,6for recycled,7for running with task,8for off-line,9for expanding,10for migrating,11for readonly,12for rebooting. - storage float
- Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of
storage_minandstorage_maxwhich data sourcetencentcloud_sqlserver_specinfosprovides. - subnet_
id str - Subnet ID of the SQL Server basic instance to be query.
- Mapping[str, str]
- Tags of the SQL Server basic instance.
- used_
storage float - Used storage.
- vip str
- IP for private access.
- vpc_
id str - Vpc ID of the SQL Server basic instance to be query.
- vport float
- Port for private access.
- availability
Zone String - Availability zone.
- charge
Type String - Pay type of the SQL Server basic instance. For now, only
POSTPAID_BY_HOURis valid. - cpu Number
- The CPU number of the SQL Server basic instance.
- create
Time String - Create time of the SQL Server basic instance.
- engine
Version String - Version of the SQL Server basic database engine. Allowed values are
2008R2(SQL Server 2008 Enterprise),2012SP3(SQL Server 2012 Enterprise),2016SP1(SQL Server 2016 Enterprise),201602(SQL Server 2016 Standard) and2017(SQL Server 2017 Enterprise). Default is2008R2. - id String
- ID of the SQL Server basic instance to be query.
- memory Number
- Memory size (in GB). Allowed value must be larger than
memorythat data sourcetencentcloud_sqlserver_specinfosprovides. - name String
- Name of the SQL Server basic instance to be query.
- project
Id Number - Project ID of the SQL Server basic instance to be query.
- status Number
- Status of the SQL Server basic instance.
1for applying,2for running,3for running with limit,4for isolated,5for recycling,6for recycled,7for running with task,8for off-line,9for expanding,10for migrating,11for readonly,12for rebooting. - storage Number
- Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of
storage_minandstorage_maxwhich data sourcetencentcloud_sqlserver_specinfosprovides. - subnet
Id String - Subnet ID of the SQL Server basic instance to be query.
- Map<String>
- Tags of the SQL Server basic instance.
- used
Storage Number - Used storage.
- vip String
- IP for private access.
- vpc
Id String - Vpc ID of the SQL Server basic instance to be query.
- vport Number
- Port for private access.
Package Details
- Repository
- tencentcloud tencentcloudstack/terraform-provider-tencentcloud
- License
- Notes
- This Pulumi package is based on the
tencentcloudTerraform Provider.
tencentcloud 1.82.34 published on Wednesday, Nov 5, 2025 by tencentcloudstack
