DFIRHub

Windows event log ยท Application18453 MSSQLSERVER Login success (Integrated Auth)

  • Application
  • 2 fields
  • Application.evtx
  • MSSQLSERVER

Fields EvtxECmd extracts

2 columns in the EvtxECmd CSV

  • PayloadData1Target: %User%
    • %User% = /Event/EventData/Data
  • PayloadData3%Client%
    • %Client% = /Event/EventData/Data

Sample event

Event XML from the map file

<Event>
  <System>
    <Provider Name="MSSQLSERVER"/>
    <EventID Qualifiers="16383">18454</EventID>
    <Level>0</Level>
    <Task>4</Task>
    <Keywords>0xA0000000000000</Keywords>
    <TimeCreated SystemTime="2025-01-08 08:46:25.667913"/>
    <EventRecordID>107129921</EventRecordID>
    <Channel>Application</Channel>
    <Computer>host.domain</Computer>
    <Security/>
  </System>
  <EventData>
    <Data>DOMAIN\USER$,  [CLIENT: &amp;lt;local machine&amp;gt;]</Data>
    <Binary>18-48-00-00-0E-00-00-00-0C-00-00-00-4D-00-53-00-45-00-44-00-47-00-45-00-57-00-49-00-4E-00-31-00-30-00-00-00-07-00-00-00-6D-00-61-00-73-00-74-00-65-00-72-00-00-00</Binary>
  </EventData>

References

3 links

Source: evtx/Maps/Application_MSSQLSERVER_18453.map(opens in new tab) by Andrew Rathbun and contributors(opens in new tab), MIT License(opens in new tab)