Queries for the CassandraLogs table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Cassandra logs

Cassandra logs for a specific node, sorted by time (latest logs shown first).

let nodeIPAddress = "10.0.0.0"; // Replace with your node IP address
CassandraLogs
| where AddressIP == nodeIPAddress
| sort by TimeGenerated desc

Cassandra errors or warnings

Error or warning logs from Cassandra, sorted by time (latest logs shown first).

CassandraLogs
| where Level == "ERROR" or Level == "WARN"
| project TimeGenerated, Level, AddressIp, ThreadName, ThreadId, SourceFile, SourceLine, Message, Exception, EventProduct, EventCategory, EventType
| sort by TimeGenerated desc