Forum Discussion
adityakumar70
Sep 26, 2024Copper Contributor
KQL Queries
Hi team, Please help me write a KQL query which reflects the devices which are missing windows security patches, the condition i want to apply here is, i need the device's sensor health="Active" a...
JEANE80
Sep 27, 2024Copper Contributor
Can you also help with a query to pull the top links for the last 30 days?
Clive_Watson
Sep 27, 2024Bronze Contributor
You didnt mention the Table or Column, but the syntax would be along these lines:
EmailUrlInfo
| summarize count() by Url
| top 10 by count_
| order by count_ desc
EmailUrlInfo
| summarize count() by Url
| top 10 by count_
| order by count_ desc