DFIRHub

Windows event log ยท Microsoft-Windows-Sysmon/Operational22 DNSEvent (DNS query)

  • Sysmon
  • 7 fields
  • Microsoft-Windows-Sysmon%4Operational.evtx
  • Microsoft-Windows-Sysmon

Fields EvtxECmd extracts

7 columns in the EvtxECmd CSV

  • UserName%User%
    • %User% = /Event/EventData/Data[@Name="User"]
  • PayloadData1ProcessID: %ProcessID%, ProcessGUID: %ProcessGUID%
    • %ProcessGUID% = /Event/EventData/Data[@Name="ProcessGuid"]
    • %ProcessID% = /Event/EventData/Data[@Name="ProcessId"]
  • PayloadData2RuleName: %RuleName%
    • %RuleName% = /Event/EventData/Data[@Name="RuleName"]
  • PayloadData3Image: %Image%
    • %Image% = /Event/EventData/Data[@Name="Image"]
  • PayloadData4QueryName: %QueryName%
    • %QueryName% = /Event/EventData/Data[@Name="QueryName"]
  • PayloadData5QueryStatus: %QueryStatus%
    • %QueryStatus% = /Event/EventData/Data[@Name="QueryStatus"]
  • PayloadData6QueryResults: %QueryResults%
    • %QueryResults% = /Event/EventData/Data[@Name="QueryResults"]

Sample event

Event XML from the map file

<Event>
  <System>
    <Provider Name="Microsoft-Windows-Sysmon" Guid="5770385f-c22a-43e0-bf4c-06f5698ffbd9"/>
    <EventID>22</EventID>
    <Version>5</Version>
    <Level>4</Level>
    <Task>22</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime="2020-10-20 11:51:01.4767229"/>
    <EventRecordID>1084</EventRecordID>
    <Correlation/>
    <Execution ProcessID="7212" ThreadID="1320"/>
    <Channel>Microsoft-Windows-Sysmon/Operational</Channel>
    <Computer>DESKTOP-NTSSLJD</Computer>
    <Security UserID="S-1-5-18"/>
  </System>
  <EventData>
    <Data Name="RuleName">-</Data>
    <Data Name="UtcTime">2020-10-20 11:50:59.461</Data>
    <Data Name="ProcessGuid">23f38d93-abac-5f8e-3900-000000000c00</Data>
    <Data Name="ProcessId">2428</Data>
    <Data Name="QueryName">wpad</Data>
    <Data Name="QueryStatus">9003</Data>
    <Data Name="QueryResults">-</Data>
    <Data Name="Image">C:\Windows\System32\svchost.exe</Data>
  </EventData>
</Event>

References

5 links

Source: evtx/Maps/Microsoft-Windows-Sysmon-Operational_Microsoft-Windows-Sysmon_22.map(opens in new tab) by Andrew Rathbun and contributors(opens in new tab), MIT License(opens in new tab)