Discover databases on the DB server using instance id

Select

SaaS

Customer Managed

This operation returns the list of databases on the server that are not backed up part of database group.

Applicable for GCP MySQL, PostgreSQL.

Path Parameters

• instanceId integer required

  Id of the instance

application/json

Request Body

• path string required

  set to "/"

• entity object

  clientName string required

  Name of the Cloud account

  applicationId integer required

  Default value: 104

  instanceName string required

  Name of the Instance

Responses

• 200

---

OK

application/json

• Schema
• Example (from schema)
• Example 1

---

Schema

• mysqlContent object[]

  databaseName string

  creationTime integer

  databaseSize integer

  associatedSC object

  _type_ integer

  subclientId integer
• error object

{
  "mysqlContent": [
    {
      "databaseName": "string",
      "creationTime": 0,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 0,
        "subclientId": 0
      }
    }
  ],
  "error": {}
}

{
  "mysqlContent": [
    {
      "databaseName": "/aashdemo",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/amazondb1",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/azuredb1",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/db1",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/mydatabase",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/mytestdb",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/mytestdb28",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/sp22winsub",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/sp22winsub1",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/test",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/test1",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/test2p24db",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/test_db",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdata",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdata10",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdata2",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdata3",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdata4",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdata5",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdb",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    },
    {
      "databaseName": "/testdb1",
      "creationTime": 1711448487,
      "databaseSize": 0,
      "associatedSC": {
        "_type_": 7,
        "subclientId": 0
      }
    }
  ],
  "error": {}
}

Loading...