This question was originally posted on DCIM Support by Adrian Jeitziner on 2019-07-01
How can we read "Measured Average Power Loads"? DCO Analytics tool does not provide any data, also ETL "dbo.swo_kpi" seems to miss this figure.
This answer was originally posted on DCIM Support by Jef Faridi on 2019-07-03
If we right-click on associated device (such as UPS or rack pdu) > Properties > External Systems > Device, then we should be able to read the measured average power (based on user defined period, default is 30 days):
This answer was originally posted on DCIM Support by Adrian Jeitziner on 2019-07-08
Hi Jeff. Yes, I do see those values. How do I get them via ETL or in the Analytics tool?
This comment was originally posted on DCIM Support by Greg Sterling on 2019-07-10
If you query the configuration_item_power_path table for the ci_id of the PDU do you see the average power values you expect to see in the pp_average_power field?
Sample query would be:
select * from configuration_item_power_path where ci_id = '<ci_id_of_power_device>';
In some cases this table may have the value you're looking for.
This comment was originally posted on DCIM Support by Adrian Jeitziner on 2019-07-12
Thanks for your helpful answer!
We actually do get some figures with your query from a DCE we have in the US. Unfortunately we do not get any value (NULL) from other DCEs we have installed in other places. This is odd. I start to believe that this is related to other issues we have with device associations.
This comment was originally posted on DCIM Support by Greg Sterling on 2019-07-12
You are correct. If your device associations are incorrect then the results in the export database will be inconsistent. They are worth checking.
This answer was originally posted on DCIM Support by Brunner Ueli on 2019-07-10
They wanna have this "Average Power Load" available in ETL
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!