1. Logon to Kbox 1000 as Administrator
2. Select Reports
3. Under choose action dropdown select “Add New SQL Reportâ€Â
4. Paste the following SQL statement under the “SQL Select Statement Boxâ€Â
SQL:
select MACHINE.NAME AS SYSTEM_NAME,MACHINE.IP,MACHINE_DISKS.DISK_SIZE,MACHINE_DISKS.DISK_FREE,MACHINE_DISKS.NAME AS DISK_NAME from MACHINE_DISKS JOIN MACHINE ON (MACHINE.ID = MACHINE_DISKS.ID) where ((( MACHINE_DISKS.DISK_FREE < '5') AND MACHINE_DISKS.NAME like '%Drive C%')) order by MACHINE.NAME
Comments