Azure monitoring
Hello! First and foremost, I'm new to Azure and Azure monitoring. That's why I'm starting this conversation. I'm currently trying to migrate our SolarWinds monitor into the Azure monitoring portal, but I'm unable to carry on because my knowledge about queries is absolutely minimum. I would like some assistance when it comes to queries, does anybody for instance know a query to monitor the CPU load on different computers and/or servers? And which tile in the designer should I use for this query? I hope some of you can help me out 🙂 Kind regards, Rik
Barchart ignoring one data series
The following query Heartbeat | where TimeGenerated >= startofday(ago(2d)) | where Computer == "ADMIN-PC" or Computer == "SERVER-PC" | summarize dcount(Computer) by t = endofday(TimeGenerated) , Computer | sort by t, Computer | render barchart kind=default produces the following table of 6 record in two sets: I'd expect to see a barchart with two series, but the result only shows one: The behavour is consistent. When I chose three series only two will be displayed. Do I miss anything? Regards JörgCan't create dashboard
Hi, I'm trying to create a line dashboard with the following query: Perf | where CounterName == "% Committed Bytes In Use" and TimeGenerated > ago(2h) | summarize average_committed_bytes_percent = avg(CounterValue) by Computer | where average_committed_bytes_percent < 50 and when I click apply i get the error (400) Failed to resolve entity TimeGenerated. This happens even after I remove the "and TimeGenerated > ago(2h)" condition. I don't get what's wrong. Can you help me? Thanks in advance.Group similar Process name in LogsAnalytics
Hi, I am looking for a query where I can get % Process CPU for specific Process. My main concern is that I would like to group some of them. For instance: "ZSAService", "ZSATunnel" and "ZSATray" sould all been group under ZScaler My current query : Perf | where Computer contains "sl2" | where ObjectName == "Process" and CounterName == "% Processor Time" | where (InstanceName contains "Sysmon" or InstanceName contains "CSFalconSer" or InstanceName contains "ZSA" ) | summarize avg(CounterValue) by InstanceName, bin(TimeGenerated, 1d) | render timechart title = "% CPU SECURITE" and the current result:
