Rack weight per Rack/Cage using ETL

[DCIM_Support]

This question was originally posted on DCIM Support by Vineet K. Sarin on 2018-07-21

---

Hi,

We have been trying to gather if we can get the Rack weight per rack using the ETL. Anyone who has experience on this area?

(CID:132667423)

[DCIM_Support · Accepted solution]

This answer was originally posted on DCIM Support by Niels Kjeldsen on 2018-08-03

---

Hi Vineet

Sorry for the delayed answer.

Yes that is possible. The data is available in the swo_kpi table.

The query below should get you started.

select ci_name, kpi_value, kpi_serie_type, ci_type from swo_kpi k, configuration_item ci where kpi_serie_type = 'TOTAL_WEIGHT' and k.ci_id = ci.ci_id;

Best,

Niels

(CID:133367416)

[DCIM_Support]

This comment was originally posted on DCIM Support by Vineet K. Sarin on 2018-08-03

---

Thanks Niels , Let me work using this.

(CID:133367474)

[DCIM_Support]

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