Process Microsoft User Access Logs! Thanks to KPMG for the initial write up, found here.
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
Windows User Access Logs (UAL)
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.
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!
Open Source Development funding and support provided by the following contributors: SANS Institute and SANS DFIR.