Get all databases

Select

SaaS

Customer Managed

Get all databases

Responses

• 200

---

Success

application/json

• Schema
• Example (from schema)

---

Schema

• databases object[]

  List of databases

  applicationId int32

  Application Id of database

  name string

  This gives the name of the database.

  instance object

  id int32

  name string

  server object

  id int32

  name string

  vendor string

  Possible values: [NOT_APPLICABLE, AMAZON, MICROSOFT_AZURE, GOOGLE_CLOUD, ALIBABA_CLOUD]

  The cloud vendor for the instance.

  databaseEngine string

  Possible values: [AURORA_MYSQL, DB2, DB2_MULTINODE, DOCUMENT_DB, DYNAMO_DB, INFORMIX, MARIA_DB, MYSQL, ORACLE, ORACLE_RAC, POSTGRESQL, RDS, REDSHIFT, SAP_FOR_ORACLE, SAP_HANA, SQL_SERVER, SYBASE]

  Name of database engine which is the underlying software component that a database management system uses to create, read, update and delete data from the database.

  recoveryModel string

  Possible values: [FULL, SIMPLE]

  SQL recovery model is a database configuration option that determines the type of backup that one could perform, and provides the ability to restore the data or recover it from a failure.

  SLAStatus string

  Possible values: [MET, MISSED, EXCLUDED]

  SLA status for last backup of database

  lastBackupSize int32

  Size of last backup of database in bytes

  lastBackupTime int32

  Time of last backup of database. It is given in UNIX time.

  plan object

  id int32

  name string

  company object

  id int32

  name string

  commcell object

  name string

  Name of the commcell the entity belongs to.

{
  "databases": [
    {
      "applicationId": 0,
      "name": "string",
      "instance": {
        "id": 0,
        "name": "string"
      },
      "server": {
        "id": 0,
        "name": "string"
      },
      "vendor": "NOT_APPLICABLE",
      "databaseEngine": "AURORA_MYSQL",
      "recoveryModel": "FULL",
      "SLAStatus": "MET",
      "lastBackupSize": 0,
      "lastBackupTime": 0,
      "plan": {
        "id": 0,
        "name": "string"
      },
      "company": {
        "id": 0,
        "name": "string"
      },
      "commcell": {
        "name": "string"
      }
    }
  ]
}

Loading...