Overview
Introduced in Windows 8, the System Resource Usage Monitor (SRUM) is a
feature that records numerous metrics of system activities, with a limited
subset of the available information displayed within the Windows Task Manager
(“App history” tab).
The information is stored in the SRUM ESE database SRUDB.dat, with
historical data for the last 30 to 60 days only.
Information of interest
Entries are not associated with their timestamp of occurrence but with the
timestamp of insertion in the SRUM database. As entries are only written to
the SRUM database every hour, timestamps are thus precise to the hour (with
multiple entries usually sharing the same insertion timestamp).
Among the various information stored, the following two tables hold the most commonly valuable data for forensics investigations:
-
Application Resource Usagetable (GUID{D10CA2FE-6FCF-4F6D-848E-B2E99266FA89}), that tracks programs execution. For each entry in theApplication Resource Usagetable (SrumECmd’sAppResourceUseInfooutput), the following information may be recorded:-
Timestamp of the
SRUMentry creation. -
Full path of the executable or application information/description for built-in components.
-
User
SIDof the user executing the process. -
Metrics on CPU usage (CPU time in foreground and background).
-
Metrics on I/O operations (foreground/background number of read/write operations and bytes read/written).
-
-
App Timeline Providertable (GUID{5C8CF1C7-7257-4F13-B223-970EF5939312}), that also tracks programs execution. For each entry in theApplication Resource Usagetable (SrumECmd’sAppTimelineProvideroutput), the following information may be recorded:-
Timestamp of the
SRUMentry creation. -
Name of the executable and description for built-in components.
-
Timestamp of compilation of the executable.
-
User
SIDof the user executing the process. -
Timestamp of seemingly approximate end of execution.
-
Total duration of execution (in milliseconds).
-
-
Network Data Usagetable (GUID{973F5D5C-1D90-4944-BE8E-24B94231A174}), that tracks programs execution and network usage of the executed programs. For each entry in theNetwork Data Usagetable (SrumECmd’sNetworkUsagesoutput), the following information may be recorded:-
Timestamp of the
SRUMentry creation. -
Full path of the executable or application information/description for built-in components.
-
Metrics on network data usage (bytes sent and receive on a given network interface).
-
Some of the information recorded in the SRUM database be viewed using the
Windows Task Manager (“App history” tab).
Tool(s)
Repairing the SRUDB.dat database
As the copied SRUM database will likely not be in a “clean state”, the
database will have to be repaired. This can be accomplished using the
esentutl utility. It is recommended to make a copy of the SRU directory
before repairing the database.
# The following commands should be executed in the directory containing the UAL database files.
esentutl.exe /r sru /i
esentutl.exe /p SRUDB.dat
SrumECmd
The SrumECmd utility (KAPE
SrumECmd module) can parse and extract information from the SRUDB.dat
database, and correlates information from the SOFTWARE registry hive.
# Parses the specified SRUM database, using the optionally provided SOFTWARE registry hive.
SrumECmd.exe -f <SRUDB.dat | SRUM_DB_FILE> [-r <SOFTWARE>] --csv <OUTPUT_DIRECTORY>
# Recursively look for SRUDB.dat and SOFTWARE files in the specified directory.
SrumECmd.exe -d <DIRECTORY> --csv <OUTPUT_DIRECTORY>
The PowerShell_SrumECmd_SRUM-RepairAndParse KAPE module, leveraging the
PowerShell script
SRUM-Repair.ps1
can be used to automate the repairing and parsing process (with SrumECmd).
References
View on GitHub