Network Query in OMS Creation

[Eldad Somech]

Hi There, 

I'm Trying to create a Custom Network query for Transmitted and received Traffic from all the servers in Azure. 

from the query i'm getting results, but when i'm creating a new tile it's doesn't show anything. 

also, i want to add a filter that shows traffic only from the past hour. 

Thanks, 

 i used this -

Perf
| where ObjectName == "Network"
| where ( CounterName == "Total Bytes Transmitted" )

[#2]

Hi Eldad,

First, here are two (identical) filters to show only data from the last hour:

Perf
| where TimeGenerated > now(-1h) 
| where ObjectName == "Network"
| where ( CounterName == "Total Bytes Transmitted")

Perf
| where TimeGenerated > ago(1h) 
| where ObjectName == "Network"
| where ( CounterName == "Total Bytes Transmitted")

you can choose the syntax you prefer, the meaning is exactly the same.

Regarding the tile not showing data - a bit obscure... do you mean a View Designer tile? does the problem still occur?

HTH,

Noa

[#3]

Thank you Noa for the quick response :) 

i eventually used this:

Perf | where ObjectName == "Network Interface" and ( CounterName == "Bytes Received/sec" ) and TimeGenerated > now(-10m) | where ( Computer == "computername" or Computer == "computername" or Computer == "computername" or Computer == "computername" ) | summarize AggregatedValue = count() by Computer

and i received this results in the tile - attached. 

and yes, issue still occurs. 

if i use your counter i can only see 1 VM showing traffic 

with the other counter "Bytes Received/sec" i can see all VM's

i want to have the ability the to see the traffic (send and received) with sparklines and not with dots as i sent you via attachment. 

Thanks!