How to run a report in K1000 that shows how much I can save in power?
I am trying to find a report that I can run on my K1000 to compare power savings. I need to find out how much I would save in energy savings if I turned off a large group of workstations each night for six hours. I want to be able to have a report showing these results
1 Comment
[ + ] Show comment
-
Do you have any power management settings configured on the operating system? Do you know the power consumption of the machines when idle? - EdT 10 years ago
Answers (2)
Please log in to answer
Posted by:
h2opolo25
10 years ago
Do you still have the default reports from KACE? There were a couple of reports there that did that. They would need minimal customization, if any.
Posted by:
getElementById
10 years ago
h20polo25 is correct. There are a number of Power Usage reports in the kbox.
Here's the SQL for the "Power Saving - Three Months" report incase you don't have it.
SELECT NAME, MAC, CUR_MONTH, CUR_HOURS, PREV_MONTH_HOURS, PREV_MONTH2_HOURS, (PREV_MONTH_HOURS-CUR_HOURS) AS CUR_HOURS_SAVED, (PREV_MONTH_HOURS-CUR_HOURS)*150/1000 AS kWh_SAVED, (PREV_MONTH_HOURS-CUR_HOURS)*150/1000*.15 AS SAVED, (PREV_MONTH_HOURS-CUR_HOURS)/PREV_MONTH_HOURS*100 as CUR_PCT_SAVED, (PREV_MONTH2_HOURS-PREV_MONTH_HOURS) as PREV_HOURS_SAVED, (PREV_MONTH2_HOURS-PREV_MONTH_HOURS)*150/1000 as PREV_kWh_SAVED, (PREV_MONTH2_HOURS-PREV_MONTH_HOURS)*150/1000*.15 as PREV_SAVED, (PREV_MONTH2_HOURS-PREV_MONTH_HOURS)/PREV_MONTH2_HOURS*100 as PREV_PCT_SAVED FROM (SELECT NAME, MAC, DATE_FORMAT(NOW(), '%Y-%m') AS CUR_MONTH, (select AVG(HOURS) from MACHINE_DAILY_UPTIME MDU WHERE DAY > LAST_DAY(SUBDATE(NOW(), INTERVAL 1 MONTH)) AND M.ID = MDU.MACHINE_ID ) AS CUR_HOURS, (select AVG(HOURS) from MACHINE_DAILY_UPTIME MDU WHERE DAY BETWEEN (ADDDATE(LAST_DAY(SUBDATE(NOW(), INTERVAL 2 MONTH)), INTERVAL 1 DAY)) AND LAST_DAY(SUBDATE(NOW(), INTERVAL 1 MONTH)) AND M.ID = MDU.MACHINE_ID ) AS PREV_MONTH_HOURS, (select AVG(HOURS) from MACHINE_DAILY_UPTIME MDU WHERE DAY BETWEEN (ADDDATE(LAST_DAY(SUBDATE(NOW(), INTERVAL 3 MONTH)), INTERVAL 1 DAY)) AND LAST_DAY(SUBDATE(NOW(), INTERVAL 2 MONTH)) AND M.ID = MDU.MACHINE_ID ) AS PREV_MONTH2_HOURS from MACHINE M WHERE M.CHASSIS_TYPE = 'desktop') AS AVERAGES ORDER BY NAME
