...
OLD_KREW_DOC_HDR_CNTNT_T
View:
AUDIT_TRAIL
Column Name | Length | Sample Data |
---|---|---|
OS_USERNAME | 255 | tomcat kfsctmuser iadmin ucdstage dsadm root btp98001 kec14023 kaa02003 |
USERNAME | 30 | KR_PRD KFS_PRD ACH_UAT_USR_RO KFS_PRD_ETL_RO RSMART_RO KFS_PRD_FOC_RO BTP98001 KEC14023 KAA02003 |
USERHOST | 128 | dsprod webfocusprod dsdev webfocusdev HZMW5S1 BZ1NBP1 9HDKVV1 UCONN\HZMW5S1 kfs20.uits.uconn.edu |
TIMESTAMP | 19 | |
OWNER | 30 | KFS_PRD KR_PRD |
OBJ_NAME | 128 | AR_CUST_T
|
ACTION_NAME | 28 | UPDATE INSERT DELETE SELECT |
Current Query used -
select distinct USERNAME, current_timestamp
...