KACE Product Support

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.