SQL: select 'abc' as DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' as "__objecttype__", a.evttypecode , a.evtversion , a.evtcatcode , a.evtsysid , a.evtsysplex , a.evtutctod , a.evtsystod , a.evtesmcode , a.evtpuuid , a.evtuserid , a.evtusername, a.evtjobname , a.evtsource , a.admtarget , a.admacctstr as Commandstr, a.oprcode , a.vio1code , a.vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT a UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWADMPOLICY' as "__objecttype__", p.evttypecode , p.evtversion , p.evtcatcode , p.evtsysid , p.evtsysplex , p.evtutctod , p.evtsystod , p.evtesmcode , p.evtpuuid , p.evtuserid , p.evtusername, p.evtjobname , p.evtsource , p.admtarget , p.admpolicystr as Commandstr, p.oprcode , p.vio1code , p.vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY p UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWOBJACCESS' as "__objecttype__", o.evttypecode , o.evtversion , o.evtcatcode , o.evtsysid , o.evtsysplex , o.evtutctod , o.evtsystod , o.evtesmcode , o.evtpuuid , o.evtuserid , o.evtusername, o.evtjobname , o.evtsource , o.usrprogram as admtarget , o.polrule as Commandstr, o.acccode as oprcode , o.vio1code , o.vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS o UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWSECCONTROL' as "__objecttype__", c.evttypecode , c.evtversion , c.evtcatcode , c.evtsysid , c.evtsysplex , c.evtutctod , c.evtsystod , c.evtesmcode , c.evtpuuid , c.evtuserid , c.evtusername, c.evtjobname , c.evtsource , ' ' as admtarget , c.admsecstr as Commandstr, 0 as oprcode , 0 as vio1code , 0 as vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL c UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWADMMISC' as "__objecttype__", m.evttypecode , m.evtversion , m.evtcatcode , m.evtsysid , m.evtsysplex , m.evtutctod , m.evtsystod , m.evtesmcode , m.evtpuuid , m.evtuserid , m.evtusername, m.evtjobname , m.evtsource , ' ' as admtarget , m.admmiscstr as Commandstr, m.oprcode , m.vio1code , m.vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC m UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWSYSACCESS' as "__objecttype__", s.evttypecode , s.evtversion , s.evtcatcode , s.evtsysid , s.evtsysplex , s.evtutctod , s.evtsystod , s.evtesmcode , s.evtpuuid , s.evtuserid , s.evtusername, s.evtjobname , s.evtsource , s.usrprogram as admtarget , ' ' as Commandstr, 0 as oprcode , s.inf1code as vio1code , s.inf2code as vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS s UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWUSSFILE' as "__objecttype__", f.evttypecode , f.evtversion , f.evtcatcode , f.evtsysid , f.evtsysplex , f.evtutctod , f.evtsystod , f.evtesmcode , f.evtpuuid , f.evtuserid , f.evtusername, f.evtjobname , f.evtsource , f.usrgroup as admtarget , ' ' as Commandstr, f.acccode as oprcode , f.esmrc as vio1code, f.esmreason as vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE f UNION select 'abc' as DATAMART_NAME, 'SECCM.VIEWUSSUSER' as "__objecttype__", r.evttypecode , r.evtversion , r.evtcatcode , r.evtsysid , r.evtsysplex , r.evtutctod , r.evtsystod , r.evtesmcode , r.evtpuuid , r.evtuserid , r.evtusername, r.evtjobname , r.evtsource , r.usruser as admtarget , r.usrgroup as Commandstr, r.ussfunction as oprcode , r.esmrc as vio1code , r.esmreason as vio2code from SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER r DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 1 Node Blocks: 0 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 4 Node Next Batch Calls: 4 Node Blocks: 3 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 3 Node Next Batch Calls: 4 Node Blocks: 3 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 3 Node Next Batch Calls: 6 Node Blocks: 5 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 3 Node Next Batch Calls: 6 Node Blocks: 5 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 3 Node Next Batch Calls: 8 Node Blocks: 7 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 3 Node Next Batch Calls: 8 Node Blocks: 7 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 3 Node Next Batch Calls: 10 Node Blocks: 9 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 2 Node Next Batch Calls: 10 Node Blocks: 9 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 2 Node Next Batch Calls: 12 Node Blocks: 11 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 2 Node Next Batch Calls: 12 Node Blocks: 11 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 1 Node Next Batch Calls: 14 Node Blocks: 13 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 1 Node Next Batch Calls: 14 Node Blocks: 13 Estimated Node Cardinality: -1.0 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 1 Node Next Batch Calls: 16 Node Blocks: 15 DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 1 Node Next Batch Calls: 16 Node Blocks: 16 Estimated Node Cardinality: -1.0 EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) ADMACCTSTR (string) OPRCODE (integer) VIO1CODE (integer) VIO2CODE (integer) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 1 Node Next Batch Calls: 16 Node Blocks: 16 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admtarget, g_0.admacctstr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 'abc' AS DATAMART_NAME 'SECCM.VIEWADMACCOUNT' AS "__objecttype__" a.evttypecode a.evtversion a.evtcatcode a.evtsysid a.evtsysplex a.evtutctod a.evtsystod a.evtesmcode a.evtpuuid a.evtuserid a.evtusername a.evtjobname a.evtsource a.admtarget a.admacctstr AS Commandstr a.oprcode a.vio1code AS VIO1CODE a.vio2code AS VIO2CODE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 21 Node Process Time: 0 Node Cumulative Process Time: 481 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 2 Node Blocks: 1 Estimated Node Cardinality: -1.0 EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMTARGET (string) ADMPOLICYSTR (string) OPRCODE (integer) VIO1CODE (integer) VIO2CODE (integer) Node Output Rows: 21 Node Process Time: 481 Node Cumulative Process Time: 481 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 2 Node Blocks: 1 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admtarget, g_0.admpolicystr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 'abc' AS DATAMART_NAME 'SECCM.VIEWADMPOLICY' AS "__objecttype__" p.evttypecode p.evtversion p.evtcatcode p.evtsysid p.evtsysplex p.evtutctod p.evtsystod p.evtesmcode p.evtpuuid p.evtuserid p.evtusername p.evtjobname p.evtsource p.admtarget p.admpolicystr AS Commandstr p.oprcode p.vio1code AS VIO1CODE p.vio2code AS VIO2CODE DUP_REMOVE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) admtarget (string) Commandstr (string) oprcode (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 13 Node Blocks: 13 Estimated Node Cardinality: -1.0 EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) USRPROGRAM (string) POLRULE (string) ACCCODE (integer) VIO1CODE (integer) VIO2CODE (integer) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 13 Node Blocks: 13 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrprogram, g_0.polrule, g_0.acccode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 'abc' AS DATAMART_NAME 'SECCM.VIEWOBJACCESS' AS "__objecttype__" o.evttypecode o.evtversion o.evtcatcode o.evtsysid o.evtsysplex o.evtutctod o.evtsystod o.evtesmcode o.evtpuuid o.evtuserid o.evtusername o.evtjobname o.evtsource o.usrprogram AS admtarget o.polrule AS Commandstr o.acccode AS oprcode o.vio1code AS VIO1CODE o.vio2code AS VIO2CODE DUP_REMOVE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) admtarget (string) Commandstr (string) oprcode (integer) vio1code (long) vio2code (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 11 Node Blocks: 11 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admsecstr FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 DUP_REMOVE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) admtarget (string) Commandstr (string) OPRCODE (integer) VIO1CODE (long) VIO2CODE (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 9 Node Blocks: 9 Estimated Node Cardinality: -1.0 EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) ADMMISCSTR (string) OPRCODE (integer) VIO1CODE (integer) VIO2CODE (integer) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 9 Node Blocks: 9 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admmiscstr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 'abc' AS DATAMART_NAME 'SECCM.VIEWADMMISC' AS "__objecttype__" m.evttypecode m.evtversion m.evtcatcode m.evtsysid m.evtsysplex m.evtutctod m.evtsystod m.evtesmcode m.evtpuuid m.evtuserid m.evtusername m.evtjobname m.evtsource ' ' AS admtarget m.admmiscstr AS Commandstr m.oprcode m.vio1code AS VIO1CODE m.vio2code AS VIO2CODE DUP_REMOVE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) admtarget (string) Commandstr (string) oprcode (integer) vio1code (long) vio2code (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 7 Node Blocks: 7 Estimated Node Cardinality: -1.0 EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) USRPROGRAM (string) INF1CODE (integer) INF2CODE (integer) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 7 Node Blocks: 7 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrprogram, g_0.inf1code, g_0.inf2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 'abc' AS DATAMART_NAME 'SECCM.VIEWSYSACCESS' AS "__objecttype__" s.evttypecode s.evtversion s.evtcatcode s.evtsysid s.evtsysplex s.evtutctod s.evtsystod s.evtesmcode s.evtpuuid s.evtuserid s.evtusername s.evtjobname s.evtsource s.usrprogram AS admtarget ' ' AS Commandstr 0 AS oprcode s.inf1code AS vio1code s.inf2code AS vio2code DUP_REMOVE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) admtarget (string) Commandstr (string) oprcode (integer) vio1code (long) vio2code (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Next Batch Calls: 5 Node Blocks: 5 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrgroup, g_0.acccode, g_0.esmrc, g_0.esmreason FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 DUP_REMOVE DATAMART_NAME (string) __objecttype__ (string) EVTTYPECODE (integer) EVTVERSION (integer) EVTCATCODE (integer) EVTSYSID (string) EVTSYSPLEX (string) EVTUTCTOD (timestamp) EVTSYSTOD (timestamp) EVTESMCODE (string) EVTPUUID (string) EVTUSERID (string) EVTUSERNAME (string) EVTJOBNAME (string) EVTSOURCE (string) admtarget (string) Commandstr (string) oprcode (integer) vio1code (long) vio2code (long) Node Output Rows: 0 Node Process Time: 0 Node Cumulative Process Time: 0 Node Cumulative Next Batch Process Time: 1 Node Next Batch Calls: 3 Node Blocks: 3 Estimated Node Cardinality: -1.0 SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usruser, g_0.usrgroup, g_0.ussfunction, g_0.esmrc, g_0.esmreason FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS g_0 SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1 DUP_REMOVE