KQL Search

Query Details

HomeAI ToolsDevice Query

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.

Details

Rod Trent profile picture

Rod Trent

Released: March 26, 2020

Tables

TableName

Keywords

Union,TableName,Computer,IsNotEmpty,Summarize

Operators

unionwithsource*distinctwhereisnotemptysummarizeby

Actions