/instance/show
- Vijayganesh Sivaprakasam
Analytics
Show details for an instance
Request
HTTP Method: POST
Content Type: application/json
Parameters
Property | Type | Description | Required |
|---|---|---|---|
| string | host of instance to show | required |
| string | name of instance to show |
|
| integer | port of instance to show (non-negative) |
|
{
"params": {
"host": "string",
"instance": "string",
"port": 123
}
}Response
HTTP Status: 200
Content Type: application/json
Response
Property | Type | Description |
|---|---|---|
| object of type | error response |
| object of type | SQL Server instance details |
| boolean | response with error or not |
error_response
Property | Type | Description |
|---|---|---|
| string | error message |
instance
Property | Type | Description |
|---|---|---|
| string | authentication type (possible values: 'SQL' and 'WIN') |
| string | host running instance |
| string | name of instance |
| string(date-time) | last connection attempt time in UTC |
| integer | port number of instance |
| string | reason for unconnected instance |
| string | instance running state (possible values: 'Unknown', 'Connected', 'Disconnected' and 'Disabled') |
| integer | total connection attempts |
| string | user name for authentication to instance |
{
"error": {
"message": "string"
},
"result": {
"authentication_type": "SQL",
"host": "string",
"instance_name": "string",
"last_attempt_time": "2024-07-31T13:57:42.000123456Z",
"port": 123,
"reason": "string",
"state": "Unknown",
"total_attempts": 123,
"username": "string"
},
"successful": true
}HTTP Status: 400
Content Type: application/json
Response
Property | Type | Description |
|---|---|---|
| object of type | error response |
| boolean | always false |
error_response
Property | Type | Description |
|---|---|---|
| string | error message |
{
"error": {
"message": "string"
},
"successful": false
}