System Auditor poll point data to Master list
Ken Flood
Hi Ricardo, thanks in advance for any help you can share we us.
I have System Auditor and need to update my I/O master spread sheet. We are growing and the contractors are in need of the list. Is there a way to pull the point data from all the CP’s in the FBM Manager list of FBM’s?
As you can see this manual update is killing me. We have 6 Plants and all need updated (thousands of points) to current status.
Even if we could go merge all fbm’s together in each CP would help tremendously. Any help is appreciated, thank you Ken Flood
Stankiewicz, Anthony P.
Ken,
Just a thought. Have you tried to right-click in the CP column of the FBM Manager (picture) list? It should let you export to a spreadsheet. Many of the windows allow this.
Regards,
Tony Stankiewicz
From: limewar...@googlegroups.com <limewar...@googlegroups.com>
On Behalf Of Ken Flood
Sent: Friday, April 22, 2022 10:45 AM
To: limewar...@googlegroups.com
Subject: {foxray} System Auditor poll point data to Master list
EXTERNAL MAIL: Caution Opening Links or Files
--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
limeware-foxr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/limeware-foxray/PH0PR09MB7868ACF779DD0F6F7DACC2C4A1F79%40PH0PR09MB7868.namprd09.prod.outlook.com [groups.google.com].
Ken Flood
Sent: Friday, April 22, 2022 10:48:51 AM
To: limewar...@googlegroups.com <limewar...@googlegroups.com>
Subject: {foxray} RE: System Auditor poll point data to Master list
Currano, Joe
You can do this with an Advanced Query, run anytime and export to Excel format, or set up automatic email reports.
Try the queries below and see if one of them gives you what you want. I think “FBM per Area and Enclosure” is one of the Default SQLs that Foxray lets you Import in Advanced Query. Note: Some of these take a long time to run when you have a large database.
The last one “FBM Info” does not give the connected points but may be useful as an addition to the others, in case you need the FBM type etc listed.
FBM Configured Channels - Advanced Query
SELECT `CPFBM` as `CP`,`BLOCKFBM` as `FBM`,`CHANNEL`,`COMPOUND`,`BLOCK`,`PARAMETER`,`DESCRIPTION` FROM `FBMCHAN` order by FBM, CHANNEL
===
FBM Channels By CP - Advanced Query
SELECT CPFBM as "CP", BLOCKFBM as "FBM", FBMTYPE, CHANNEL, fbmchan.COMPOUND, fbmchan.BLOCK, fbmchan.PARAMETER, DESCRIPTION, AREA, ENCLOSURE from FBMCHAN left join (fbmperenc, config_fbms) on (fbmperenc.COMPOUND=COMPOUNDFBM and fbmperenc.BLOCK=BLOCKFBM and config_fbms.BLOCK=BLOCKFBM) union SELECT CP, BLOCK, FBMTYPE, CHANNEL, '','','','SPARE', AREA, ENCLOSURE from spare_channel order by CP, FBM, CHANNEL+0, AREA, ENCLOSURE
===
FBM per Area And Enclosure - Advanced Query (Import Query from Default SQLs)
select AREA, ENCLOSURE, CPFBM, COMPOUNDFBM, BLOCKFBM, FBMTYPE, CHANNEL, fbmchan.COMPOUND, fbmchan.BLOCK, fbmchan.PARAMETER, DESCRIPTION from FBMCHAN left join (fbmperenc, config_fbms) on (fbmperenc.COMPOUND = COMPOUNDFBM and fbmperenc.BLOCK = BLOCKFBM and config_fbms.BLOCK = BLOCKFBM) union SELECT AREA, ENCLOSURE, CP, COMPOUND, BLOCK,'' , FBMTYPE, CHANNEL, '','','SPARE' from spare_channel order by AREA, ENCLOSURE, CPFBM, BLOCKFBM, CHANNEL+0
===
FBM Info - Advanced Query
SELECT * FROM `CONFIG_FBMS`