Re: [foxboro] Sysmon messages from AIM*
- From: "Kubbenga, Otto" <otto.kubbenga@xxxxxxxxxxxxxxxx>
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Fri, 11 May 2007 08:02:24 -0400
Hi David,
Attached a dump (in Excel) from the AIM sys mon message table.
This data is retrieved through an ODBC connection.
Note we had some issues in AIM-ODBC, however these are very nicely
resolved by FoxMass.
Below the AIM definition of the message table:
1 CREATE MSG "LEGACY SYSMONMSG"
DEFN "GROUP = 1,Y,STRING,32"
DEFN "MESSAGE = 2,Y,STRING,32"
DEFN "TIME = 3,Y,LONG,1"
DEFN "TIME_TAG = 4,Y,STRING,21"
DEFN "VALID_TIME = 5,Y,SHORT,1"
DEFN "MONO_COUNT = 6,Y,SHORT,1"
DEFN "SEQ_NO = 7,Y,SHORT,1"
DEFN "PRIORITY = 8,Y,SHORT,1"
DEFN "MSG_NAME = 9,Y,STRING,11"
DEFN "SMON_NAME = 10,Y,STRING,9"
DEFN "STATION = 11,Y,STRING,9"
DEFN "SRC_NAME = 12,Y,STRING,27"
DEFN "TEXT = 13,Y,STRING,81"
Regards
Otto Kubbenga
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx]
On Behalf Of David Johnson
Sent: Friday, May 11, 2007 1:37 PM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] Sysmon messages from AIM*
1) I remember AIM (before it got splatted by Invensys or SimSci) when
it was a Biles & Associates product.
2) I am still in search of a good way to extract sysmon messages from
AIM*. Currently we are working on ODBC calls from VB to get these,
but unlike the sample data (which we have working), the message data
doesn't appear to have a table name (that we can figure out), even
though there are messages in the historian.
I hope someone has the answer to this, because the forehead is
begining to ache.
Thanks,
David
_______________________________________________________________________
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:
The information contained in this electronic message and any attachment(s) to
this message are intended for the exclusive use of the recipient(s) and may
contain confidential, privileged or proprietary information. If you are not the
intended recipient, please notify the sender immediately, delete all copies of
this message and any attachment(s). Any other use of the E-Mail by you is
prohibited.
-- No attachments (even text) are allowed --
-- Type: application/vnd.ms-excel
-- File: sysmonmsg.xls
-- Desc: sysmonmsg.xls
_______________________________________________________________________
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:
