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"]
}