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 requiredName of the Cloud account
applicationId integer requiredDefault value:
104
instanceName string requiredName of the Instance
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
mysqlContent object[]
databaseName stringcreationTime integerdatabaseSize integerassociatedSC object
_type_ integersubclientId integererror 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...