Updated on 2026-09-20 GMT+08:00

Obtaining MSDTC Local Host Information

This API is used to obtain MSDTC local host information.

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.

If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
rds:instance:getMsdtcHosts	read	instance	-	rds:instance:list	-

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
instance_id	Yes	String	Definition Instance ID. You can obtain the value of this parameter from id in Table 4 by calling the API for querying DB instances. Constraints N/A Range N/A Default Value N/A

None

Obtain MSDTC local host information.

GET https://{Endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/1aa833000a124455a6801e83cca37e6ein04/msdtc/local-host

Normal response

**Table 2** Parameters
Parameter	Type	Description
hosts	Array of objects	Definition List of MSDTC local host information. For details, see Table 3.
status	string	Definition Query status. Range success: The execution is successful.

**Table 3** hosts structure description
Parameter	Type	Description
ip	String	Definition IP address. Range N/A
host_name	String	Definition Host name. Range N/A

Example normal response

{
    "status": "success",
    "hosts": [
        {
            "ip": "192.168.8.207",
            "host_name": "MSSQL-E404F3D9"
        }
    ]
}

For details, see Error Codes.

Parent topic: Database and Account Management (Microsoft SQL Server)