EcoStruxure IT forum
A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Posted: 2020-07-05 08:21 PM
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.
Thanks, Adrian
(CID:146277590)
Posted: 2020-07-05 08:21 PM
This answer was originally posted on DCIM Support by Jef Faridi on 2019-07-03
Hi Adrian,
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):
Kind regards
(CID:146669820)
Posted: 2020-07-05 08:21 PM
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?
Regards
Adrian
(CID:146670867)
Posted: 2020-07-05 08:21 PM
This comment was originally posted on DCIM Support by Greg Sterling on 2019-07-10
Hello Adrian
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.
Regards
GregS
(CID:147194042)
Posted: 2020-07-05 08:21 PM
This comment was originally posted on DCIM Support by Adrian Jeitziner on 2019-07-12
HiGreg
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.
Regards
Adrian
(CID:147194729)
Posted: 2020-07-05 08:21 PM
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.
Regards
Greg Sterling
(CID:147194837)
Posted: 2020-07-05 08:21 PM
This answer was originally posted on DCIM Support by Brunner Ueli on 2019-07-10
Hi Jef
They wanna have this "Average Power Load" available in ETL
Adrian Jeitziner
(CID:146671517)
Posted: 2020-07-05 08:21 PM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.