KQL Search

Query Details

Allreportingcomputers

Query

union withsource = TableName *
| distinct Computer
| where isnotempty(Computer)
| summarize  by Computer

Explanation

This query combines data from a table called TableName with another source. It then selects only unique values for the "Computer" column and filters out any empty values. Finally, it groups the data by the "Computer" column.