[logs] anyone willing to share proper syslog SQL schema & data typing?

[Jason Haar]

David Corlette wrote:
> I personally work with Sentinel from Novell and the schema we use today is in many ways has yours as a subset.  We actually normalize all event data, whether it be syslog, SNMP, JDBC, WMI, etc into our single standard schema.
>
> Longer term, the plan is to move to XDAS (a standard event schema maintained by The Open Group) as a standard.  You can download the specification from here:
> http://www.opengroup.org/bookstore/catalog/p441.htm
>
> There's actually an open-source implementation of the standard called OpenXDAS, although you'd have to build parsers to translate from the native format into the XDAS format.
>   
Brilliant - hopefully just the sort of thing I was looking for - thanks :-)

-- 
Cheers

Jason Haar
Information Security Manager, Trimble Navigation Ltd.
Phone: +64 3 9635 377 Fax: +64 3 9635 417
PGP Fingerprint: 7A2E 0407 C9A6 CAF6 2B9F 8422 C063 5EBB FE1D 66D1