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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share