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!
This answer was originally posted on DCIM Support by Ed Tarento on 2018-08-01
Great idea. If no one else responds I'll try but it won't be till Sept sorry
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.
Discuss challenges in energy and automation with 30,000+ experts and peers.
Find answers in 10,000+ support articles to help solve your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!