Alex/All, How can i access alarms historical data within AIM through ODBC? I did try but only succeeded to get Alarms for last 2 hours (within table IAALARMS;ALMESSALARMS...could be a different name). In fact, i would like accessing last year alarms. Eventually, which other software or interface i may consider using ? We would like benefit of the ODBC interface to fetch long term alarms. I believe this is feasible but the issue is how. Please advise on that. Thanks in advance. Regards, Aymen On Thu, Feb 21, 2008 at 4:28 PM, Johnson, Alex P (IPS) < alex.johnson@xxxxxxxxxxxxxxxx> wrote: > Alarm priorities are also kept by AIM*Historian in its alarm database > and that database can be accessed using: > > 1) OLE DB > 2) ODBC > 3) AIM*Inform > > > Regards, > > Alex Johnson > Invensys Systems, Inc. > 10900 Equity Drive > Houston, TX 77041 > 713.329.8472 (voice) > 713.329.1700 (fax) > 713.329.1600 (switchboard) > alex.johnson@xxxxxxxxxxxxxxxx > > > -----Original Message----- > From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] > On Behalf Of Grace, Kathy > Sent: Thursday, February 21, 2008 9:04 AM > To: foxboro@xxxxxxxxxxxxx > Subject: Re: [foxboro] Alarms priority > > Andreas, > > First ADMC does work on both Windows and Solaris on V7.1. ADMC is the > configurator used to configure the Alarm Manager displays (e.g. CAD, > UNACK, AHD, etc.) period. Fields configured on these displays will be > printed in alarm reports generated from an alarm display. That said, > however, you cannot use ADMC to add a field to be included in alarms > sent to an alarm printer (i.e. LP01 configured as a destination in your > GRxDYy compound parameters). This does not use the Alarm Manager > interface but uses the cs_alarm interface which does not, and cannot be > configured to, include the priority. Sorry. > > For future reference, if you ever move to 8.2 or later, the Message > Manager interface will print alarm priorities. > > Regards, > Kathy > > -----Original Message----- > From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] > On Behalf Of Aymen LAZAAR > Sent: Thursday, February 21, 2008 3:48 AM > To: foxboro@xxxxxxxxxxxxx > Subject: Re: [foxboro] Alarms priority > > > Thks Andreas, > Appreciate your kind help. > > We are using a Fox I/A V7.1 on Unix, can we still achieve the same > configuration but through another interface or tool as the one you sent > seems to be windows based. > > Thanks again for your help. > > Aymen > > > On 2/21/08, Weiss, Andreas <Andreas.Weiss@xxxxxxxxxxxx> wrote: > > > > Aymen, > > > > a short offline description with screenshots is on the way to > you.=3D3D20 > > > > - Call up the ADMC > > - select Alarm Formats for foxCAD > > - in the Alarm Format Scheme select the Cell Format Editor > > - click on Create Field and add a new field > > > > Please check the following documents: > > > > B0700AP_A.pdf > > > > b0700at_b.pdf > > > > Regards, > > Andreas > > > > > > ______________________________________________________________________ > > _ > > 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=3D3Djoin > > to unsubscribe: > mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave > > > > > > > -- =3D > > Aymen LAZAAR > > > =3D > > =3D > > _______________________________________________________________________ > 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 > =3D > > foxboro mailing list: //www.freelists.org/list/foxboro > to subscribe: > mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Djoin > to unsubscribe: > mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave > =3D > > > > * Confidentiality Notice: > This e-mail and any associated files are intended solely for the > individual=3D > or entity to whom they are addressed. Please do not copy it or use it > for =3D > any purposes, or disclose its contents to any other person. Further, > this e=3D > -mail and any associated files may be confidential and further may be > legal=3D > ly privileged. This email is from the Invensys Process Systems business > uni=3D > t of Invensys plc which is a company registered in England and Wales > with i=3D > ts registered office at Portland House, Bressenden Place, London, SW1E > 5BF =3D > (Registered number 166023). For a list of European legal entities > within t=3D > he Invensys Process Systems business group, please click here > http://www.in=3D > > vensys.com/legal/default.asp?top_nav_id=3D3D77&nav_id=3D3D80&prev_id=3D3D77= > . > > If you have received this e-mail in error, you are on notice of its > status.=3D > Please notify us immediately by reply e-mail and then delete this > message =3D > from your system. Thank you for your co-operation. You may contact our > Help=3D > desk on +44 (0)20 7821 3859 / 2105 or email > inet.hqhelpdesk@xxxxxxxxxxxxx T=3D > his e-mail and any attachments thereto may be subject to the terms of > any a=3D > greements between Invensys (and/or its subsidiaries and affiliates) and > the=3D > 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=3Djoin > to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave > = > > > > * Confidentiality Notice: > This e-mail and any associated files are intended solely for the > individual= > or entity to whom they are addressed. Please do not copy it or use it for > = > any purposes, or disclose its contents to any other person. Further, this > e= > -mail and any associated files may be confidential and further may be > legal= > ly privileged. This email is from the Invensys Process Systems business > uni= > t of Invensys plc which is a company registered in England and Wales with > i= > ts registered office at Portland House, Bressenden Place, London, SW1E 5BF > = > (Registered number 166023). For a list of European legal entities within > t= > he Invensys Process Systems business group, please click here > http://www.in= > vensys.com/legal/default.asp?top_nav_id=3D77&nav_id=3D80&prev_id=3D77. > > If you have received this e-mail in error, you are on notice of its > status.= > Please notify us immediately by reply e-mail and then delete this message > = > from your system. Thank you for your co-operation. You may contact our > Help= > desk on +44 (0)20 7821 3859 / 2105 or email inet.hqhelpdesk@xxxxxxxxxxxxx > T= > his e-mail and any attachments thereto may be subject to the terms of any > a= > greements 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 > > -- Aymen LAZAAR _______________________________________________________________________ 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