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 . Last Modified: β2024-04-04 04:10 AM
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 . Last Modified: β2024-04-04 04:10 AM
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 . Last Modified: β2024-04-04 04:10 AM
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 . Last Modified: β2024-04-04 04:10 AM
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 board - and gain access to more than 10,000+ support articles along with insights from experts and peers.