pC_soracledbactivity2.md

June 14, 2023 ยท View on GitHub

Parser Content

{
Name = s-oracle-db-activity-2
   DataType = "database-access"
   Conditions = [ """STATEMENT_TYPE="""", """ACTION="""", """DBID=""" ]
   Fields = ${OracleParsersTemplates.s-oracle-db-template.Fields}[
     """STATEMENT_TYPE="({activity}[^"]{1,2000})"""
   ]
 
s-oracle-db-template{
    Vendor = Oracle
    Product = Oracle Database
    Lms = Splunk
    IsHVF = true
    TimeFormat = "yyyy-MM-dd HH:mm:ss"
    Fields = [
      """\sTIMESTAMP="{1,20}({time}\d{4}\-\d\d\-\d\d \d\d:\d\d:\d\d)""",
      """\sHOST_NAME="{1,20}({host}[^"]{1,2000})""",
      """OS_USER="({user}[^"]{1,2000})""",
      """DB_USER="({user}[^"]{1,2000})""",
      """\sUSERNAME="{1,20}({user}[^"]{1,2000})""",
      """OBJ_NAME="({database_name}[^"]{1,2000})""",
      """\sDB_NAME="{1,20}({database_name}[^"]{1,2000})""",
      """\(HOST=({src_ip}\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})""",
      """\sUSERHOST="{1,20}([^\\]{1,2000}\\)?({src_host}[^"]{1,2000})""",
      """ACTION_NAME="({activity}[^"]{1,2000})""",
      """DBID="({database_id}\d{1,100})"""
    
}