-
Notifications
You must be signed in to change notification settings - Fork 25
Querying ADX clusters with lokqldx
NeilMacMullen edited this page Jul 1, 2025
·
1 revision
Lokqldx can issue KQL queries to ADX (Azure Data Explorer) clusters and render the results locally using the .adx command
.set server https://help.kusto.windows.net/
.set database SampleLogs
.set path $database@$server
.adx $path
RawSysLogs
| extend cpu = tostring(tags.cpu_id)
| summarize N=count() by Day=bin(timestamp,1d),cpu
| project Day,N,cpu
| render linechart
.adx requires two parameters and must be followed by the query to issue to the cluster
- ConnectionString. This is the connection-string of the cluster
- Database. This is the name of the database within the cluster.
The database and connection-string can be combined into a single string as shown in the example above
#Home
Core Engine
Lokqldx (UI data explorer)
- Introduction
- Tutorials
- Running queries and commands
- Autocompletion
- Generating powerpoint reports
- Accessing ApplicationInsights data
Powershell
Other
Articles