Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84819members
354273posts

SQL statement against ETL export reporting peak vs no circuit

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.

DCIM_Support
Picard
Picard

SQL statement against ETL export reporting peak vs no circuit

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)

3 Replies 3
DCIM_Support
Picard
Picard
0 Likes
0
245

Re: SQL statement against ETL export reporting peak vs no circuit

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
Picard
Picard
0 Likes
0
244

Re: SQL statement against ETL export reporting peak vs no circuit

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
Picard
Picard
0 Likes
0
244

🔒 Closed

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