/build/static/layout/Breadcrumb_cap_w.png
11/08/2017 854 views
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

Comments


All Answers

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.

Answered 11/09/2017 by: chucksteel
Red Belt

  • 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