List all SQL instances
Select
SaaS
Customer Managed
This operation returns all configured MSSQL instances
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example
Schema
SqlInstance object[]
notReadyReason stringNot ready reason for instance, if applicable
insName stringInstance name
sla integerSLA for the instance
planName stringPlan associated with instance
unprot integerNumber of unprotected databases in the instance
version stringSQL instance version
attempt integerinsId integerInstance ID
noDBs integerTotal number of databases configured in instance
cName stringClient name
serverType stringServer type of the instance
planId integerID of the plan associated with instance
protect integerNumber of databases protected in the instance
noSysDBs integerTotal number of system DBs protected in the instance
cId integerClient ID
status integerInstance status 1 - Ready 0 - Not Ready
response object
total integerTotal number of instances configured
errorMessage stringerrorCode integerend integer
{
"SqlInstance": [
{
"notReadyReason": "string",
"insName": "string",
"sla": 0,
"planName": "string",
"unprot": 0,
"version": "string",
"attempt": 0,
"insId": 0,
"noDBs": 0,
"cName": "string",
"serverType": "string",
"planId": 0,
"protect": 0,
"noSysDBs": 0,
"cId": 0,
"status": 0
}
],
"response": {
"total": 0,
"errorMessage": "string",
"errorCode": 0,
"end": 0
}
}
{
"SqlInstance": [
{
"notReadyReason": "No plan or storage policy associated with the instance",
"insName": "AUTOSQLV11",
"sla": 0,
"planName": "",
"unprot": 0,
"version": "13.2.5026.0",
"attempt": 0,
"insId": 25,
"noDBs": 0,
"cName": "autosqlv11",
"serverType": "DataBase Engine",
"planId": 0,
"protect": 0,
"noSysDBs": 0,
"cId": 18,
"status": 0
},
{
"notReadyReason": "No plan or storage policy associated with the instance",
"insName": "AUTOSQLV11\\SQLAUTO2012",
"sla": 1,
"planName": "",
"unprot": 0,
"version": "11.0.6020.0",
"attempt": 0,
"insId": 27,
"noDBs": 1,
"cName": "autosqlv11",
"serverType": "DataBase Engine",
"planId": 0,
"protect": 1,
"noSysDBs": 0,
"cId": 18,
"status": 0
},
{
"notReadyReason": "",
"insName": "AUTOSQLV11\\SQLAUTO2017",
"sla": 1,
"planName": "Log SLA",
"unprot": 0,
"version": "14.0.1000.169",
"attempt": 0,
"insId": 74,
"noDBs": 4,
"cName": "autosqlv11",
"serverType": "DataBase Engine",
"planId": 2,
"protect": 4,
"noSysDBs": 3,
"cId": 18,
"status": 1
}
],
"response": {
"total": 3,
"errorMessage": "",
"errorCode": 0,
"end": 1
}
}
Loading...