List the database instances of a client

Select

SaaS

Customer Managed

List the Instance properties of all the database instances associated to the client.

Query Parameters

• clientName string required

  Name of the Cloud Account

• applicationId integer required

  Possible values: [104, 125]

  Id of the App Type. 104-MySQL, 125-PostgreSQL

Responses

• 200
• 404

---

OK

application/json

• Schema
• Example (from schema)
• App Id-104
• App Id-125

---

Schema

• instanceProperties object[]

  clientAppType integer

  isDeleted boolean

  applicationSize integer

  excludeFromSLA boolean

  scIdxEnabled integer

  isSnapEnabled boolean

  autoDiscovered boolean

  instance object

  clientName string

  instanceName string

  displayName string

  instanceId integer

  instanceGUID string

  clientId integer

  appName string

  applicationId integer

  entityInfo object

  companyId integer

  companyName string

  multiCommcellId integer

  instanceActivityControl object

  activityControlOptions object[]

  activityType integer

  enableAfterADelay boolean

  enableActivityType boolean

{
  "instanceProperties": [
    {
      "clientAppType": 0,
      "isDeleted": true,
      "applicationSize": 0,
      "excludeFromSLA": true,
      "scIdxEnabled": 0,
      "isSnapEnabled": true,
      "autoDiscovered": true,
      "instance": {
        "clientName": "string",
        "instanceName": "string",
        "displayName": "string",
        "instanceId": 0,
        "instanceGUID": "string",
        "clientId": 0,
        "appName": "string",
        "applicationId": 0,
        "entityInfo": {
          "companyId": 0,
          "companyName": "string",
          "multiCommcellId": 0
        }
      },
      "instanceActivityControl": {
        "activityControlOptions": [
          {
            "activityType": 0,
            "enableAfterADelay": true,
            "enableActivityType": true
          }
        ]
      }
    }
  ]
}

{
  "instanceProperties": [
    {
      "clientAppType": 1,
      "jobStartTime": -1,
      "isDeleted": false,
      "applicationSize": 3145728,
      "excludeFromSLA": false,
      "scIdxEnabled": 0,
      "isSnapEnabled": false,
      "autoDiscovered": false,
      "status": 0,
      "instance": {
        "clientName": "GCP-Test-Ash",
        "instanceName": "mysql8[us-central1]",
        "displayName": "GCP-Test-Ash",
        "instanceId": 664,
        "instanceGUID": "557B1FF7-5C1D-4B42-A421-7AA6E426BFA3",
        "clientId": 257,
        "appName": "MySQL",
        "applicationId": 104,
        "entityInfo": {
          "companyId": 0,
          "companyName": "Commcell",
          "multiCommcellId": 0
        }
      },
      "instanceActivityControl": {
        "activityControlOptions": [
          {
            "activityType": 1,
            "enableAfterADelay": false,
            "enableActivityType": true
          },
          {
            "activityType": 2,
            "enableAfterADelay": false,
            "enableActivityType": true
          }
        ]
      },
      "mySqlInstance": {
        "sslCa": "/ssl_keys/server-ca.pem",
        "EnableNoLocking": false,
        "BinaryDirectory": "",
        "archiveLogIndexFile": "",
        "LogDataDirectory": "",
        "sslEnabled": true,
        "EnableAutoDiscovery": true,
        "isStandBy": false,
        "lastLogNumber": "0",
        "ConfigFile": "",
        "dataDirectory": "datadir:/mysql/datadir;",
        "sslCert": "/ssl_keys/client-cert.pem",
        "version": "8.0.18",
        "useADAuthentication": false,
        "port": "104.15.100.99:3306",
        "sslKey": "/ssl_keys/client-key.pem",
        "logStoragePolicy": {
          "storagePolicyName": "sudheer_plan",
          "storagePolicyId": 19
        },
        "proxySettings": {
          "isUseSSL": false,
          "isProxyEnabled": false,
          "runBackupOnProxy": false,
          "proxyInstance": {
            "instanceId": 0
          }
        },
        "NTUser": {
          "userName": ""
        },
        "mebSettings": {
          "mebBinPath": "",
          "enableMEB": false
        },
        "SAUser": {
          "userName": "root"
        },
        "mysqlStorageDevice": {
          "logBackupStoragePolicy": {
            "storagePolicyName": "sudheer_plan",
            "storagePolicyId": 19
          },
          "commandLineStoragePolicy": {
            "storagePolicyName": "sudheer_plan",
            "storagePolicyId": 19
          }
        },
        "unixUser": {
          "userName": ""
        },
        "clusterSettings": {},
        "xtraBackupSettings": {
          "xtraBackupBinPath": "",
          "enableXtraBackup": false
        }
      },
      "planEntity": {
        "planType": 2,
        "planName": "sudheer_plan",
        "planSubtype": 33554437,
        "planId": 5
      },
      "cloudDBInstance": {
        "overRideAccessNode": false,
        "accessNodes": {}
      }
    }
  ]
}

{
  "instanceProperties": [
    {
      "clientAppType": 1,
      "jobStartTime": -1,
      "isDeleted": false,
      "applicationSize": 0,
      "excludeFromSLA": false,
      "version": "11.21",
      "scIdxEnabled": 0,
      "isSnapEnabled": false,
      "autoDiscovered": false,
      "status": 0,
      "instance": {
        "clientName": "GCP-Test-Ash",
        "instanceName": "pg11[us-central1]",
        "displayName": "GCP-Test-Ash",
        "instanceId": 605,
        "instanceGUID": "400BCB7E-A3C0-4239-8E46-BB035979B946",
        "clientId": 257,
        "appName": "PostgreSQL",
        "applicationId": 125,
        "entityInfo": {
          "companyId": 0,
          "companyName": "Commcell",
          "multiCommcellId": 0
        }
      },
      "postGreSQLInstance": {
        "BinaryDirectory": "/opt/commvault/CVCloudAddOns/PostgreSQL/11/bin",
        "ArchiveDelete": false,
        "useGCPApi": false,
        "ArchiveLogDirectory": "",
        "isStandBy": false,
        "lastLogNumber": "",
        "MaintainenceDB": "postgres",
        "useClientCloudCredentials": false,
        "planSchedAssocType": 0,
        "LibDirectory": "/opt/commvault/CVCloudAddOns/PostgreSQL/11/lib",
        "port": "34.72.2.40:5432",
        "sslOpt": {
          "sslCa": "",
          "sslEnabled": false,
          "sslKey": "",
          "sslCert": ""
        },
        "logStoragePolicy": {
          "storagePolicyName": "CV_DEFAULT",
          "storagePolicyId": 1
        },
        "UNCUser": {
          "userName": ""
        },
        "standbyOptions": {
          "useMasterForLogBkp": false,
          "isStandbyEnabled": false,
          "useMasterForDataBkp": false,
          "standbyInstance": {
            "instanceName": "DefaultInstanceName",
            "instanceId": 1
          }
        },
        "SAUser": {
          "userName": "postgres"
        },
        "osUser": {
          "userName": ""
        },
        "gcpOptions": {
          "stagingBucketURI": "",
          "dumpFileType": 0,
          "useCompression": false
        },
        "clusterSettings": {}
      },
      "instanceActivityControl": {
        "activityControlOptions": [
          {
            "activityType": 1,
            "enableAfterADelay": false,
            "enableActivityType": true
          },
          {
            "activityType": 2,
            "enableAfterADelay": false,
            "enableActivityType": true
          }
        ]
      },
      "planEntity": {
        "planType": 2,
        "planName": "sudheer_plan",
        "planSubtype": 33554437,
        "planId": 5
      },
      "cloudDBInstance": {
        "overRideAccessNode": false,
        "accessNodes": {}
      }
    },
    {
      "clientAppType": 1,
      "jobStartTime": -1,
      "isDeleted": false,
      "applicationSize": 0,
      "excludeFromSLA": false,
      "version": "13.13",
      "scIdxEnabled": 0,
      "isSnapEnabled": false,
      "autoDiscovered": false,
      "status": 0,
      "instance": {
        "clientName": "GCP-Test-Ash",
        "instanceName": "pg13db[asia-south1]",
        "displayName": "GCP-Test-Ash",
        "instanceId": 666,
        "instanceGUID": "B51823B5-5A99-4A67-8E55-EAE4198E1E10",
        "clientId": 257,
        "appName": "PostgreSQL",
        "applicationId": 125,
        "entityInfo": {
          "companyId": 0,
          "companyName": "Commcell",
          "multiCommcellId": 0
        }
      },
      "postGreSQLInstance": {
        "BinaryDirectory": "/opt/commvault/CVCloudAddOns/PostgreSQL/13/bin",
        "ArchiveDelete": false,
        "useGCPApi": false,
        "ArchiveLogDirectory": "",
        "isStandBy": false,
        "lastLogNumber": "",
        "MaintainenceDB": "postgres",
        "useClientCloudCredentials": false,
        "planSchedAssocType": 0,
        "LibDirectory": "/opt/commvault/CVCloudAddOns/PostgreSQL/13/lib",
        "port": "36.10.10.250:5432",
        "sslOpt": {
          "sslCa": "/pg13ssl/server-ca.pem",
          "sslEnabled": true,
          "sslKey": "/pg13ssl/client-key.pem",
          "sslCert": "/pg13ssl/client-cert.pem"
        },
        "logStoragePolicy": {
          "storagePolicyName": "CV_DEFAULT",
          "storagePolicyId": 1
        },
        "UNCUser": {
          "userName": ""
        },
        "standbyOptions": {
          "useMasterForLogBkp": false,
          "isStandbyEnabled": false,
          "useMasterForDataBkp": false,
          "standbyInstance": {
            "instanceName": "DefaultInstanceName",
            "instanceId": 1
          }
        },
        "SAUser": {
          "userName": "postgres"
        },
        "osUser": {
          "userName": ""
        },
        "gcpOptions": {
          "stagingBucketURI": "",
          "dumpFileType": 0,
          "useCompression": false
        },
        "clusterSettings": {}
      },
      "instanceActivityControl": {
        "activityControlOptions": [
          {
            "activityType": 1,
            "enableAfterADelay": false,
            "enableActivityType": true
          },
          {
            "activityType": 2,
            "enableAfterADelay": false,
            "enableActivityType": true
          }
        ]
      },
      "planEntity": {
        "planType": 2,
        "planName": "sudheer_plan",
        "planSubtype": 33554437,
        "planId": 5
      },
      "cloudDBInstance": {
        "overRideAccessNode": false,
        "accessNodes": {}
      }
    }
  ]
}

Not Found

application/json

• Schema
• Example (from schema)
• Example 1

---

Schema

• errorMessage string
• errorCode integer

{
  "errorMessage": "string",
  "errorCode": 0
}

{
  "errorMessage": "No client is specified",
  "errorCode": 4
}

Loading...