Scenario
In this Sherlock, you will familiarize yourself with Sysmon logs and various useful EventIDs for identifying and analyzing malicious activities on a Windows system. Palo Alto’s Unit42 recently conducted research on an UltraVNC campaign, wherein attackers utilized a backdoored version of UltraVNC to maintain access to systems. This lab is inspired by that campaign and guides participants through the initial access stage of the campaign.
Dump the evtx as json
chainsaw dump ./Microsoft-Windows-Sysmon-Operational.evtx --json > sysmon.outHow many Event logs are there with Event ID 11?
56

Whenever a process is created in memory, an event with Event ID 1 is recorded with details such as command line, hashes, process path, parent process path, etc. This information is very useful for an analyst because it allows us to see all programs executed on a system, which means we can spot any malicious processes being executed. What is the malicious process that infected the victim's system?
C:\Users\CyberJunkie\Downloads\Preventivo24.02.14.exe.exe

Which Cloud drive was used to distribute the malware?
DropBox

For many of the files it wrote to disk, the initial malicious file used a defense evasion technique called Time Stomping, where the file creation date is changed to make it appear older and blend in with other files. What was the timestamp changed to for the PDF file?
2024-01-14 08:10:06

Better way. Use jq with -c to print every event in one line. Then grep for pdf. Then run jq again.
cat sysmon.out| jq '.[].Event | select(.System.EventID == 2)' -c | grep pdf | jq '. | .EventData'The malicious file dropped a few files on disk. Where was `once.cmd` created on disk? Please answer with the full path along with the filename.
C:\Users\CyberJunkie\AppData\Roaming\Photo and Fax Vn\Photo and vn 1.1.2\install\F97891C\WindowsVolume\Games\once.cmd

The malicious file attempted to reach a dummy domain, most likely to check the internet connection status. What domain name did it try to connect to?
www.example.com
cat sysmon.out| jq '.[].Event | select(.System.EventID == 22)' -c | grep 'Preventivo' | jq '.EventData'
Which IP address did the malicious process try to reach out to?
93.184.216.34
cat sysmon.out| jq '.[].Event | select(.System.EventID == 3)' -c | grep 'Preventivo' | jq '.EventData'
The malicious process terminated itself after infecting the PC with a backdoored variant of UltraVNC. When did the process terminate itself?
2024-02-14 03:41:58
cat sysmon.out | jq '.[].Event | select(.System.EventID == 5) | .EventData'