Get Database Alerts
Use this endpoint to get all database alerts for the organization
Authorized Roles : PROVIDER or ORG_ADMIN or ORG_USER
Request
URI
GET
https://{api_host}/provider/events/database
COPY
Query Parameters
string
tenantId
Optional
ID of the organization
integer
duration
Required
Duration
string
timeunit
Required
TimeUnit
Possible values are :
NANOSECONDS,
MICROSECONDS,
MILLISECONDS,
SECONDS,
MINUTES,
HOURS,
DAYS,
integer
page
Optional
Zero-based page index (0..N)
integer
size
Optional
The size of the page to be returned
string of
array
sort
Optional
Sorting criteria in the format: property,(asc|desc). Default sort order is ascending. Multiple sort criteria are supported.
Responses
200
OK
Returns
PagedModelManagedDbRuntimeInfoHistoryDTO
of type(s)
application/vnd.vmware.dms-v1+json
{
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
],
"content": [
{
"id": "string",
"managedDbDTO": {
"id": "string",
"instanceName": "string",
"version": "string",
"dbType": "string",
"role": "string",
"logicalBuildId": "string",
"environment": {
"environmentId": "string",
"tenantId": "string",
"vcInstanceUuid": "string",
"vcIpAddress": "string",
"pscFqdn": "string",
"vcThumbprint": "string",
"pscThumbprint": "string",
"vcDatacenter": {
"id": "string",
"moId": "string",
"name": "string",
"type": "string",
"isDefault": false
},
"vcVMFolder": {
"id": "string",
"moId": "string",
"name": "string",
"type": "string",
"isDefault": false
},
"vcCluster": {
"id": "string",
"moId": "string",
"name": "string",
"type": "string",
"isDefault": false
},
"vcResourcePool": {
"id": "string",
"moId": "string",
"name": "string",
"type": "string",
"isDefault": false
},
"vcResourcePoolPath": "string",
"vcVmDatastores": {
"list": [
{
"mor": "string",
"datastoreName": "string",
"isDefault": false
}
]
},
"vcAppNetworks": {
"list": [
{
"mor": "string",
"appNetworkName": "string",
"isDefault": false
}
]
},
"lcpNetwork": {
"id": "string",
"moId": "string",
"name": "string",
"type": "string",
"isDefault": false
},
"vcDmsUsername": "string",
"vcDmsUserPassword": "string",
"vcDmsROUsername": "string",
"vcDmsROUserPassword": "string",
"tenantNtp": "string",
"tenantIpAddress": "string",
"providerIpAddress": "string",
"state": "string",
"providerRabbitSettings": {
"rabbitEndpoints": [
{
"endpoint": "string",
"port": 0
}
],
"username": "string",
"password": "string"
},
"runtimeInfo": [
{
"environmentId": "string",
"alertType": "string",
"alertStatus": "string",
"alertTime": "string",
"environmentName": "string"
}
],
"status": "string",
"version": "string",
"vmRootPassword": "string",
"clusterType": "string",
"templateStorage": {
"id": "string",
"name": "string",
"endpoint": "string",
"bucket": "string",
"accessKey": "string",
"secretKey": [
"string"
],
"region": "string",
"thumbprint": "string",
"templateStorage": false
},
"agentVMName": "string",
"rootPasswordExpiryInfo": {
"expiryDate": "string",
"noOfDaysToWarn": 0,
"noOfDaysToExpire": 0,
"warning": false,
"expired": false,
"status": "string"
},
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
]
},
"tenantId": "string",
"user": {
"id": 0,
"firstName": "string",
"lastName": "string",
"contactNumber": "string",
"email": "string",
"password": "string",
"tenantId": "string",
"companyName": "string",
"type": "string",
"roles": [
"string"
],
"forcePasswordChange": false,
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
]
},
"status": "string",
"fqdn": "string",
"primaryFqdn": "string",
"ip": "string",
"dbMgmtIp": "string",
"vmId": "string",
"createdTimestamp": "string",
"datastoreId": "string",
"appNetworkId": "string",
"lcpNetworkId": "string",
"dbInstanceConfig": {
"id": "string",
"port": 0,
"rootUser": "string",
"rootPassword": "string",
"adminUser": "string",
"adminPassword": "string",
"replicationUser": "string",
"replicationPassword": "string",
"dbName": "string",
"monitoringType": "string",
"dbId": 0,
"edition": "string",
"dbVersion": "string"
},
"maintenanceConfig": {
"id": "string",
"maintenanceWindowStartDay": "string",
"maintenanceWindowStartTime": "string",
"maintenanceWindowDuration": 0,
"minorVersionUpgradeEnabled": false,
"maintenanceWindowSelected": false
},
"hwConfig": {
"id": "string",
"hdDiskSizeGB": 0,
"cpuCores": 0,
"memoryGB": 0,
"thinDisk": false
},
"backupConfig": {
"id": "string",
"numLocalBackupDays": 0,
"numRemoteBackupDays": 0,
"autoBackupsEnabled": false,
"automatedBackupStartTime": "string"
},
"runtimeInfo": [
{
"id": "string",
"alertTypeEnum": "string",
"alertLevel": "string",
"updatedTimestamp": "string"
}
],
"enableProtection": false,
"dbVmRootPassword": "string",
"dbVmProviderAdminUser": "string",
"dbVmProviderAdminPassword": "string",
"dbVmTenantAdminUser": "string",
"dbVmTenantAdminPassword": "string",
"requireClientSsl": false,
"dbOptions": [
{
"key": "string",
"value": "string",
"type": "string",
"url": "string"
}
],
"dbCluster": "DbClusterDTO Object",
"readReplicas": [
{
"dbUUID": "string",
"instanceName": "string",
"ip": "string",
"dbMgmtIp": "string",
"fqdn": "string",
"role": "string",
"status": "string",
"createdTimestamp": "string",
"replicationLag": "number",
"replicationStatus": "string",
"environment": {
"environmentId": "string",
"vcHost": "string",
"vcClusterName": "string",
"vcResourcePoolName": "string"
},
"dbVersion": "string",
"memberPriority": 0,
"syncReplicationEnabled": false,
"namespace": {
"id": "string",
"name": "string"
}
}
],
"shellOvaVersion": "string",
"dbAdapterRpmVersion": "string",
"dbEngineRpmVersion": "string",
"coreRpmVersion": "string",
"tags": [
{
"id": "string",
"orgId": "string",
"name": "string",
"createdTime": "string",
"modifiedTime": "string",
"lastModified": "string",
"assignedInstanceCount": 0
}
],
"namespace": {
"id": "string",
"name": "string",
"description": "string",
"environment": {
"id": "string",
"name": "string"
},
"localStorages": [
{
"id": "string",
"name": "string",
"isDefault": false
}
],
"cloudStorages": [
{
"id": "string",
"name": "string",
"isDefault": false
}
],
"datastores": [
{
"id": "string",
"name": "string",
"moId": "string",
"isDefault": false
}
],
"appNetworks": [
{
"id": "string",
"name": "string",
"moId": "string",
"isDefault": false
}
],
"organisations": [
{
"id": "string",
"name": "string",
"isPublished": false,
"databaseCount": 0
}
],
"status": "string",
"runtimeInfo": [
{
"id": "string",
"namespaceId": "string",
"alertType": "string",
"alertLevel": "string",
"alertTime": "string"
}
],
"databaseCount": 0,
"lastUpdatedTime": "string"
},
"edition": "string",
"rootPasswordExpiryInfo": {
"expiryDate": "string",
"noOfDaysToWarn": 0,
"noOfDaysToExpire": 0,
"warning": false,
"expired": false,
"status": "string"
},
"alertRuleSetDto": {
"alertRuleSetId": "string",
"alertRuleSetName": "string"
},
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
]
},
"alertTypeEnum": "string",
"alertLevel": "string",
"updatedTimestamp": "string",
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
]
}
],
"page": {
"size": 0,
"totalElements": 0,
"totalPages": 0,
"number": 0
}
}
400
Bad Request
Operation doesn't return any data structure