SUM

Windowsv1.1

Author: Andrew Rathbun, Yogesh Khatri

SUM Database

Paths

1 path

Paths use Windows environment variable syntax

References

advisory.kpmg.ushttps://advisory.kpmg.us/blog/2021/digital-forensics-incident-response.html

svch0st.medium.comhttps://svch0st.medium.com/windows-user-access-logs-ual-9580f1100635

github.comhttps://github.com/EricZimmerman/Sum - be sure to follow the guide here for repairing the DB prior to parsing

github.comhttps://github.com/brimorlabs/KStrike

docs.microsoft.comhttps://docs.microsoft.com/en-us/windows-server/administration/user-access-logging/manage-user-access-logging

thedfirspot.comhttps://www.thedfirspot.com/post/sum-ual-investigating-server-access-with-user-access-logging

Notes

LogFiles.tkape Target acquires this as well, but this is a more specific Target in that it ONLY grabs the SUM Database artifacts and nothing else, unlike LogFiles.tkape

Collection commands

KAPE, PowerShell, Batch, WSL

Source

Destination

# PowerShell Artifact Collection Script
# Target: SUM
# Run as Administrator

#Requires -RunAsAdministrator

$ErrorActionPreference = "Continue"
$SourceRoot = "C:"
$DestBase   = "D:\Evidence"
$Summary = @{ Copied = 0; Missed = 0; Errors = 0 }

function Collect-Artifact {
    param(
        [Parameter(Mandatory)][string]$SourceDir,
        [Parameter(Mandatory)][string]$FolderName,
        [string]$FileMask = "*"
    )
    # Expand wildcards in any path segment (e.g. 'Program Files*',
    # 'ScreenConnect Client*'). robocopy itself does not glob the source.
    $sources = @(Get-Item -Path $SourceDir -ErrorAction SilentlyContinue |
        Where-Object { $_.PSIsContainer })
    if ($sources.Count -eq 0) {
        $Summary.Missed++
        return
    }
    $FullDest = Join-Path -Path $DestBase -ChildPath $FolderName
    $null = New-Item -ItemType Directory -Force -Path $FullDest -ErrorAction SilentlyContinue
    foreach ($src in $sources) {
        robocopy $src.FullName "$FullDest" "$FileMask" /E /COPY:DAT /R:0 /W:0 /NP /NFL /NDL /NJH /NJS 2>$null | Out-Null
        if ($LASTEXITCODE -le 7) { $Summary.Copied++ } else { $Summary.Errors++ }
    }
}

# 1. SUM Database (.mdb files)
Collect-Artifact -SourceDir "C:\Windows\System32\LogFiles\SUM" -FolderName "SUM_Database_mdb_files"

Write-Host ("Collection complete. Copied: {0}  Missed: {1}  Errors: {2}" -f $Summary.Copied, $Summary.Missed, $Summary.Errors) -ForegroundColor Green

Save as .ps1 and run as Administrator. Use: powershell -ExecutionPolicy Bypass -File script.ps1

Included in collections: SANS_Triage KapeTriage