tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloud.getSqlserverBasicInstances
Explore with Pulumi AI
tencentcloud 1.81.189 published on Wednesday, Apr 30, 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({
subnetId: "subnet-nf9n81ps",
vpcId: "vpc-409mvdvv",
});
import pulumi
import pulumi_tencentcloud as tencentcloud
example_vpc = tencentcloud.get_sqlserver_basic_instances(subnet_id="subnet-nf9n81ps",
vpc_id="vpc-409mvdvv")
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{
SubnetId: pulumi.StringRef("subnet-nf9n81ps"),
VpcId: pulumi.StringRef("vpc-409mvdvv"),
}, 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()
{
SubnetId = "subnet-nf9n81ps",
VpcId = "vpc-409mvdvv",
});
});
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()
.subnetId("subnet-nf9n81ps")
.vpcId("vpc-409mvdvv")
.build());
}
}
variables:
exampleVpc:
fn::invoke:
function: tencentcloud:getSqlserverBasicInstances
arguments:
subnetId: subnet-nf9n81ps
vpcId: vpc-409mvdvv
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 dictionary
The 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_HOUR
is 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
memory
that data sourcetencentcloud_sqlserver_specinfos
provides. - 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.
1
for applying,2
for running,3
for running with limit,4
for isolated,5
for recycling,6
for recycled,7
for running with task,8
for off-line,9
for expanding,10
for migrating,11
for readonly,12
for 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_min
andstorage_max
which data sourcetencentcloud_sqlserver_specinfos
provides. - 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_HOUR
is 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
memory
that data sourcetencentcloud_sqlserver_specinfos
provides. - 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.
1
for applying,2
for running,3
for running with limit,4
for isolated,5
for recycling,6
for recycled,7
for running with task,8
for off-line,9
for expanding,10
for migrating,11
for readonly,12
for 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_min
andstorage_max
which data sourcetencentcloud_sqlserver_specinfos
provides. - 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_HOUR
is 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
memory
that data sourcetencentcloud_sqlserver_specinfos
provides. - 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.
1
for applying,2
for running,3
for running with limit,4
for isolated,5
for recycling,6
for recycled,7
for running with task,8
for off-line,9
for expanding,10
for migrating,11
for readonly,12
for 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_min
andstorage_max
which data sourcetencentcloud_sqlserver_specinfos
provides. - 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_HOUR
is 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
memory
that data sourcetencentcloud_sqlserver_specinfos
provides. - 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.
1
for applying,2
for running,3
for running with limit,4
for isolated,5
for recycling,6
for recycled,7
for running with task,8
for off-line,9
for expanding,10
for migrating,11
for readonly,12
for 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_min
andstorage_max
which data sourcetencentcloud_sqlserver_specinfos
provides. - 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_HOUR
is 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
memory
that data sourcetencentcloud_sqlserver_specinfos
provides. - 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.
1
for applying,2
for running,3
for running with limit,4
for isolated,5
for recycling,6
for recycled,7
for running with task,8
for off-line,9
for expanding,10
for migrating,11
for readonly,12
for 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_min
andstorage_max
which data sourcetencentcloud_sqlserver_specinfos
provides. - 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_HOUR
is 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
memory
that data sourcetencentcloud_sqlserver_specinfos
provides. - 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.
1
for applying,2
for running,3
for running with limit,4
for isolated,5
for recycling,6
for recycled,7
for running with task,8
for off-line,9
for expanding,10
for migrating,11
for readonly,12
for 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_min
andstorage_max
which data sourcetencentcloud_sqlserver_specinfos
provides. - 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
tencentcloud
Terraform Provider.
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack