Database Name Category Filter
Returns a list of MC alerts for a specific database.
Resource URL
https://<MC_NODE>:5450/webui/api/alerts?db_name=<database_name>
Authentication
Requires an MC-User-Apikey in the request header.
Example Request
GET |
https://<MC_NODE>:5450/webui/api/alerts?db_name="mydb" |
This example shows how you can view alerts on a specific database using cURL:
curl -H "MC-User-ApiKey: ValidUserKey" https://<MC_NODE>:5450/webui/api/alerts?db_name="mydb"
Response:
[ { "alerts":[ { "id":9, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-05 15:10:53.391", "updated_time":"2015-11-05 15:10:53.391", "severity":"notice", "status":1, "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Workload analyzed successfully", "summary":"Analyze Workload operation has succeeded on Database", "internal":false, "count":1 }, { "id":8, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-05 15:10:31.16", "updated_time":"2015-11-05 15:10:31.16", "severity":"notice", "status":1, "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Analyze Workload operation started on Database", "summary":"Analyze Workload operation started on Database", "internal":false, "count":1 }, { "id":7, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-05 00:15:00.204", "updated_time":"2015-11-05 00:15:00.204", "severity":"alert", "status":1, "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Workload analyzed successfully", "summary":"Analyze Workload operation has succeeded on Database", "internal":false, "count":1 }, { "id":6, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-04 15:14:59.344", "updated_time":"2015-11-04 15:14:59.344", "severity":"notice", "status":1, "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Workload analyzed successfully", "summary":"Analyze Workload operation has succeeded on Database", "internal":false, "count":1 }, { "id":5, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-04 15:14:38.925", "updated_time":"2015-11-04 15:14:38.925", "severity":"notice", "status":1, "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Analyze Workload operation started on Database", "summary":"Analyze Workload operation started on Database", "internal":false, "count":1 }, { "id":4, "markedRead":false, "eventTypeCode":0, "create_time":"2015-11-04 15:14:33.0", "updated_time":"2015-11-05 16:26:17.978", "severity":"notice", "status":1, "nodeName":"v_mydb_node0001", "databaseName":"lmydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Workload analyzed successfully", "summary":"Analyze Workload operation has succeeded on Database", "internal":false, "count":1 }, { "id":3, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-04 15:14:32.806", "updated_time":"2015-11-04 15:14:32.806", "severity":"info", "status":1, "hostIp":"10.20.100.64", "nodeName":"v_mydb_node0003", "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Agent status is UP on IP 127.0.0.1", "summary":"Agent status is UP on IP 127.0.0.1", "internal":false, "count":1 }, { "id":2, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-04 15:14:32.541", "updated_time":"2015-11-04 15:14:32.541", "severity":"info", "status":1, "hostIp":"10.20.100.63", "nodeName":"v_mydb_node0002", "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Agent status is UP on IP 127.0.0.1", "summary":"Agent status is UP on IP 127.0.0.1", "internal":false, "count":1 }, { "id":1, "markedRead":false, "eventTypeCode":2, "create_time":"2015-11-04 15:14:32.364", "updated_time":"2015-11-04 15:14:32.364", "severity":"info", "status":1, "hostIp":"10.20.100.62", "nodeName":"v_mydb_node0001", "databaseName":"mydb", "databaseId":1, "clusterName":"1446668057043_cluster", "description":"Agent status is UP on IP 127.0.0.1", "summary":"Agent status is UP on IP 127.0.0.1", "internal":false, "count":1 } ], "total_alerts":9, "request_query":"db_name=mydb", "request_time":"2015-11-05 16:26:21.679" } ]