pC_soracledblogon.md

June 14, 2023 ยท View on GitHub

Parser Content

{
Name = s-oracle-db-logon
  Vendor = Oracle
  Product = Oracle Database
  Lms = Splunk
  DataType = "database-login"
  IsHVF = true
  TimeFormat = "yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ"
  Conditions = [ """<DB_User>""", """<OS_User>""", """<Userhost>""", """<OS_Process>""", """Authenticated by:""" ]
  Fields = [
    """<Extended_Timestamp>({time}\d\d\d\d-\d\d-\d\dT\d\d:\d\d:\d\d.\d{1,100}\w)</Extended_Timestamp>"""
    """<DB_User>(\/|({db_user}.+?))</DB_User>""",
    """<OS_User>({os_user}.+?)</OS_User>""",
    """<Userhost>({src_host}[^\<]{1,2000})</Userhost>""",
    """<OS_Process>({process_id}\d{1,100})</OS_Process>""",
    """<Session_Id>({session_id}\d{1,100})</Session_Id>""",
    """<Returncode>({outcome}.+?)</Returncode>""",
    """<DBID>({database_name}.+?)</DBID>""",
    """PROTOCOL=({protocol}[^\)]{1,2000})""",
    """HOST=({src_ip}[a-fA-F\d.:]{1,2000})""",
    """PORT=({src_port}\d{1,100})""",
  ]
  DupFields = [ "os_user->user", "db_user->account"]
 

}