Forum Discussion
Deleted
Mar 18, 2020Azure Monitor for VMs - Service Map - Cannot expand Nodes
After provisioning Azure Monitor for VMs, data collection worked fine and service map was working properly under Insights for the respective VMs. Currently, nodes can't be expanded in the graphical v...
Deleted
Mar 21, 2020It's working for us now - it seems like there might have been a lack of data or only partial data available, e.g. the nodes said "1 Server" or "7 Clients", but expanding the node returned no list of those items. The only thing I did between the inital post and it working again was to raise the daily data cap in the log analytics workspace. Thanks!
CliveWatson
Mar 23, 2020Former Employee
Hi, Glad to here its working now. Its always a challenge if you are data capping the workspace, as you cant be selective of the data that gets through (sounds like the expansion couldn't proceed as there wasn't data available) . Maybe you need to report on daily/weekly usage?
Example.
Go to Log Analytics and run query
let AllowedGBperDay = 5; // Set an Alert threshold
union withsource=TableName *
| where TimeGenerated > startofday(ago(1d))
| where _IsBillable == True
| summarize Entries = count(), SizeGB = round(sum(_BilledSize / (1024*1024*1024)),2) by TableName, _IsBillable
| order by SizeGB desc
| summarize AggregatedValue = sum(SizeGB)
// set to 1 (one) for threshold exceeded, which allows you to have an alert rule for gtr 0 (zero)
| extend AlertValue = iif(AggregatedValue > AllowedGBperDay,"1","0")
I use this in a Azure Monitor Alert.