atranauskas

Windows Event Log Integration

Discussion created by atranauskas on Oct 1, 2015

Currently the company I work for uses FMP13 for a lot of our day to day tasks.

 

So my thought was to integrate the event log files from our servers into a single database on our FM13 server.

 

My question is, does anyone here know how to set up an ODBC connection from a FM server, to a specific machine's event log?

 

If not then is it possible to get that machine's event log to write to a SQL database and then pull from there into the FM13 server?

 

 

On a related note if you look at a filtered event log it saves as a .evtx file.

 

When I translate that into a CSV (which if it were only that easy) all I see is the top level information IE the following:

 

Event Level          Date and Time                 Source                                        Event ID

Information                XXXXXX        Microsfot Windows Security etc                XXXXXX

 

 

Yet the information I need is located in the grey field below this top level information IE:

 

Subject:

Account Name: Username

Account Domain XXX

 

 

Yet this information exists in the XML view:

 

Is there someway to import an XML file into FM13?

 

If there is; do the fields auto sort like they do with an xls/csv file?

 

 

Thanks in advance; this whole thing is a bit of a headache. I think I bit off more than I anticipated for my first FM project.

Outcomes