SOLVED Running a CMPivot to get query of free diskpace

[CodyB]

Hello;

I'm sure this is something simple but I can't seem to get it. I'm running a CMPivot on a Device Collection to get which servers have less then 10 GB of free space on the C: drive. Note that each of the servers in the device collections have at lease 2 drives.

Here's a sample of my query:
Disk | where (Name == 'C:') | where (FreeSpace <= 85899345920) | order by FreeSpace asc
Disk | where (Name == 'C:') | where (FreeSpace < 85899345920) | order by FreeSpace asc

I've tried both and each one gives me the same results. I only want to see servers that are less than 10 GB of free space on the C: drive. What am I missing in my query statement?

 

[AhmedLS]

Hello;

I'm sure this is something simple but I can't seem to get it. I'm running a CMPivot on a Device Collection to get which servers have less then 10 GB of free space on the C: drive. Note that each of the servers in the device collections have at lease 2 drives.

Here's a sample of my query:
Disk | where (Name == 'C:') | where (FreeSpace <= 85899345920) | order by FreeSpace asc
Disk | where (Name == 'C:') | where (FreeSpace < 85899345920) | order by FreeSpace asc

I've tried both and each one gives me the same results. I only want to see servers that are less than 10 GB of free space on the C: drive. What am I missing in my query statement?

i use this in a collection query to get everything with less than 10Gig.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_LOGICAL_DISK.DeviceID = "C:" and SMS_G_System_LOGICAL_DISK.FreeSpace <= 10000

 

[CodyB]

I figured out what I was doing wrong with query search within the CMPivot. I was using BITS instead of BYTES on my less than or equal paramater.

Thanks for the suggustion thoug, AhmedLS.

 

[Prajwal Desai]

Here is a blog post that explains how to use CMpivot to get the free disk space - https://www.prajwaldesai.com/use-cmpivot-to-find-disk-size-and-free-space/