Awesome

SumECmd

Process Microsoft User Access Logs! Thanks to KPMG for the initial write up, found here.

Command Line Interface

SumECmd version 0.5.0.0

Author: Eric Zimmerman (saericzimmerman@gmail.com)
https://github.com/EricZimmerman/Sum

    d               Directory to recursively process, looking for SystemIdentity.mdb, Current.mdb, etc. Required.
    csv             Directory to save CSV formatted results to. Be sure to include the full path in double quotes

    wd              Generate CSV with day level details. Default is TRUE

    dt              The custom date/time format to use when displaying time stamps. Default is: yyyy-MM-dd HH:mm:ss.fffffff

    debug           Show debug information during processing
    trace           Show trace information during processing


Examples: SumECmd.exe -d "C:\Temp\sum" --csv "C:\Temp\"

      Short options (single letter) are prefixed with a single dash. Long commands are prefixed with two dashes

Documentation

Windows User Access Logs (UAL)

Repairing the SUM Database

Until a proper guide can be made with test data, follow the guide for repairing the SRUM database found here. Both the SUM and SRUM databases are ESE so the process will be identical. Additionally, a walkthrough on how to repair the SUM database was included in this blog post.

Download Eric Zimmerman's Tools

All of Eric Zimmerman's tools can be downloaded here. Use the Get-ZimmermanTools PowerShell script to automate the download and updating of the EZ Tools suite. Additionally, you can automate each of these tools using KAPE!

Special Thanks

Open Source Development funding and support provided by the following contributors: SANS Institute and SANS DFIR.