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.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-04 09:04 PM
This question was originally posted on DCIM Support by Wes Burhoe on 2018-08-01
Hello, Wondering if anyone has done this before... We deploy BCM and sensor map readings into DCO for all poles. I need a SQL statement which generates a data set where there is a peak and/or average kW/Amp measurement other than 0, but there is no connected device defined at the pole.
This would be useful for audits, to ensure all power circuits are properly modeled in DCO. Thoughts, ideas, and SQL examples welcome!
(CID:132671166)
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 09:05 PM
This answer was originally posted on DCIM Support by Ed Tarento on 2018-08-01
Hi Wes
Great idea. If no one else responds I'll try but it won't be till Sept sorry
Cheers
Ed
(CID:132671226)
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 09:05 PM
This answer was originally posted on DCIM Support by Greg Sterling on 2018-08-03
Following up with Wes offline. It would appear based on testing the ETL export data for power path is based on completed circuits. I do not believe there is currently a method to query unassigned breakers directly ... you would have to be able to identify the items missing from the panel.
(CID:133370509)
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 09:05 PM
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.