How to query OpsCenter alert rules using CQL,
SELECT blobAsText(key), blobAsText(column1), blobAsText(value) FROM "OpsCenter".settings WHERE key = textAsBlob('global-cluster-alert-rules');
Example curl command to fix a broken rule. Take the value from the database, remove id and type and make enabled a true for false:
curl -X PUT http://127.0.0.1:8888/Test_Cluster/alert-rules/d4221b3a-4bd5-473c-a4fc-fe668b398c66 -d '{"item": "", "cf": "", "threshold": 50000000.0, "enabled": false, "duration": 5.0, "comparator": ">", "notify_interval": 5.0, "percentile": 99, "tier": "", "metric": "read-histogram", "dc": ""}'