/build/static/layout/Breadcrumb_cap_w.png

How to monitor low disk space on drive C:

1. Make a new machine inventory notifiation

2. Save it. 

3. Use the below MySQL query to search for machines where drive C: has less than 15% free space. 

Modify as needed. 

 

SQL select statement:

SELECT MACHINE_DISKS.PERCENT_USED AS MACHINE_DISKS_PERCENT_USED, MACHINE.NAME AS SYSTEM_NAME FROM MACHINE_DISKS JOIN MACHINE ON (MACHINE.ID = MACHINE_DISKS.ID) WHERE   MACHINE_DISKS.PERCENT_USED > '85' AND MACHINE_DISKS.NAME LIKE '%Drive C:%'

Posted 12 years ago 2693 views

Comments

  • Never had to monitor low disk space yet but I will save this for later in case I have to..thx - CML_50oldfox 12 years ago
  • I like the simplicity, added MACHINE_DISKS.DISK_FREE AS FREE_SPACE to the select statement so the daily morning report gives us how many gigs are available as well. - Wildwolfay 11 years ago
This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ