FolderRisk: Caution
- Windows Server
Sum C:\Windows\System32\LogFiles\Sum
User Access Logging (UAL) database: two-year history of client accesses (users, IP addresses) to server roles and products.
What it’s for
Sum (Server User Management) holds the ESE database of the User Access Logging (UAL) service, enabled by default since Windows Server 2012. UAL aggregates client requests, identified by user and IP address, to the roles and products installed on the server, and is used for usage tracking and licensing. The active database is Current.mdb.
What it contains
Current.mdb, the active database. Every 24 hours, UAL copies the data to a{GUID}.mdbfile that the WMI provider reads.- A new
{GUID}.mdbfile at the start of each calendar year, with history kept for up to two years. SystemIdentity.mdband supporting ESE files (.chk,.log, and so on).- Reading is done with the
Get-Ual*cmdlets or theMsftUal_*WMI classes (root\AccessLoggingnamespace).
Risks and best practices
- Moving or modifying the files triggers UAL’s recovery routine, which can empty the whole folder. To back up, copy all the files together.
- The database holds user names and IP addresses. It is a valuable investigation source, but also personal data to protect.
- On an internet-facing or very high-performance server, you can stop UAL with
Stop-Service UALSVCthenDisable-Ual(as administrator).
Useful commands
# List the UAL database (Current.mdb, {GUID}.mdb files, etc.)Get-ChildItem -Force "$env:windir\System32\LogFiles\Sum" | Select-Object Name, Length, LastWriteTime
# Check the User Access Logging service stateGet-Service UALSVC
# See the installed roles and products tracked by UALGet-UalOverview
# See access per client user, with IP addressGet-UalUserAccess | Select-Object -First 20