Windows event log ยท Microsoft-Windows-Sysmon/Operational3 Network connection

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

Fields EvtxECmd extracts

8 columns in the EvtxECmd CSV

  • PayloadData1ProcessID: %ProcessID%, ProcessGUID: %ProcessGUID%
    • %ProcessGUID% = /Event/EventData/Data[@Name="ProcessGuid"]
    • %ProcessID% = /Event/EventData/Data[@Name="ProcessId"]
  • PayloadData2RuleName: %RuleName%
    • %RuleName% = /Event/EventData/Data[@Name="RuleName"]
  • PayloadData3SourceHostname: %SourceHostname%
    • %SourceHostname% = /Event/EventData/Data[@Name="SourceHostname"]
  • PayloadData4SourceIp: %SourceIp%
    • %SourceIp% = /Event/EventData/Data[@Name="SourceIp"]
  • PayloadData5DestinationHostname: %DestinationHostname%
    • %DestinationHostname% = /Event/EventData/Data[@Name="DestinationHostname"]
  • PayloadData6DestinationIp: %DestinationIp%
    • %DestinationIp% = /Event/EventData/Data[@Name="DestinationIp"]
  • UserName%User%
    • %User% = /Event/EventData/Data[@Name="User"]
  • ExecutableInfo%Image%
    • %Image% = /Event/EventData/Data[@Name="Image"]

Sample event

Event XML from the map file

<Event>
  <System>
    <Provider Name="Microsoft-Windows-Sysmon" Guid="5770385f-c22a-43e0-bf4c-06f5698ffbd9"/>
    <EventID>3</EventID>
    <Version>5</Version>
    <Level>4</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime="2019-05-14 17:42:53.8543815"/>
    <EventRecordID>14922</EventRecordID>
    <Correlation/>
    <Execution ProcessID="1808" ThreadID="2120"/>
    <Channel>Microsoft-Windows-Sysmon/Operational</Channel>
    <Computer>DC1.insecurebank.local</Computer>
    <Security UserID="S-1-5-18"/>
  </System>
  <EventData>
    <Data Name="RuleName"></Data>
    <Data Name="UtcTime">2019-05-14 17:42:52.819</Data>
    <Data Name="ProcessGuid">dfae8213-f1b5-5cda-0000-0010eb030000</Data>
    <Data Name="ProcessId">4</Data>
    <Data Name="Image">System</Data>
    <Data Name="User">NT AUTHORITY\SYSTEM</Data>
    <Data Name="Protocol">tcp</Data>
    <Data Name="Initiated">False</Data>
    <Data Name="SourceIsIpv6">False</Data>
    <Data Name="SourceIp">10.59.4.11</Data>
    <Data Name="SourceHostname">DC1.insecurebank.local</Data>
    <Data Name="SourcePort">445</Data>
    <Data Name="SourcePortName">microsoft-ds</Data>
    <Data Name="DestinationIsIpv6">False</Data>
    <Data Name="DestinationIp">10.59.4.20</Data>
    <Data Name="DestinationHostname">ALICE</Data>
    <Data Name="DestinationPort">49304</Data>
    <Data Name="DestinationPortName"></Data>
  </EventData>
</Event>

References

6 links

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