EcoStruxure IT forum
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Link copied. Please paste this link to share this article on your social media post.
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)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
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)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
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)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
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)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-04 08:29 PM . Last Modified: 2023-10-22 03:43 AM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Link copied. Please paste this link to share this article on your social media post.
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.