Low free disk devices query

Question

How can we get the low free disk devices query or report? For example, I want to create a collection that contains all the devices with free disk less than 20 GB.

Answer 1

There are built-in canned reports (presuming you have your Reporting Point setup)

One is called "Computers with low free disk space (less than specified % free)

and the other is called "Computers with low free disk space (less than specified MB free)"

Are those out-of-the-box, canned reports not valid for your requirements?

Answer 2

Hi,

Thank you for posting in Microsoft Q&A forum.

1,We can use the LogicalDisk entry in CMPivot to list all machines with low free space. The query to list all machines with free space less than 20 GB is as below:

LogicalDisk | where FreeSpace < 20000

2,And then we can create a collection accordingly in CMPivot. As shown below in my lab.

3,Also we can use below in a collection query to achieve the same thing.

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 <= 20000

Hope above information helps.

Best regards,

Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.