5c.378. Request Events per User (OCI360_AUDIT_EVENTS)

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 DATA$REQUEST$ID                                                                              VARCHAR2(128)
 DATA$REQUEST$PATH                                                                            VARCHAR2(128)
 DATA$REQUEST$ACTION                                                                          VARCHAR2(8)
 DATA$IDENTITY$AUTH_TYPE                                                                      VARCHAR2(4)
 DATA$IDENTITY$CALLER_ID                                                                      VARCHAR2(4)
 DATA$IDENTITY$TENANT_ID                                                                      VARCHAR2(128)
 DATA$IDENTITY$IP_ADDRESS                                                                     VARCHAR2(64)
 DATA$IDENTITY$USER_AGENT                                                                     VARCHAR2(128)
 DATA$IDENTITY$CALLER_NAME                                                                    VARCHAR2(4)
 DATA$IDENTITY$CREDENTIALS                                                                    VARCHAR2(4096)
 DATA$IDENTITY$PRINCIPAL_ID                                                                   VARCHAR2(128)
 DATA$IDENTITY$PRINCIPAL_NAME                                                                 VARCHAR2(32)
 DATA$IDENTITY$CONSOLE_SESSION_ID                                                             VARCHAR2(32)
 DATA$RESPONSE$STATUS                                                                         VARCHAR2(4)
 DATA$RESPONSE$MESSAGE                                                                        VARCHAR2(128)
 DATA$RESPONSE$PAYLOAD$ID                                                                     VARCHAR2(128)
 DATA$RESPONSE$PAYLOAD$VOLUMEID                                                               VARCHAR2(128)
 DATA$RESPONSE$PAYLOAD$INSTANCEID                                                             VARCHAR2(128)
 DATA$RESPONSE$PAYLOAD$LOGIN_INPUT                                                            VARCHAR2(64)
 DATA$RESPONSE$PAYLOAD$LOGIN_RESULT                                                           VARCHAR2(16)
 DATA$RESPONSE$PAYLOAD$RESOURCENAME                                                           VARCHAR2(32)
 DATA$RESPONSE$RESPONSE_TIME                                                                  VARCHAR2(32)
 DATA$EVENT_NAME                                                                              VARCHAR2(64)
 DATA$RESOURCE_ID                                                                             VARCHAR2(128)
 DATA$DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                      VARCHAR2(64)
 DATA$DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                      VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$ID                                                                 VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$ETAG                                                               VARCHAR2(64)
 DATA$STATE_CHANGE$CURRENT$NAME                                                               VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$EMAIL                                                              VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$USERID                                                             VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$GROUPID                                                            VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$ID                                                        VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPE                                                     VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$REGION                                                    VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$IMAGEID                                                   VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$METADATA$SSH_AUTHORIZED_KEYS                              VARCHAR2(512)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHMODE                                                VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$AGENTCONFIG$ISMANAGEMENTDISABLED                          VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$AGENTCONFIG$ISMONITORINGDISABLED                          VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$DEFINEDTAGS$ORACLE_TAGS$CREATEDBY                         VARCHAR2(64)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$DEFINEDTAGS$ORACLE_TAGS$CREATEDON                         VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$DISPLAYNAME                                               VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$FAULTDOMAIN                                               VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$GPUS                                          NUMBER
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$OCPUS                                         NUMBER
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$LOCALDISKS                                    NUMBER
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$MEMORYINGBS                                   NUMBER
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$MAXVNICATTACHMENTS                            NUMBER
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$PROCESSORDESCRIPTION                          VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$NETWORKINGBANDWIDTHINGBPS                     NUMBER
 DATA$STATE_CHANGE$CURRENT$INSTANCE$TIMECREATED                                               VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$COMPARTMENTID                                             VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$FIRMWARE                                    VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$NETWORKTYPE                                 VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$BOOTVOLUMETYPE                              VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$REMOTEDATAVOLUMETYPE                        VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$ISPVENCRYPTIONINTRANSITENABLED              VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$ISCONSISTENTVOLUMENAMINGENABLED             VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SOURCEDETAILS$IMAGEID                                     VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$SOURCEDETAILS$SOURCETYPE                                  VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$LIFECYCLESTATE                                            VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$INSTANCEOPTIONS$ARELEGACYIMDSENDPOINTSDISABLED            VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$AVAILABILITYDOMAIN                                        VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$INSTANCE$PREFERREDMAINTENANCEACTION                                VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$DBHOSTID                                                           VARCHAR2(64)
 DATA$STATE_CHANGE$CURRENT$PASSWORD                                                           VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$BUCKETNAME                                                         VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$DBHOSTNAME                                                         VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$DEFINEDTAGS$ORACLE_TAGS$CREATEDBY                                  VARCHAR2(64)
 DATA$STATE_CHANGE$CURRENT$DEFINEDTAGS$ORACLE_TAGS$CREATEDON                                  VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$DESCRIPTION                                                        VARCHAR2(256)
 DATA$STATE_CHANGE$CURRENT$DISPLAYNAME                                                        VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$LICENSETYPE                                                        VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$TIMECREATED                                                        VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSEAPIKEYS                                         VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSEAUTHTOKENS                                      VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSECONSOLEPASSWORD                                 VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSESMTPCREDENTIALS                                 VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSECUSTOMERSECRETKEYS                              VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSEOAUTH2CLIENTCREDENTIALS                         VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$CPUCORECOUNT                                                       NUMBER
 DATA$STATE_CHANGE$CURRENT$TIMEMODIFIED                                                       VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$COMPARTMENTID                                                      VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$EMAILVERIFIED                                                      VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$SSHPUBLICKEYS                                                      VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$ISMFAACTIVATED                                                     VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$LIFECYCLESTATE                                                     VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ID                                                VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$IQN                                               VARCHAR2(64)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$IPV4                                              VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$PORT                                              NUMBER
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$DEVICE                                            VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$VOLUMEID                                          VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$INSTANCEID                                        VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ISREADONLY                                        VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$DISPLAYNAME                                       VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ISSHAREABLE                                       VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$TIMECREATED                                       VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$COMPARTMENTID                                     VARCHAR2(128)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$LIFECYCLESTATE                                    VARCHAR2(16)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$AVAILABILITYDOMAIN                                VARCHAR2(32)
 DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ISPVENCRYPTIONINTRANSITENABLED                    VARCHAR2(8)
 DATA$STATE_CHANGE$CURRENT$DATASTORAGESIZEINGBS                                               NUMBER
 DATA$STATE_CHANGE$CURRENT$DATASTORAGESIZEINTBS                                               NUMBER
 DATA$STATE_CHANGE$PREVIOUS$ID                                                                VARCHAR2(128)
 DATA$STATE_CHANGE$PREVIOUS$NAME                                                              VARCHAR2(32)
 DATA$STATE_CHANGE$PREVIOUS$EMAIL                                                             VARCHAR2(32)
 DATA$STATE_CHANGE$PREVIOUS$DEFINEDTAGS$ORACLE_TAGS$CREATEDBY                                 VARCHAR2(64)
 DATA$STATE_CHANGE$PREVIOUS$DEFINEDTAGS$ORACLE_TAGS$CREATEDON                                 VARCHAR2(32)
 DATA$STATE_CHANGE$PREVIOUS$DESCRIPTION                                                       VARCHAR2(32)
 DATA$STATE_CHANGE$PREVIOUS$TIMECREATED                                                       VARCHAR2(32)
 DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSEAPIKEYS                                        VARCHAR2(4)
 DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSEAUTHTOKENS                                     VARCHAR2(4)
 DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSECONSOLEPASSWORD                                VARCHAR2(4)
 DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSESMTPCREDENTIALS                                VARCHAR2(4)
 DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSECUSTOMERSECRETKEYS                             VARCHAR2(4)
 DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSEOAUTH2CLIENTCREDENTIALS                        VARCHAR2(4)
 DATA$STATE_CHANGE$PREVIOUS$TIMEMODIFIED                                                      VARCHAR2(32)
 DATA$STATE_CHANGE$PREVIOUS$COMPARTMENTID                                                     VARCHAR2(128)
 DATA$STATE_CHANGE$PREVIOUS$EMAILVERIFIED                                                     VARCHAR2(8)
 DATA$STATE_CHANGE$PREVIOUS$ISMFAACTIVATED                                                    VARCHAR2(8)
 DATA$STATE_CHANGE$PREVIOUS$LIFECYCLESTATE                                                    VARCHAR2(8)
 DATA$FREEFORM_TAGS$BACKUP                                                                    VARCHAR2(16)
 DATA$RESOURCE_NAME                                                                           VARCHAR2(64)
 DATA$COMPARTMENT_ID                                                                          VARCHAR2(128)
 DATA$COMPARTMENT_NAME                                                                        VARCHAR2(16)
 DATA$EVENT_GROUPING_ID                                                                       VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$ETAG                                                                 VARCHAR2(64)
 DATA$ADDITIONAL_DETAILS$TYPE                                                                 VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$NONCE                                                                VARCHAR2(64)
 DATA$ADDITIONAL_DETAILS$SCOPE                                                                VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$SHAPE                                                                VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$STATE                                                                VARCHAR2(256)
 DATA$ADDITIONAL_DETAILS$ACTION                                                               VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$DBNAME                                                               VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$NSGIDS                                                               VARCHAR2(4)
 DATA$ADDITIONAL_DETAILS$TENANT                                                               VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$USERID                                                               VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$GROUPID                                                              VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$IMAGEID                                                              VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$REFERER                                                              VARCHAR2(1024)
 DATA$ADDITIONAL_DETAILS$VERSION                                                              VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$DBHOSTID                                                             VARCHAR2(64)
 DATA$ADDITIONAL_DETAILS$HOSTNAME                                                             VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$USERNAME                                                             VARCHAR2(32)
 DATA$ADDITIONAL_DETAILS$VOLUMEID                                                             VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$CLIENT_ID                                                            VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$NAMESPACE                                                            VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$PROVIDERS                                                            VARCHAR2(1024)
 DATA$ADDITIONAL_DETAILS$BUCKETNAME                                                           VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$DBSYSTEMID                                                           VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$PUBLIC_KEY                                                           VARCHAR2(1024)
 DATA$ADDITIONAL_DETAILS$SOURCETYPE                                                           VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$VERSIONING                                                           VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$VOLUMENAME                                                           VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$X_REAL_PORT                                                          NUMBER
 DATA$ADDITIONAL_DETAILS$LICENSETYPE                                                          VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$POWERACTION                                                          VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$TIMECREATED                                                          VARCHAR2(32)
 DATA$ADDITIONAL_DETAILS$TIMEUPDATED                                                          VARCHAR2(32)
 DATA$ADDITIONAL_DETAILS$CPUCORECOUNT                                                         NUMBER
 DATA$ADDITIONAL_DETAILS$REDIRECT_URI                                                         VARCHAR2(256)
 DATA$ADDITIONAL_DETAILS$RESOURCENAME                                                         VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$WORKLOADTYPE                                                         VARCHAR2(32)
 DATA$ADDITIONAL_DETAILS$RESPONSE_TYPE                                                        VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$SSHPUBLICKEYS                                                        VARCHAR2(4)
 DATA$ADDITIONAL_DETAILS$APP_PUBLIC_KEY                                                       VARCHAR2(1024)
 DATA$ADDITIONAL_DETAILS$LIFECYCLESTATE                                                       VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$SUPPORTPROVIDER                                                      VARCHAR2(4)
 DATA$ADDITIONAL_DETAILS$PUBLICACCESSTYPE                                                     VARCHAR2(16)
 DATA$ADDITIONAL_DETAILS$SUPPORT_PROVIDER                                                     VARCHAR2(4)
 DATA$ADDITIONAL_DETAILS$EXADATAIORMCONFIG                                                    VARCHAR2(4)
 DATA$ADDITIONAL_DETAILS$SERVICECONSOLEURL                                                    VARCHAR2(256)
 DATA$ADDITIONAL_DETAILS$INSTANCEACTIONTYPE                                                   VARCHAR2(8)
 DATA$ADDITIONAL_DETAILS$PATCHHISTORYENTRIES                                                  VARCHAR2(4)
 DATA$ADDITIONAL_DETAILS$AUTONOMOUSDATABASEID                                                 VARCHAR2(128)
 DATA$ADDITIONAL_DETAILS$DATASTORAGESIZEINGBS                                                 NUMBER
 DATA$ADDITIONAL_DETAILS$DATASTORAGESIZEINTBS                                                 NUMBER
 DATA$ADDITIONAL_DETAILS$DATASTORAGEPERCENTAGE                                                NUMBER
 DATA$ADDITIONAL_DETAILS$AUTONOMOUSDATABASETYPE                                               VARCHAR2(32)
 DATA$AVAILABILITY_DOMAIN                                                                     VARCHAR2(32)
 SOURCE                                                                                       VARCHAR2(32)
 EVENT_ID                                                                                     VARCHAR2(64)
 EVENT_TIME                                                                                   VARCHAR2(32)
 EVENT_TYPE                                                                                   VARCHAR2(128)
 CONTENT_TYPE                                                                                 VARCHAR2(16)
 EVENT_TYPE_VERSION                                                                           VARCHAR2(4)
 CLOUD_EVENTS_VERSION                                                                         VARCHAR2(4)
 DATA$REQUEST$HEADERS$DNT                                                                     VARCHAR2(1)
 DATA$REQUEST$HEADERS$DATE                                                                    VARCHAR2(32)
 DATA$REQUEST$HEADERS$ACCEPT                                                                  VARCHAR2(128)
 DATA$REQUEST$HEADERS$COOKIE                                                                  VARCHAR2(2048)
 DATA$REQUEST$HEADERS$ORIGIN                                                                  VARCHAR2(64)
 DATA$REQUEST$HEADERS$X_DATE                                                                  VARCHAR2(32)
 DATA$REQUEST$HEADERS$REFERER                                                                 VARCHAR2(2048)
 DATA$REQUEST$HEADERS$INSTANCE                                                                VARCHAR2(128)
 DATA$REQUEST$HEADERS$X_REAL_IP                                                               VARCHAR2(16)
 DATA$REQUEST$HEADERS$CONNECTION                                                              VARCHAR2(16)
 DATA$REQUEST$HEADERS$USER_AGENT                                                              VARCHAR2(128)
 DATA$REQUEST$HEADERS$X_REAL_PORT                                                             VARCHAR2(8)
 DATA$REQUEST$HEADERS$CONTENT_TYPE                                                            VARCHAR2(64)
 data$request$headers$Authorization                                                           VARCHAR2(2048)
 DATA$REQUEST$HEADERS$CACHE_CONTROL                                                           VARCHAR2(16)
 data$request$headers$authorization                                                           VARCHAR2(2048)
 DATA$REQUEST$HEADERS$OPC_PRINCIPAL                                                           VARCHAR2(8192)
 DATA$REQUEST$HEADERS$CONTENT_LENGTH                                                          VARCHAR2(4)
 DATA$REQUEST$HEADERS$SEC_FETCH_DEST                                                          VARCHAR2(8)
 DATA$REQUEST$HEADERS$SEC_FETCH_MODE                                                          VARCHAR2(8)
 DATA$REQUEST$HEADERS$SEC_FETCH_SITE                                                          VARCHAR2(16)
 DATA$REQUEST$HEADERS$SEC_FETCH_USER                                                          VARCHAR2(2)
 DATA$REQUEST$HEADERS$OPC_REQUEST_ID                                                          VARCHAR2(128)
 DATA$REQUEST$HEADERS$ACCEPT_ENCODING                                                         VARCHAR2(32)
 data$request$headers$Accept_Language                                                         VARCHAR2(32)
 DATA$REQUEST$HEADERS$X_FORWARDED_FOR                                                         VARCHAR2(64)
 data$request$headers$accept_language                                                         VARCHAR2(2)
 DATA$REQUEST$HEADERS$X_FORWARDED_HOST                                                        VARCHAR2(64)
 DATA$REQUEST$HEADERS$X_FORWARDED_PORT                                                        VARCHAR2(4)
 DATA$REQUEST$HEADERS$OCI_ORIGINAL_URL                                                        VARCHAR2(256)
 DATA$REQUEST$HEADERS$X_CONTENT_SHA256                                                        VARCHAR2(64)
 DATA$REQUEST$HEADERS$X_FORWARDED_PROTO                                                       VARCHAR2(8)
 DATA$REQUEST$HEADERS$X_ORACLE_AUTH_CLIENT_CN                                                 VARCHAR2(64)
 DATA$REQUEST$HEADERS$UPGRADE_INSECURE_REQUESTS                                               VARCHAR2(1)
 DATA$REQUEST$PARAMETERS$ACTION                                                               VARCHAR2(8)
 DATA$REQUEST$PARAMETERS$PARAM0                                                               VARCHAR2(16)
 DATA$REQUEST$PARAMETERS$TENANTID                                                             VARCHAR2(128)
 DATA$REQUEST$PARAMETERS$PRESERVEBOOTVOLUME                                                   VARCHAR2(8)
 DATA$RESPONSE$HEADERS$DATE                                                                   VARCHAR2(32)
 data$response$headers$ETag                                                                   VARCHAR2(64)
 DATA$RESPONSE$HEADERS$VARY                                                                   VARCHAR2(8)
 data$response$headers$etag                                                                   VARCHAR2(64)
 DATA$RESPONSE$HEADERS$PRAGMA                                                                 VARCHAR2(8)
 data$response$headers$Location                                                               VARCHAR2(4096)
 data$response$headers$location                                                               VARCHAR2(128)
 DATA$RESPONSE$HEADERS$X_API_ID                                                               VARCHAR2(8)
 DATA$RESPONSE$HEADERS$CONNECTION                                                             VARCHAR2(8)
 DATA$RESPONSE$HEADERS$CONTENT_TYPE                                                           VARCHAR2(32)
 DATA$RESPONSE$HEADERS$CACHE_CONTROL                                                          VARCHAR2(64)
 DATA$RESPONSE$HEADERS$CONTENT_LENGTH                                                         VARCHAR2(4)
 DATA$RESPONSE$HEADERS$OPC_REQUEST_ID                                                         VARCHAR2(128)
 DATA$RESPONSE$HEADERS$X_FRAME_OPTIONS                                                        VARCHAR2(4)
 DATA$RESPONSE$HEADERS$OPC_WORK_REQUEST_ID                                                    VARCHAR2(128)
 DATA$RESPONSE$HEADERS$X_CONTENT_TYPE_OPTIONS                                                 VARCHAR2(8)
 data$response$headers$Access_Control_Allow_Origin                                            VARCHAR2(64)
 data$response$headers$access_control_allow_origin                                            VARCHAR2(1)
 DATA$RESPONSE$HEADERS$ACCESS_CONTROL_ALLOW_METHODS                                           VARCHAR2(32)
 data$response$headers$Access_Control_Expose_Headers                                          VARCHAR2(128)
 data$response$headers$access_control_expose_headers                                          VARCHAR2(256)
 data$response$headers$Access_Control_Allow_Credentials                                       VARCHAR2(4)
 data$response$headers$access_control_allow_credentials                                       VARCHAR2(4)
 DATA$STATE_CHANGE$CURRENT$STATEMENTS                                                         VARCHAR2(128)
 DATA$STATE_CHANGE$PREVIOUS$STATEMENTS                                                        VARCHAR2(128)


SELECT DATA$EVENT_NAME,
       SOURCE,
       EVENT_TYPE,
       DATA$IDENTITY$PRINCIPAL_NAME,
       REGEXP_REPLACE(DATA$IDENTITY$PRINCIPAL_ID,'ocid1.instance.oc1.*','ocid1.000000000000000000000000000000000000000000000000000000000570.oc1.*') DATA$IDENTITY$PRINCIPAL_ID,
       REGEXP_REPLACE(DATA$IDENTITY$IP_ADDRESS,'172.24.*','172.24.*') DATA$IDENTITY$IP_ADDRESS,
       DATA$REQUEST$ACTION,
       COUNT(*)
FROM   OCI360_AUDIT_EVENTS t1
GROUP BY DATA$EVENT_NAME,
         SOURCE,
         EVENT_TYPE,
         DATA$IDENTITY$PRINCIPAL_NAME,
         REGEXP_REPLACE(DATA$IDENTITY$PRINCIPAL_ID,'ocid1.instance.oc1.*','ocid1.000000000000000000000000000000000000000000000000000000000570.oc1.*'),
         REGEXP_REPLACE(DATA$IDENTITY$IP_ADDRESS,'172.24.*','172.24.*'),
         DATA$REQUEST$ACTION;


61 rows selected.