Giter Club home page Giter Club logo

export-sysmonlogs's Introduction

Export-SysmonLogs

===============================

DEPRECATED

This module was a first crack at trying to get sysmon logs into some format thats easier to work with. There's a huge amount of hard coding here, which was a pain every time there was an upgrade and new data types were introduced.

There's another module called export-sysmondb which dynamically figures out what fields belong to what event types, and loads them into a sqlite database.

To be honest - I'm not sure doing this is useful. still its been a useful exercise for me.

==============================

This module provides a way to export Sysmon Logs into a number of CSV file, one for each type

Early days. So far focusing on pulling logs out and getting them into csv and (soon) sqlite.

Really though - the state that this things at, its really just a way to export sysmon logs to CSV

##Functions

For exporting there is:

  1. Export-SysmonLogs
  • Reads either the live sysmon logs, or an offline saved evtx file
  • Each record is then thrown through the appropriate ConvertFrom-Sysmon file
  • The resulting object is saved to a csv file, each type going to seperate csv files
  • There are a bunch of flags which manipulate get-WinEvent used inside the script to select specific types, date range, etc.
  1. ConvertFrom-Sysmon###### scripts (eg ConvertFrom-SysmonProcessCreate)
  • Seperate scripts, one for each Sysmon type. You can get a list of these events with

    (Get-WinEvent -ListProvider "Microsoft-Windows-Sysmon" ).Tasks | sort value | Select Value,Displayname

  • A smarter person than me could just have a single script that used the events from -listprovider to identify the fields in each type. You can check these out with

    (Get-WinEvent -ListProvider "Microsoft-Windows-Sysmon" ).Events | sort id | Select id,description |format-table -wrap

  • Each script also has an alias matching the type-id eg ConvertFrom-SysmonType1. These are used to dynamically select each script within Export-SysmonLogs

export-sysmonlogs's People

Contributors

davebremer avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar

Forkers

warmiceberg

export-sysmonlogs's Issues

Errors in some records

Working through. I suspect that some events don't always have the complete set of message fields. Might have to edit every damn one to build up one line at a time

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.