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

Comments

  • Do you have any power management settings configured on the operating system? Do you know the power consumption of the machines when idle?
Please log in to comment

Community Chosen Answer

1
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.



Answered 12/18/2014 by: h2opolo25
Red Belt

Please log in to comment

Answers

0
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

Answered 12/23/2014 by: getElementById
Second Degree Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity