SQL statement against ETL export reporting peak vs no circuit

[DCIM_Support]

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]

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]

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.