Audit
no function
1 queryGetParamDb
2 queryByNeExec
3 queryByDateExec
4 checkHeadersParam
WHERE
\t)
DATE(b.datetime_id)
GROUP BY BETWEEN 'xxstartDatexx' AND 'xxendDatexx'
AND (
v.VENDOR_NAME,
xxfinalQueryxx
r.AREA_NAME,
\t)r.REGION_NAME,
GROUP
select BY v.VENDOR_NAME,
c.CITY_NAME,
m.mo_id, m.table_name, h.OBJ_COLUMN, n.OBJ_TABLE, n.PARAM_TABLE, n.FACT_TABLE, n.NE_ID
r.AREA_NAME,
fromp.POP_NAME,
APPS_ICAM.APPS_C_HIERARCHY h query
r.REGION_NAME,
joina.ne_id,
APPS_ICAM.APPS_C_NES n on n.NE_ID = h.NE_ID
c.CITY_NAME,
joinb.ne_id,
APPS_ICAM.APPS_C_MOS m on m.ne_id = h.NE_ID
p.POP_NAME,
a.command_name,
where h.DOMAIN_ID = 'xxdomainxx' and h.VENDOR_ID = 'xxvendorxx' and h.NE_ID = 'xxne_idxx' and m.mo_id in ('xxfinalMoI
a.ne_id,
xxgroup_idxx
b.ne_id,
a.datetime_id,
a.command_name,
b.datetime_id
xxgroup_idxx
a.datetime_id,
b.datetime_id
select PARAM_NAME from xxdbxx.xxtablexx where MO_ID = 'xxmoIdxx'
ACT_TABLE, n.NE_ID
ne_idxx' and m.mo_id in ('xxfinalMoIdsxx')
QUERY
SELECT * FROM SERVO_TRAVERSA_PS.A_USER_LOGIN_COUNT aulc WHERE DATE_FORMAT(aulc.`DATE`,
SELECT count(*) FROM SERVO_TRAVERSA_PS.A_USER_LOGIN_COUNT aulc WHERE DATE_FORMAT(aulc.
SELECT * FROM SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV WHERE (:filter IS NULL OR :filter = '
SELECT COUNT(*) FROM SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV WHERE (:filter IS NULL OR :fil
SELECT * FROM SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV
SELECT * SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV WHERE (:filter IS NULL OR LOWER(MENU_NAME)
SELECT COALESCE(MAX(SEQUENT_VIEW), 0) FROM SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV
SELECT * FROM SERVO_TRAVERSA_PS.APPS_C_ROLES
SELECT M.MENU_ID, M.FE_MENU_ID, M.MENU_TITLE, M.IS_ACTIVE, COALESCE((SELECT P.IS_VIEW
SELECT * FROM SERVO_TRAVERSA_PS.APPS_C_ROLES
SELECT COALESCE(MAX(ROLE_ID), 0) FROM SERVO_TRAVERSA_PS.APPS_C_ROLES
SELECT COUNT(*) FROM SERVO_TRAVERSA_PS.APPS_C_ROLES WHERE ROLE_ID = :roleId
SELECT ROLE_NAME FROM SERVO_TRAVERSA_PS.APPS_C_ROLES WHERE ROLE_ID = :roleId limit 1
DELETE FROM RolePrivilegeEntity r WHERE r.roleId = :roleId
SELECT * FROM `APPS_C_ROLES` WHERE `ROLE_ID` = :roleId
SELECT R.ROLE_ID, R.ROLE_NAME, R.REGIONAL_ACCESS, R.IS_ACTIVE, R.UPDATED_BY, R.UPDATED
SELECT * FROM SERVO_TRAVERSA_PS.APPS_C_ROLES WHERE ROLE_ID = :roleId
INSERT INTO SERVO_TRAVERSA_PS.APPS_C_ROLES (ROLE_NAME, REGIONAL_ACCESS, IS_ACTIVE, UPD
UPDATE SERVO_TRAVERSA_PS.APPS_C_ROLES SET ROLE_NAME = :roleName, REGIONAL_ACCESS = :re
DELETE FROM SERVO_TRAVERSA_PS.APPS_C_ROLES WHERE ROLE_ID = :roleId
INSERT INTO `TRAVERSA_V2.APP_USER_ACTIVITY` (ACTIVITY, DATETIME_ID, USERNAME) VALUES (
SELECT acmp.*, arp.IS_VIEW, arp.IS_CREATE, arp.IS_UPDATE, arp.IS_DELETE FROM `SERVO_TR
SELECT * FROM `A_USER_MANAGEMENT` WHERE `USERNAME` = :username
SELECT CAST(r.`IS_VIEW` AS UNSIGNED) AS IS_VIEW FROM `APPS_C_MENU_PRIV` mp LEFT JOIN (
SELECT EXISTS(SELECT 1 FROM A_USER_MANAGEMENT WHERE username = :username) AS is_exists
SELECT aum.USER_ID, aum.USERNAME, aum.PASSWORD, aum.EMAIL, aum.PHONE, aum.DEPARTMENT,
SELECT aum.USER_ID, aum.USERNAME, aum.PASSWORD, aum.EMAIL, aum.PHONE, aum.DEPARTMENT,
SELECT count(USERNAME) FROM SERVO_TRAVERSA_PS.A_USER_MANAGEMENT aum
DELETE FROM `A_USER_MANAGEMENT` WHERE `USERNAME` = :username
UPDATE `A_USER_MANAGEMENT` SET `ACTIVE` = 1, `LOGIN_STATUS` = 'NOT LOGIN', `TOKEN` = N
SELECT aum.USER_ID, aum.USERNAME, aum.PASSWORD, aum.EMAIL, aum.PHONE, aum.DEPARTMENT,
SELECT * FROM APPS_ICAM.APPS_C_REGION
SELECT acmp.MENU_ID, acmp.SEQUENT_VIEW, acmp.MENU_PARENT_ID, acmp.MENU_PARENT_1, acmp.
INSERT INTO TRAVERSA_V2.APP_USER_ACTIVITY (DATETIME_ID, USERNAME, ACTIVITY) VALUES (no
DELETE FROM SERVO_TRAVERSA_PS.APPS_ROLE_PRIV WHERE ROLE_ID = ?
DELETE FROM SERVO_TRAVERSA_PS.APPS_C_ROLES WHERE ROLE_ID = ?
INSERT INTO SERVO_TRAVERSA_PS.APPS_C_ROLES (ROLE_ID, ROLE_NAME, REGIONAL_ACCESS, IS_AC
UPDATE SERVO_TRAVERSA_PS.APPS_C_ROLES SET ROLE_NAME = ?, REGIONAL_ACCESS = ?, IS_ACTIV
INSERT INTO SERVO_TRAVERSA_PS.APPS_ROLE_PRIV (ROLE_ID, MENU_ID, IS_ACTIVE, IS_VIEW, IS
_FORMAT(aulc.`DATE`,'%Y-%m%d') = DATE_FORMAT(now(),'%Y-%m%d')
RE DATE_FORMAT(aulc.`DATE`,'%Y-%m%d') = DATE_FORMAT(now(),'%Y-%m%d')
NULL OR :filter = '' OR MENU_TITLE LIKE CONCAT('%', :filter, '%'))
lter IS NULL OR :filter = '' OR MENU_TITLE LIKE CONCAT('%', :filter, '%'))
OR LOWER(MENU_NAME) LIKE LOWER(CONCAT('%', :filter, '%'))) ORDER BY CASE WHEN :sort = 'desc' THEN :sor
C_MENU_PRIV
E((SELECT P.IS_VIEW FROM SERVO_TRAVERSA_PS.APPS_ROLE_PRIV P LEFT JOIN SERVO_TRAVERSA_PS.APPS_C_ROLES R
= :roleId
= :roleId limit 1
PDATED_BY, R.UPDATED_AT, R.UPDATED_DATE, COUNT(U.ROLE_ID) AS JML FROM SERVO_TRAVERSA_PS.APPS_C_ROLES R
CESS, IS_ACTIVE, UPDATED_BY, UPDATED_AT, UPDATED_DATE) VALUES (:roleName, :regionalAccess, :isActive, :
EGIONAL_ACCESS = :regionalAccess, IS_ACTIVE = :isActive, UPDATED_BY = :updatedBy, UPDATED_AT = :updated
, USERNAME) VALUES (:activity, :datetimeId, :username)
ELETE FROM `SERVO_TRAVERSA_PS.A_USER_MANAGEMENT` aum LEFT JOIN `SERVO_TRAVERSA_PS.APPS_C_ROLES` acr ON
PRIV` mp LEFT JOIN (SELECT um.`USERNAME`, rp.`ROLE_ID`, rp.`MENU_ID`, rp.`IS_VIEW`, rp.`IS_ACTIVE` FROM
ername) AS is_exists;
NE, aum.DEPARTMENT, aum.ALIAS, aum.MODULE, aum.ROLE_ID, aum.ACTIVE, aum.LOGIN_STATUS, '' as TOKEN, DATE
NE, aum.DEPARTMENT, aum.ALIAS, aum.MODULE, aum.ROLE_ID, aum.ACTIVE, aum.LOGIN_STATUS, '' as TOKEN, DATE
LOGIN', `TOKEN` = NULL WHERE `USERNAME` = :username
NE, aum.DEPARTMENT, aum.ALIAS, aum.MODULE, aum.ROLE_ID, aum.ACTIVE, aum.LOGIN_STATUS, '' as TOKEN, DATE
MENU_PARENT_1, acmp.MENU_PARENT_2, acmp.MENU_PARENT_3, acmp.MENU_PARENT_4, acmp.MENU_PARENT_5, acmp.FE_
ACTIVITY) VALUES (now(), :username, :activity)
GIONAL_ACCESS, IS_ACTIVE, UPDATED_BY, UPDATED_AT, UPDATED_DATE) VALUES (?, ?, ?, ?, ?, ?, ?)
ACCESS = ?, IS_ACTIVE = ?, UPDATED_BY = ?, UPDATED_AT = ?, UPDATED_DATE = ? WHERE ROLE_ID = ?
_ACTIVE, IS_VIEW, IS_CREATE, IS_UPDATE, IS_DELETE, UPDATED_AT) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
t = 'desc' THEN :sortby END DESC, CASE WHEN :sort = 'asc' THEN :sortby END ASC LIMIT :limit OFFSET :off
A_PS.APPS_C_ROLES R ON P.ROLE_ID = R.ROLE_ID WHERE P.MENU_ID = M.MENU_ID AND (R.ROLE_ID = :roleId OR R.
A_PS.APPS_C_ROLES R LEFT JOIN SERVO_TRAVERSA_PS.A_USER_MANAGEMENT U ON U.ROLE_ID = R.ROLE_ID GROUP BY R
Access, :isActive, :updatedBy, :updatedAt, :updatedDate) RETURNING *
PDATED_AT = :updatedAt, UPDATED_DATE = :updatedDate WHERE ROLE_ID = :roleId RETURNING *
PPS_C_ROLES` acr ON aum.ROLE_ID = acr.ROLE_ID LEFT JOIN `SERVO_TRAVERSA_PS.APPS_ROLE_PRIV` arp ON arp.R
rp.`IS_ACTIVE` FROM `A_USER_MANAGEMENT` um LEFT JOIN `APPS_ROLE_PRIV` rp ON rp.`ROLE_ID` = um.`ROLE_ID
S, '' as TOKEN, DATE_FORMAT(aum.LAST_LOGIN, '%Y-%m-%d %H:%i:%s') AS LAST_LOGIN, DATE_FORMAT(aum.LAST_LO
S, '' as TOKEN, DATE_FORMAT(aum.LAST_LOGIN, '%Y-%m-%d %H:%i:%s') AS LAST_LOGIN, DATE_FORMAT(aum.LAST_LO
S, '' as TOKEN, DATE_FORMAT(aum.LAST_LOGIN, '%Y-%m-%d %H:%i:%s') AS LAST_LOGIN, DATE_FORMAT(aum.LAST_LO
U_PARENT_5, acmp.FE_MENU_ID, acmp.MENU_NAME, acmp.MENU_TITLE, acmp.MENU_URL, acmp.ICON, arp.IS_VIEW, ar
?, ?, ?)
OLE_ID = ?
?, ?, ?, ?)
T :limit OFFSET :offset
E_ID = :roleId OR R.ROLE_ID IS NULL) LIMIT 1), 0) AS IS_VIEW, M.MENU_PARENT_ID FROM SERVO_TRAVERSA_PS.A
R.ROLE_ID GROUP BY R.ROLE_ID;
E_PRIV` arp ON arp.ROLE_ID = acr.ROLE_ID LEFT JOIN `SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV` acmp ON arp.MEN
LE_ID` = um.`ROLE_ID` WHERE um.`USERNAME` = :username AND rp.`IS_ACTIVE` = 1) r ON r.`MENU_ID` = mp.`ME
E_FORMAT(aum.LAST_LOGOUT, '%Y-%m-%d %H:%i:%s') AS LAST_LOGOUT, aum.CREATED_BY, DATE_FORMAT(aum.CREATED_
E_FORMAT(aum.LAST_LOGOUT, '%Y-%m-%d %H:%i:%s') AS LAST_LOGOUT, aum.CREATED_BY, DATE_FORMAT(aum.CREATED_
E_FORMAT(aum.LAST_LOGOUT, '%Y-%m-%d %H:%i:%s') AS LAST_LOGOUT, aum.CREATED_BY, DATE_FORMAT(aum.CREATED_
CON, arp.IS_VIEW, arp.IS_CREATE, arp.IS_UPDATE, arp.IS_DELETE FROM SERVO_TRAVERSA_PS.A_USER_MANAGEMENT
SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV M WHERE M.IS_ACTIVE = 1 ORDER BY M.MENU_ID;
IV` acmp ON arp.MENU_ID = acmp.MENU_ID WHERE aum.USERNAME= :username AND acmp.IS_ACTIVE = 1 AND acr.IS
.`MENU_ID` = mp.`MENU_ID` WHERE mp.`API_URL` LIKE :pathApi LIMIT 1;
FORMAT(aum.CREATED_DATE, '%Y-%m-%d %H:%i:%s') AS CREATED_DATE, aum.UPDATED_BY, DATE_FORMAT(aum.UPDATED
FORMAT(aum.CREATED_DATE, '%Y-%m-%d %H:%i:%s') AS CREATED_DATE, aum.UPDATED_BY, DATE_FORMAT(aum.UPDATED
FORMAT(aum.CREATED_DATE, '%Y-%m-%d %H:%i:%s') AS CREATED_DATE, aum.UPDATED_BY, DATE_FORMAT(aum.UPDATED
.A_USER_MANAGEMENT aum LEFT JOIN SERVO_TRAVERSA_PS.APPS_C_ROLES acr ON aum.ROLE_ID = acr.ROLE_ID LEFT
TIVE = 1 AND acr.IS_ACTIVE = 1 AND arp.IS_ACTIVE = 1 AND aum.ACTIVE = 1;
_FORMAT(aum.UPDATED_DATE, '%Y-%m-%d %H:%i:%s') AS UPDATED_DATE FROM `A_USER_MANAGEMENT` aum LEFT JOIN `
_FORMAT(aum.UPDATED_DATE, '%Y-%m-%d %H:%i:%s') AS UPDATED_DATE FROM `A_USER_MANAGEMENT` aum LEFT JOIN `
_FORMAT(aum.UPDATED_DATE, '%Y-%m-%d %H:%i:%s') AS UPDATED_DATE FROM `A_USER_MANAGEMENT` aum LEFT JOIN `
= acr.ROLE_ID LEFT JOIN SERVO_TRAVERSA_PS.APPS_ROLE_PRIV arp ON arp.ROLE_ID = acr.ROLE_ID LEFT JOIN SER
ENT` aum LEFT JOIN `APPS_C_ROLES` r ON aum.ROLE_ID = r.ROLE_ID WHERE (:search IS NULL OR USERNAME LIKE
ENT` aum LEFT JOIN `APPS_C_ROLES` r ON aum.ROLE_ID = r.ROLE_ID WHERE (:search IS NULL OR USERNAME LIKE
ENT` aum LEFT JOIN `APPS_C_ROLES` r ON aum.ROLE_ID = r.ROLE_ID WHERE LOWER(aum.username) LIKE LOWER(CON
OLE_ID LEFT JOIN SERVO_TRAVERSA_PS.APPS_C_MENU_PRIV acmp ON arp.MENU_ID = acmp.MENU_ID WHERE aum.USERNA
LL OR USERNAME LIKE CONCAT('%', :search, '%') OR EMAIL LIKE CONCAT('%', :search, '%') OR PHONE LIKE CON
LL OR USERNAME LIKE CONCAT('%', :search, '%') OR EMAIL LIKE CONCAT('%', :search, '%') OR PHONE LIKE CON
name) LIKE LOWER(CONCAT('%', :keyword, '%')) OR LOWER(aum.email) LIKE LOWER(CONCAT('%', :keyword, '%'))
_ID WHERE aum.USERNAME = :username AND acmp.IS_ACTIVE = 1 AND acr.IS_ACTIVE = 1 AND arp.IS_ACTIVE = 1 A
') OR PHONE LIKE CONCAT('%', :search, '%') OR ALIAS LIKE CONCAT('%', :search, '%') OR DEPARTMENT LIKE C
') OR PHONE LIKE CONCAT('%', :search, '%') OR ALIAS LIKE CONCAT('%', :search, '%') OR DEPARTMENT LIKE C
'%', :keyword, '%')) OR LOWER(aum.ALIAS) LIKE LOWER(CONCAT('%', :keyword, '%')) OR LOWER(aum.PHONE) LIK
arp.IS_ACTIVE = 1 AND aum.ACTIVE = 1;
R DEPARTMENT LIKE CONCAT('%', :search, '%')) ORDER BY CASE WHEN :sort = 'USERNAME' THEN USERNAME WHEN
R DEPARTMENT LIKE CONCAT('%', :search, '%')) ORDER BY CASE WHEN :sort = 'USERNAME' THEN USERNAME WHEN
OWER(aum.PHONE) LIKE LOWER(CONCAT('%', :keyword, '%')) OR LOWER(aum.DEPARTMENT) LIKE LOWER(CONCAT('%',
THEN USERNAME WHEN :sort = 'EMAIL' THEN EMAIL WHEN :sort = 'PHONE' THEN PHONE WHEN :sort = 'ALIAS' THEN
THEN USERNAME WHEN :sort = 'EMAIL' THEN EMAIL WHEN :sort = 'PHONE' THEN PHONE WHEN :sort = 'ALIAS' THEN
E LOWER(CONCAT('%', :keyword, '%'));
:sort = 'ALIAS' THEN ALIAS WHEN :sort = 'DEPARTMENT' THEN DEPARTMENT WHEN :sort = 'ROLE' THEN r.ROLE_NA
:sort = 'ALIAS' THEN ALIAS WHEN :sort = 'DEPARTMENT' THEN DEPARTMENT WHEN :sort = 'ROLE' THEN r.ROLE_NA
ROLE' THEN r.ROLE_NAME WHEN :sort = 'LOGIN_STATUS' THEN LOGIN_STATUS WHEN :sort = 'LAST_LOGIN' THEN LAS
ROLE' THEN r.ROLE_NAME WHEN :sort = 'LOGIN_STATUS' THEN LOGIN_STATUS WHEN :sort = 'LAST_LOGIN' THEN LAS
LAST_LOGIN' THEN LAST_LOGIN WHEN :sort = 'LAST_LOGOUT' THEN LAST_LOGOUT END ASC LIMIT :limit OFFSET :of
LAST_LOGIN' THEN LAST_LOGIN WHEN :sort = 'LAST_LOGOUT' THEN LAST_LOGOUT END DESC LIMIT :limit OFFSET :o
IT :limit OFFSET :offset;
MIT :limit OFFSET :offset;
NO Api keterangan total Query
1 list region 1
3 list-pop 1
4 data-statistic 2
5 data-statistic-detail 1
6 data-map 2
7 data untuk tabel 2
8 data-download download data table 1
9 data-chart-ne chart bar 1
11
Menu Keterangan total Query
1 liet-vendor 1
2 list-ne-type 1
3 get-obj-hie 2
4 get-param-hie 2
5 exec show data 3
6 exec-download download data 3
12
Menu Keterangan total Query
1 data list data recon 5
2 f5-status 1
3 download-script 1
4 mop-ready 1
5 crq-number 2
6 rollback-button 1
7 Monitoring ne 8
19
