/build/static/layout/Breadcrumb_cap_w.png

Make a report only look at C drive space?

Hello,

I have a report set up that emails me daily with machines who have less than 5 GB of space left on their hard drives. This report has been set up for years and works great to intercept problems before they start. (Windows 7 machines)

Google has recently introduced a tool called Drive File Stream.  It mounts a drive ("G") and allows users to access their Google Drive storage through Windows Explorer. The tool mounts that as a drive letter, and the kbox agent is picking that up... But there is no space on that drive since it's just "streaming" it to Google...  Here's what the inventory looks like:
wMdwDc.jpeg

So my report is picking up those machines who have installed that utility, and therefore an inaccurate report on who is short on space is being generated.

I'm trying to figure out if I can 1) limit the report to only look at C or 2) somehow else have it ignore Google Drive File Stream.

Thanks!






0 Comments   [ + ] Show comments

Answers (1)

Posted by: chucksteel 6 years ago
Red Belt
0
Here is the report that I use:
SELECT M.ID, M.NAME, D.NAME as "Disk Name", D.DISK_SIZE, D.DISK_USED, D.DISK_FREE
FROM ORG1.MACHINE M
JOIN MACHINE_DISKS D on M.ID = D.ID
WHERE DISK_FREE < 10  and DISK_SIZE > 0
AND (D.NAME like "Drive C:%" OR D.NAME like "Drive / %")
Note that I am checking for disks with less than 10GB free. In your case, adding the DISK_SIZE > 0 should filter out the Google Drive mount, but adding the limit on drive name will help. Also, my report targets both Windows and macOS devices, so I also make sure the drive is the root volume.


Comments:
  • Thanks! I think what I'm really looking for is a way to do this in the wizard. My query limits some results to just one building (based on name) and also manually excludes some machines, and - not being an SQL expert - I was hoping for an easy way to accomplish this... Though I fear I'm at the mercy of the K1 software if I want to use the wizard.

    For what it's worth, this is my current query:
    SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE LEFT JOIN MACHINE_DISKS ON (MACHINE_DISKS.ID = MACHINE.ID) WHERE ((MACHINE_DISKS.DISK_FREE < '5') AND (MACHINE.NAME like '%vhs%') AND (MACHINE.NAME != 'VHS-SPED17INCH')) GROUP BY MACHINE.ID - sundermannc@wdmcs.org 6 years ago
    • Change this: (MACHINE_DISKS.DISK_FREE < '5')
      to this:
      (MACHINE_DISKS.DISK_FREE < 5 and MACHINE_DISKS.DISK_SIZE > 0) - chucksteel 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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