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-04 08:29 PM
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)
Posted: 2020-07-04 08:29 PM
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)
Posted: 2020-07-04 08:29 PM
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)
Posted: 2020-07-04 08:29 PM
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)
Posted: 2020-07-04 08:29 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.