Measured Average Load

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.