CassandraLogs 數據表的查詢

Cassandra 記錄

特定節點的 Cassandra 記錄，依 (第一個) 顯示的最新記錄進行排序。

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

Cassandra 錯誤或警告

Cassandra 的錯誤或警告記錄，依第一次) 顯示的最新記錄 (排序。

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