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:



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.