Allreportingcomputers
Query
union withsource = TableName *
| distinct Computer
| where isnotempty(Computer)
| summarize by ComputerExplanation
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
Released: March 26, 2020
Tables
TableName
Keywords
UnionTableNameComputerIsNotEmptySummarize
Operators
unionwithsource*distinctwhereisnotemptysummarizeby