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.
Details
Rod Trent
Released: March 26, 2020
Tables
MachineInfo
Keywords
MachineInfo,OSPlatform,ComputerName
Operators
|wherecontains|project|distinct