Azure Monitor disk space used report

Question

Hi,&nbsp;I need some help creating a KQL query that shows the disk space used.&nbsp; The query would need to output something similar to the VM insights report that shows the current disk size and the disk space used.&nbsp;I have a query for free disk space but I'll need a query for used disk space so I can create an alert from the query.&nbsp;Thanks,D

pradeepdeiva · Answer

Try this&nbsp;InsightsMetrics | where Origin == "vm.azm.ms" and Namespace == "LogicalDisk" and Name == "FreeSpacePercentage" | extend Disk=tostring(todynamic(Tags)["vm.azm.ms/mountId"]) | summarize Disk_Free_Space = avg(Val) by Computer, Disk, _ResourceId | project Computer, Disk, Disk_Free_Space

dsm4201 · Answer

PradeepDeiva&nbsp;I'm a little closer now.&nbsp; I was wondering if theirs a way to show the output without the "_".&nbsp; So instead of seeing "Used_Space_Percentage" the output would show "Used Space %"?&nbsp;Also is there a way to show the output without the numbers after the decimal point?&nbsp; I used round in the query but I have to keep at least two spaces.&nbsp; Here's what I have for the query so far;&nbsp;InsightsMetrics| where TimeGenerated &gt;= ago(1h)| where Origin == "vm.azm.ms" and Namespace == "LogicalDisk" and Name == "FreeSpaceMB"| extend Disk = tostring(todynamic(Tags)["vm.azm.ms/mountId"]),Disk_Size_GB =(todynamic(Tags)["vm.azm.ms/diskSizeMB"]) / 1024| summarize Disk_Free_Space_GB = avg(Val) / 1024 by Computer, Disk, Disk_Size_GB, _ResourceId| extend Used_Space_GB = Disk_Size_GB - Disk_Free_Space_GB| extend Used_Space_Percentage = round((todouble(Used_Space_GB / Disk_Size_GB) * 100) ,2)| where Used_Space_Percentage &gt;= 90| project Computer, Disk, Disk_Size_GB, Disk_Free_Space_GB, Used_Space_GB, Used_Space_Percentage&nbsp;Thanks.&nbsp;

dsm4201 · Answer

PradeepDeiva&nbsp;Hi,&nbsp; thanks for the script but I'm looking for one that show's the disk's used space.&nbsp; I noticed this thread (https://techcommunity.microsoft.com/t5/azure-observability/help-with-disk-query-in-log-analytics/m-p/160239#M440) mentioning using a calculation to find the used space but they were also having issues with the query.Do you know if I can use another calculation to find the % UsedSpace?&nbsp;Thanks.

pradeepdeiva · Answer

DSM4201&nbsp;yea , for Linux - % free space and for Windows - %used space are not directcheck this link - https://www.catapultsystems.com/blogs/calculating-total-memory-and-total-disk-space-in-log-analytics/try adding a last column with the values got from free space and total size - we can calculate the %hope this helps

clive_watson · Answer

You can add text with [' '] =example:| project Computer, Disk, Disk_Size_GB, Disk_Free_Space_GB, Used_Space_GB, ['Used Space %']=Used_Space_Percentageproject round(value) - this will round the number up or down to the nearest whole number,so 1.1 would be 1 but 1.8 would be 2

Forum Discussion

Azure Monitor disk space used report

6 Replies

Resources