KQL Search

Query Details

Serversenrolledin WDATP

Query

MachineInfo
|where OSPlatform  contains "server" 
|project ComputerName, OSPlatform 
|distinct ComputerName, OSPlatform

Explanation

This query selects the MachineInfo data where the OSPlatform contains the word "server". It then projects the ComputerName and OSPlatform columns and returns only distinct combinations of ComputerName and OSPlatform.