Re: [foxboro] FBM I/O Point Query
- From: "Sharon Childers" <dmarc-noreply-modpost@xxxxxxxxxxxxx> (Redacted sender "se_anderwald" for DMARC)
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Wed, 29 Jul 2020 13:06:02 +0000 (UTC)
select CPFBM AS CP,fbmtype,dev_id, BLOCKFBM AS FBM,CHANNEL,     Â
           rpad (fbmchan.compound,12," ") as compound, Â
     rpad (fbmchan.block,12," ") as block,IF(CHAR_LENGTH(description)
< 36,     CONCAT(left(description,36), '         Â
            '),     description) as
descriptionFROM FBMCHANÂ LEFT JOIN CONFIG_FBMS ON
FBMCHAN.BLOCKFBM=CONFIG_FBMS.BLOCKWHERE fbmchan.COMPOUND not LIKE "%_ECB%"ORDER
BY CP, FBM, CHANNEL
On Tuesday, July 28, 2020, 02:18:44 PM CDT, Stankiewicz, Anthony P.
<x2stanki@xxxxxxxxxxxxxx> wrote:
Steve,
In Foxray, if you open FBM manager, you can right-click on the upper left
column header "CP" and export to .xls or .txt. This will get everything (all
FBMS and all CPs), not just a single FBM.
Regards,
Tony S
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx <foxboro-bounce@xxxxxxxxxxxxx> On Behalf Of
RIVETT Stephen -EASTERNOPS
Sent: Tuesday, July 28, 2020 2:39 PM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] FBM I/O Point Query
EXTERNAL MAIL: Caution Opening Links or Files
________________________________
Hello,
 We have 25 100 Series I/O cabinets that we are going to be replacing with
200 Series I/O. The cabinets have good drawings and are set up well in
Foxboro so I am seeking input on how to set up an "advanced query" in System
Auditor (Foxray) so that we can build spreadsheets for field verification.Â
Please advise on whether it is possible to do this in bulk instead of using the
FBM manager on one FBM at a time.
 For anybody that is interested, these cabinets have TAs on the "front" and
FBMs on the "back" so we are going to be replacing the cabinets without major
reorganizing of I/O. Any additional thoughts & comments on this undertaking
would be appreciated.
Regards, Steve
Stephen Rivett
Senior P&C Supervisor | Eastern Operations - Lennox GS Ontario Power
Generation
(613) 352-3525 x 5406Â |Â (613) 217-2192Â |Â
Stephen.Rivett@xxxxxxx<mailto:Stephen.Rivett@xxxxxxx>
7263 Hwy. 33 West, PO Box 1000, Bath, Ontario, K0H 1G0 See how we are powering
the future of Ontario at
opg.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.opg.com_&d=DwIDAg&c=AgWC6Nl7Slwpc9jE7UoQH1_Cvyci3SsTNfdLP4V1RCg&r=JLvVFUtR2GVf4nldLBjwX6He_7ZkRP-esYv50YY3HqA&mEnjuIyWcPwW-2Si_YrsWG4LMW3gC8n2J4qktsrCzzk&s=xRf8FbDDE2vjNvOiOmUmdedpWnaRtq_nG13TXUItDSU&e=
________________________________
THIS MESSAGE IS ONLY INTENDED FOR THE USE OF THE INTENDED RECIPIENT(S) AND MAY
CONTAIN INFORMATION THAT IS PRIVILEGED, PROPRIETARY AND/OR CONFIDENTIAL. If you
are not the intended recipient, you are hereby notified that any review,
retransmission, dissemination, distribution, copying, conversion to hard copy
or other use of this communication is strictly prohibited. If you are not the
intended recipient and have received this message in error, please notify me by
return e-mail and delete this message from your system. Ontario Power
Generation Inc.
_________________________________________________________________________
This mailing list is neither sponsored nor endorsed by Schneider Electric
(formerly The Foxboro Company). Use the info you obtain here at your own
risks. See the disclaimer at
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.thecassandraproject.org_disclaimer.html&d=DwIDAg&c=AgWC6Nl7Slwpc9jE7UoQH1_Cvyci3SsTNfdLP4V1RCg&r=JLvVFUtR2GVf4nldLBjwX6He_7ZkRP-esYv50YY3HqA&mEnjuIyWcPwW-2Si_YrsWG4LMW3gC8n2J4qktsrCzzk&sëb7CCpBpWdP4Cyh2KMXvtucnibW7BC0oSeYtb1v1T0&e
foxboro mailing list:Â Â Â Â Â Â Â
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_list_foxboro&d=DwIDAg&c=AgWC6Nl7Slwpc9jE7UoQH1_Cvyci3SsTNfdLP4V1RCg&r=JLvVFUtR2GVf4nldLBjwX6He_7ZkRP-esYv50YY3HqA&mEnjuIyWcPwW-2Si_YrsWG4LMW3gC8n2J4qktsrCzzk&s=xgSHEZsI3lV0duJacrJiYd28qKUhqEJFNSXr1vaUn-E&eto
subscribe:Â Â Â Â Â
mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:Â Â Â Â
mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
_________________________________________________________________________
This mailing list is neither sponsored nor endorsed by Schneider Electric
(formerly The Foxboro Company). Use the info you obtain here at your own
risks. See the disclaimer at www.thecassandraproject.org/disclaimer.html
foxboro mailing list:Â Â Â Â Â Â Â
//www.freelists.org/list/foxboro
to subscribe:Â Â Â Â Â
mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:Â Â Â Â
mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
_________________________________________________________________________
This mailing list is neither sponsored nor endorsed by Schneider Electric
(formerly The Foxboro Company). Use the info you obtain here at your own
risks. See the disclaimer at www.thecassandraproject.org/disclaimer.html
foxboro mailing list:
//www.freelists.org/list/foxboro
to subscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
Other related posts: