Kace 1000 how to run a report to populate a database and then query that database
I have a need to monitor server disc space usage over time. Can this be done with Kace reporting?
Thanks
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
dugullett
11 years ago
This is about as close as you can get without a 3rd party tool. You can schedule this report to run when needed.
SELECT M.NAME AS 'Machine Name', MD.NAME as 'Disk Name', DISK_USED, DISK_FREE, DISK_SIZE, PERCENT_USED FROM MACHINE M LEFT JOIN MACHINE_DISKS MD ON M.ID=MD.ID ORDER BY M.NAME, MD.NAME
Comments:
-
That report can also be modified if you are looking at a certain subset of machines. It can also be set to include only machines with 90% used. Let me know if you need it modified to include that. - dugullett 11 years ago
-
I would love to have the modification for 90% used. Thank you. - nadecats 11 years ago
-
Change the 90 to match the percentage you need.
SELECT M.NAME AS 'Machine Name', MD.NAME as 'Disk Name',
DISK_USED, DISK_FREE, DISK_SIZE, PERCENT_USED
FROM MACHINE M
LEFT JOIN MACHINE_DISKS MD ON M.ID=MD.ID
WHERE PERCENT_USED >= '90'
ORDER BY M.NAME, MD.NAME
You can also add in OS. I usually like to keep mine separate (Mac vs. PC).
SELECT M.NAME AS 'Machine Name', MD.NAME as 'Disk Name',
DISK_USED, DISK_FREE, DISK_SIZE, PERCENT_USED
FROM MACHINE M
LEFT JOIN MACHINE_DISKS MD ON M.ID=MD.ID
WHERE PERCENT_USED >= '90'
AND OS_NAME LIKE 'MICROSOFT%'
ORDER BY M.NAME, MD.NAME - dugullett 11 years ago
-
Thank You. - nadecats 11 years ago
Posted by:
SMal.tmcc
11 years ago
not really that part of the k1000 is deisgned as a reporting tool not an alerting tool.
If you cannot purchase monitoring software MS system center you can find free tools on the web to do this.
PSinfo cam be configured in a VB script or use something like
http://www.netwrix.com/disk_space_monitor_freeware.html
