SQL statement against ETL export reporting peak vs no circuit

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

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)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.