Forum Discussion
Problem with Log Analytics
Hi, I'm currently monitoring servers through azure log analytics. But currently I have a tab that says "others", meaning other servers that can't be displayed. How do I change the amount of displayable servers to like, top 10?
- Or you can check out this very useful blog by Stanislav_Zhelyazkov:
https://cloudadministrator.net/2018/03/22/top-10-charts-in-azure-log-analytics-and-application-insights/
2 Replies
To select the top 10 in a query, you could use something like this (summarize by Computer and top 10):
Event
| where (EventLevelName == "Error")
| where (TimeGenerated > ago(1days))
| summarize ErrorCount = count() by Computer
| top 10 by ErrorCount desc- Or you can check out this very useful blog by Stanislav_Zhelyazkov:
https://cloudadministrator.net/2018/03/22/top-10-charts-in-azure-log-analytics-and-application-insights/