pC_sfailedapplogin.md

June 14, 2023 ยท View on GitHub

Parser Content

{
Name = s-failed-app-login
  Vendor = Microsoft
  Product = SQL Server
  Lms = Direct 
  DataType = "failed-app-login"
  TimeFormat = "MM/dd/yyyy HH:mm:ss a"
  Conditions = [ "EventCode=18456", "Keywords=Audit Failure", "Login failed" ]
  Fields = [
    """exabeam_host=(.+?@\s{0,100})?({host}[^\s]{1,2000})""",
    """(\\n|\W)ComputerName =({host}[\w\-\.]{1,2000})\s{0,100}(\\n)?(\w+=|$)""",
    """({time}\d\d\/\d\d\/\d\d\d\d \d\d:\d\d:\d\d (?i)(AM|PM))""",
    """(\\n|\W)Message=[^=]{0,2000}?\Wuser\s{0,100}'\s{0,100}((({domain}[^\\]{1,2000})(\\)+))?({user}[^\\]{1,2000}?)'""",
    """(\\n|\W)SourceName =({service_name}[^=]{1,2000}?)\s{0,100}(\\n)?(\w+=|$)""",
    """SourceName =({app}MSSQL)""",
    """\[CLIENT:\s{1,100}({src_ip}[a-fA-F\d:\.]{1,2000})\]""",
    """\WReason:\s{0,100}({failure_reason}[^:]{1,2000}?)\s{0,100}\[""",
    """source_hostname":"({src_host}[^"]{1,2000})""",
    """EventCode=({event_code}\d{1,100})""",
    """({event_name}Login failed)""",
  ]
  DupFields = [ "host->dest_host" ]


}