Get Database groups associated to a MySQL Instance
Select
SaaS
Customer Managed
This operation gets database groups properties of a MySQL Instance.
Find client id using client name
Query Parameters
- clientId integer required
Client Id of the client
- applicationId integer required
Default value:
104
- InstanceId integer required
Instance id of MySQL Instance
Responses
- 200
- 401
OK
- application/json
- Schema
- Example (from schema)
- Example 1
- Example 2
Schema
- filterQueryCount integer
Number of database groups associated to the MySQL Instance
subClientProperties object[]
useLocalContent booleanuseLocalArchivalRules booleanplanEntity objectcassandraProps objectsplunkProps objectproxyClient objectdcPlanEntity objectsubClientEntity object
Database group properties
clientName stringClient Name
instanceName stringMySQL Instance name
displayName stringClient's display name
backupsetId integerBackupset ID
_type_ integercommCellName stringCommcell Name
instanceId integerMySQL Instance ID
csGUID stringsubclientGUID stringsubclientId integerDatabase group ID
clientId integerClient ID
appName stringDefault value:
MySQL
backupsetName stringDefault value:
defaultDummyBackupSet
MySQL Backupset Name
applicationId integerDefault value:
104
subclientName stringDatabase group name
entityInfo object
companyId integercompanyName stringmultiCommcellId integerdfsSubclientProp objectregion objectanalyticsSubclientProp object
{
"filterQueryCount": 0,
"subClientProperties": [
{
"useLocalContent": true,
"useLocalArchivalRules": true,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "string",
"instanceName": "string",
"displayName": "string",
"backupsetId": 0,
"_type_": 0,
"commCellName": "string",
"instanceId": 0,
"csGUID": "string",
"subclientGUID": "string",
"subclientId": 0,
"clientId": 0,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "string",
"entityInfo": {
"companyId": 0,
"companyName": "string",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
}
]
}
{
"filterQueryCount": 2,
"subClientProperties": [
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3307",
"displayName": "mysqlrhel",
"backupsetId": 628,
"_type_": 7,
"commCellName": "databaseCS",
"instanceId": 441,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "79F7BE18-F785-4848-8148-B9E9B5532077",
"subclientId": 1076,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "default",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
},
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3307",
"displayName": "mysqlrhel",
"backupsetId": 628,
"_type_": 7,
"commCellName": "databasecs",
"instanceId": 441,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "BF2B4127-6E72-4274-BC35-4DCAD6209B9B",
"subclientId": 1077,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "(command line)",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
}
]
}
{
"filterQueryCount": 5,
"subClientProperties": [
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3306",
"displayName": "mysqlrhel",
"backupsetId": 632,
"_type_": 7,
"commCellName": "databaseCS",
"instanceId": 445,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "2D20CF9C-E57B-4417-8082-5E75EA596B60",
"subclientId": 1091,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "default",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
},
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3306",
"displayName": "mysqlrhel",
"backupsetId": 632,
"_type_": 7,
"commCellName": "databaseCS",
"instanceId": 445,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "1EBEA9F0-5D5E-457A-B9FB-92883CB55FFA",
"subclientId": 1092,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "(command line)",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
},
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3306",
"displayName": "mysqlrhel",
"backupsetId": 632,
"_type_": 7,
"commCellName": "databaseCS",
"instanceId": 445,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "59868927-A8C0-4B8F-A7B9-0A9A6A778CFA",
"subclientId": 1100,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "dbgroup1",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
},
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3306",
"displayName": "mysqlrhel",
"backupsetId": 632,
"_type_": 7,
"commCellName": "databaseCS",
"instanceId": 445,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "8BD3F2CB-A934-47EA-A418-51F96C5CCE51",
"subclientId": 1101,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "dbgroup2",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
},
{
"useLocalContent": false,
"useLocalArchivalRules": false,
"planEntity": {},
"cassandraProps": {},
"splunkProps": {},
"proxyClient": {},
"dcPlanEntity": {},
"subClientEntity": {
"clientName": "mysqlrhel",
"instanceName": "mysqlrhel_3306",
"displayName": "mysqlrhel",
"backupsetId": 632,
"_type_": 7,
"commCellName": "databaseCS",
"instanceId": 445,
"csGUID": "838DD54E-CDAE-4DE4-9F2E-461FCA13111F",
"subclientGUID": "6691B579-D249-4B3D-B38C-0B25C718A8AC",
"subclientId": 1102,
"clientId": 200,
"appName": "MySQL",
"backupsetName": "defaultDummyBackupSet",
"applicationId": 104,
"subclientName": "dbgroup3",
"entityInfo": {
"companyId": 0,
"companyName": "Commcell",
"multiCommcellId": 0
}
},
"dfsSubclientProp": {},
"region": {},
"analyticsSubclientProp": {}
}
]
}
Unauthorized
- application/json
- Schema
- Example (from schema)
- Example
Schema
- errorMessage string
- errorCode integer
{
"errorMessage": "string",
"errorCode": 0
}
{
"errorMessage": "Access denied",
"errorCode": 5
}
Loading...