Select Database Instance SQL Instance

Select

SaaS

Customer Managed

This API returns list of MSSQL instance.

Query Parameters

• regionId integer

  Id of the region, Use select region to get ID. Application for SaaS

• cloudAccountId integer required

  Id of the cloud Account

• backupGateways string

  Comma separated backupGateway Client IDs. Not needed for directCloudBackup

Responses

• 200

---

OK

application/json

• Schema
• Example (from schema)
• Example 1

---

Schema

• sqlDiscoveredServer object[]

  sql server instance list

  type string

  instanceName string

{
  "sqlDiscoveredServer": [
    {
      "type": "string",
      "instanceName": "string"
    }
  ]
}

{
  "sqlDiscoveredServer": [
    {
      "type": "Azure Managed DataBase Engine",
      "instanceName": "sqlami-eastus.0b6ca3d85c3b.database.windows.net"
    }
  ]
}

GET /v4/azuredb/mssql/instance    

Authorization

type: apiKeyname: Authtokenin: header

Request

Click Edit to configure Base URL

https://CommandCenterHostName/commandcenter/api

Security Scheme

tokenbearerToken

token

cloudAccountId — query required

regionId — query

backupGateways — query

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'

curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/V4/azuredb/mssql/instance' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'