Dec 12 2018
05:15 AM
- last edited on
Apr 07 2022
05:34 PM
by
TechCommunityAP
Dec 12 2018
05:15 AM
- last edited on
Apr 07 2022
05:34 PM
by
TechCommunityAP
Hi all
I got this query that shows me Used disk space in % for every disk in the vm.
Now i want to collect all the information in a Dashboard design that will show me a Diagram(Lines) for a whole day what changes been made and when in a past day.
This is the query i got for now working, but i got only a list in my dashboard.
*******************************************************************************************************
Perf
| where TimeGenerated > ago(1h)
| where ObjectName == "Logical Disk" and CounterName == "% Used Space"
| summarize (TimeGenerated, Used_Space_Percent)=arg_max(TimeGenerated, CounterValue) by Computer, InstanceName
*******************************************************************************************************
Dec 13 2018 11:53 PM
SolutionBelow query should help you:
Perf | where TimeGenerated > ago(1h) | where ObjectName == "Logical Disk" and CounterName == "% Used Space" | extend ComputerDrive = strcat(Computer, ' - ', InstanceName) | summarize Used_Space_Percent = max(CounterValue) by ComputerDrive, bin(TimeGenerated, 1h) | render timechart
A few things to note:
- value of computer and drive is concatenated. the render cannot visualize more than one column at a time this we create a single column out of those two
- I am using bin to put the values in buckets in time range of 1 hour. You can change the interval to your liking
- I am using max() function to get the maximum value available for each hour. You can use other functions like min(), avg(), percentile(), etc. Depends on your scenario.
Dec 17 2018 12:40 AM
Dec 13 2018 11:53 PM
SolutionBelow query should help you:
Perf | where TimeGenerated > ago(1h) | where ObjectName == "Logical Disk" and CounterName == "% Used Space" | extend ComputerDrive = strcat(Computer, ' - ', InstanceName) | summarize Used_Space_Percent = max(CounterValue) by ComputerDrive, bin(TimeGenerated, 1h) | render timechart
A few things to note:
- value of computer and drive is concatenated. the render cannot visualize more than one column at a time this we create a single column out of those two
- I am using bin to put the values in buckets in time range of 1 hour. You can change the interval to your liking
- I am using max() function to get the maximum value available for each hour. You can use other functions like min(), avg(), percentile(), etc. Depends on your scenario.