Re: [foxboro] Historical Alarms

  • From: "Boulay, Russ" <Russ.Boulay@xxxxxxxxxxxx>
  • To: "foxboro@xxxxxxxxxxxxx" <foxboro@xxxxxxxxxxxxx>
  • Date: Sun, 18 Dec 2011 18:02:16 -0500

Also...remember 5000 is the default.....maxinmum is 40000....as edited in the 
wp_am.cfg file...

While you can have an issue trying to retrieve too many historized alarms thru 
the CAD,....those are the configurable options.


-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On 
Behalf Of Francisco Hernandez
Sent: Sunday, December 18, 2011 6:36 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Historical Alarms

Thanks a lot TIM!

-----Mensaje original-----
De: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] En
nombre de Lowell, Timothy
Enviado el: sábado, 17 de diciembre de 2011 11:30 a.m.
Para: foxboro@xxxxxxxxxxxxx
Asunto: Re: [foxboro] Historical Alarms

Francisco,

You have four options to get the rest of the alarms out of AIM*:

1. Use histspy. This utility is in d:/opt/aim/bin. It is very non-intuitive
and hard to use, and the output is difficult to read, but if you can figure
out how it works, it will generate alarm data. I believe there is a tutorial
on the Invensys site or the Cassandra site somewhere, but I'm not sure
where.

2. Write some Excel VBA code. AIM* comes with one ODBC license. You need to
configure that, and then on some off-platform PC that is connected to your
I/A system by the third/fourth Ethernet port, you need to configure an ODBC
connection. Excel Visual Basic for Applications has built-in ODBC calls that
can be programmed to retrieve data from the AIM*Historian. I have done this,
but not recently, and I don't have access to the code. There is some sample
code in the Appendices of the AIM*Historian Administrators Guide, I believe.

3. Buy some more software. Invensys sells some data extraction products for
AIM*. PAS in Houston, Matrikon (now part of Honeywell), TiPS, Inc, LimeWare
from Brazil and many other third party vendors will sell you software to
manage your alarms. Most of these will require you to purchase an AIM*OPC
server license from Invensys (or a third party OPC server) with the
appropriate server hardware as well the vendor's software and appropriate
server hardware to run that. Obviously, this option is for when you have a
plant or company alarm management philosophy in place and you have enough
funding to implement it correctly.

4. Contact some of the folks on this list who have built their own alarm
management solutions. I've seen several on here that run small applications
to send their alarms to various open-source SQL databases. You can search
the archives at //www.freelists.org/archive/foxboro.

We've been complaining to Invensys forever about the inability to extract
data from AIM*. Invensys has chosen to discontinue development of AIM* and
focus on Wonderware InSQL as the historian of the future, but from what I've
heard, InSQL does not historize alarm data from the Foxboro I/A system
either. For that, you still need AIM* (or a third-party).

Thanks,
Tim
________________________________________
From: foxboro-bounce@xxxxxxxxxxxxx [foxboro-bounce@xxxxxxxxxxxxx] On Behalf
Of Francisco Hernandez [francisco.27.hernandez@xxxxxxxxx]
Sent: Saturday, December 17, 2011 9:04 AM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] Historical Alarms

Hi Everyone,


The Aim Historian Message Collector is configured in a P90 Host v8.6, so the
Process Alarms are been historicized. If I wish see the historian alarm I
open the Alarm History (AHD) in the Alarm Manager (CAD) Window. But it only
show the last 5000 Alarms. Actually the AIM Historian is Historicizing the
last 3 month of messages (Process Alarmas), Somebody know How Can I to view
the whole historian alarms, not only the last 5000?



Thanks!





 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at your
own risks. Read http://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 Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://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
 


*** Confidentiality Notice: This e-mail, including any associated or attached 
files, is intended solely for the individual or entity to which it is 
addressed. This e-mail is confidential and may well also be legally privileged. 
If you have received it in error, you are on notice of its status. Please 
notify the sender immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any other person. This email comes from a division of the Invensys 
Group, owned by Invensys plc, which is a company registered in England and 
Wales with its registered office at 3rd Floor, 40 Grosvenor Place, London, SW1X 
7AW (Registered number 166023). For a list of European legal entities within 
the Invensys Group, please go to http://www.invensys.com/en/legal/default.aspx.

You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail 
reception@xxxxxxxxxxxxx This e-mail and any attachments thereto may be subject 
to the terms of any agreements between Invensys (and/or its subsidiaries and 
affiliates) and the recipient (and/or its subsidiaries and affiliates).


 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://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:

  1. Home
  2. foxboro
  3. Archive
  4. 12-2011