Re: win32_NTLogEvent
- From: "mn_ms_user" <mnmsuser@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 14:01:04 -0700
After further research I've determined that the TimeWritten field is actually
a string value. When I search for win32_NTLogEvent on MSDN, I see more fields
that I have listed. Just pulling the fields below does not give me all of the
event information. There are a few fields that contain arrays. For example:
There is a Data field which is an array of ints, and InsertionStrings which
is an array of strings. The InsertionStrings field needs to be pulled for the
additional information it will give specifically for the Security event log.
Any ideas how to get that information into a SQL field?
Thanks.
"S??I" wrote:
> in my point of view do not user int type all, leave them all as char,
> because for example the eventid or record number aren't really numbers in
> the sense of algebraic operations (plus, minus, etc) you will only use them
> for comparison in the same manner you use strings.
>
> cheers,
> S@mi
>
>
> "mn_ms_user" <mn_ms_user@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:9FC77612-911F-494F-9940-5E37D9AE6B6A@xxxxxxxxxxxxxxxx
> >I am trying to export the event logs from my servers to a database, but I'm
> > not sure of the data types I need for the SQL database. The datatypes I am
> > currently using are:
> > Catagory: char
> > ComputerName: char
> > EventCode: int
> > Message: char
> > RecordNumber: int
> > SourceName: char
> > TimeWritten: datetime
> > Type: char
> > UserName: char
> >
> > It works up to the point it's getting ready to add the first record and
> > then
> > gives me the error:
> >
> > Error: Multiple-step operation generated errors. Check each status value.
> > Code: 80040E21
> > Source: Microsoft Cursor Engine
> >
> > Any help would be much appreciated.
> >
> > Thanks.
> >
>
>
>
.
- Follow-Ups:
- Re: win32_NTLogEvent
- From: S??I
- Re: win32_NTLogEvent
- References:
- win32_NTLogEvent
- From: mn_ms_user
- Re: win32_NTLogEvent
- From: S??I
- win32_NTLogEvent
- Prev by Date: Deleting Printers
- Next by Date: RE: How to automatically add a key to the registry on all Xp machines?
- Previous by thread: Re: win32_NTLogEvent
- Next by thread: Re: win32_NTLogEvent
- Index(es):
Relevant Pages
|