/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


How to run a report in K1000 that shows how much I can save in power?

12/18/2014 2311 views
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?


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

All 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
Third Degree Blue Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ