Are there reports that we can pull as to how our power is being utilized in our OU from the K1000 Kace system?

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

I believe the following SQL query yields the computers that are powered on and connected to the KBOX:

SELECT KBSYS.SMMP_CONNECTION.KUID, CLIENT_CONNECTED, ORG1.MACHINE.NAME FROM KBSYS.SMMP_CONNECTION

JOIN ORG1.MACHINE on MACHINE.KUID = SMMP_CONNECTION.KUID

WHERE CLIENT_CONNECTED = 1;

That would give you a starting point. From there you would need to find a way to coorelate the power usage based on those machines. The easiest way to do that might be to build a list of models and their power usage which could be pulled into the query. You could create an asset type that holds computer models and one field could be the average power draw for that model of system. You could then (through some complicated joins) get the power usage per computer and use that to calculate a sum of power being used on campus.

This would be an interested project and I'd like to know if you make progress. 

Answered 04/12/2012 by: chucksteel
Red Belt

  • thanks Chucksteel
    I have not tested this yet but will do this soon
    regards
    Burtono
Please log in to comment
Answer this question or Comment on this question for clarity