0 Replies Latest reply on Oct 1, 2015 9:21 AM by atranauskas

    Windows Event Log Integration

    atranauskas

      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.