kpi
Tables (32)
agentinfo
- agentid — varchar(300)
- agentname — varchar(300)
agentinfo_temp
- agentid — varchar(300)
- agentname — varchar(300)
comp_cod
- seq_no — int(11)
- comp_nm — varchar(100)
- comp_cod — varchar(100)
- comp_yn — int(1)
emailhistory
- id — int(11) — NOT NULL
- email — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- sent_at — timestamp
- content — longtext
erb_seq
- next_not_cached_value — bigint(21) — NOT NULL
- minimum_value — bigint(21) — NOT NULL
- maximum_value — bigint(21) — NOT NULL
- start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
- increment — bigint(21) — NOT NULL — increment value
- cache_size — bigint(21) — NOT NULL
- cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
- cycle_count — bigint(21) — NOT NULL — How many cycles have been done
erb_serv_list
- seq_id — int(11)
- ori_id — varchar(100)
- serv_comp — varchar(100)
- serv_nm — varchar(500)
- serv_ip — varchar(100)
- serv_ynn — int(3)
- ins_dttm — timestamp
event_comment
- EC_SEQ — int(11)
- EVENT_ID — varchar(50)
- EC_USER_NM — varchar(50)
- EC_USER_ID — varchar(50)
- EC_COMM — longtext
- INS_DTTM — datetime
event_list
- seq_id — int(255) — NOT NULL
- event_id — varchar(100)
- event_desc — varchar(3000)
- event_host — varchar(100)
- host_ip — varchar(50)
- event_comp — varchar(100)
- event_place — varchar(100)
- event_mail — varchar(100)
- insdttm — timestamp — NOT NULL
- dates — varchar(100)
- is_updated — int(11) — NOT NULL
event_mail
- seq_id — int(11) — NOT NULL
- event_id — varchar(100) — NOT NULL
- event_user_nm — varchar(100) — NOT NULL
- event_user_id — varchar(100) — NOT NULL
- event_desc — longtext — NOT NULL
- event_host — varchar(100) — NOT NULL
- host_ip — varchar(50) — NOT NULL
- event_comp — varchar(100) — NOT NULL
- event_place — varchar(100) — NOT NULL
- event_mail — varchar(100) — NOT NULL
- insdttm — datetime — NOT NULL
- dates — varchar(50) — NOT NULL
event_mail_k
- eventid — varchar(1000)
- hostname — varchar(1000)
- TRIM(NAME) — text
- descript — varchar(3000)
- firsttime — varchar(100)
- lasttime — varchar(100)
- b_lasttime — varchar(100)
- count — varchar(100)
- eventlevel — varchar(100)
- itemcategory — varchar(100)
- ss — varchar(4)
- sr — varchar(4)
- itemid — varchar(100)
- event_Table — varchar(100)
- ins_month — int(11)
- ins_day — int(11)
event_mail_v
- eventid — VARCHAR(1000)
- hostname — VARCHAR(1000)
- TRIM(NAME) — TEXT(65535)
- descript — VARCHAR(3000)
- firsttime — VARCHAR(100)
- lasttime — VARCHAR(100)
- b_lasttime — VARCHAR(100)
- count — VARCHAR(100)
- eventlevel — VARCHAR(100)
- itemcategory — VARCHAR(100)
- ss — VARCHAR(4)
- sr — VARCHAR(4)
- itemid — VARCHAR(100)
- event_Table — VARCHAR(100)
- ins_month — INT(11)
- ins_day — INT(11)
eventgroupinfo
- groupname — varchar(200)
- subgroupname — varchar(200)
- description — varchar(500)
- hostname — varchar(3000)
- ontunename — varchar(500)
- comp_cod — varchar(500)
eventhistory_t
- eventid — varchar(1000)
- hostname — varchar(1000)
- name — varchar(3000)
- descript — varchar(3000)
- firsttime — varchar(100)
- lasttime — varchar(100)
- updatetime — varchar(100)
- duration — varchar(100)
- count — varchar(100)
- ack — varchar(100)
- eventlevel — varchar(100)
- itemcategory — varchar(100)
- itemname — varchar(300)
- itemid — varchar(100)
- eventuser — varchar(300)
- userip — varchar(300)
- actiontime — varchar(100)
- reporter — varchar(2000)
- action — varchar(2000)
- event_Table — varchar(100)
eventhistory_t_temp
- eventid — varchar(1000)
- hostname — varchar(1000)
- ontunename — varchar(1000)
- name — varchar(3000)
- descript — varchar(3000)
- firsttime — varchar(100)
- lasttime — varchar(100)
- updatetime — varchar(100)
- duration — varchar(100)
- count — varchar(100)
- ack — varchar(100)
- eventlevel — varchar(100)
- itemcategory — varchar(100)
- itemname — varchar(300)
- itemid — varchar(100)
- eventuser — varchar(300)
- userip — varchar(300)
- actiontime — varchar(100)
- reporter — varchar(2000)
- action — varchar(2000)
- event_Table — varchar(100)
- ins_dttm — datetime
- ins_year — int(11)
- ins_month — int(11)
- ins_day — int(11)
- ins_cday — int(11)
eventinfo_s
- eventid — varchar(1000)
- hostname — varchar(1000)
- ontunename — varchar(1000)
- name — varchar(300)
- descript — varchar(3000)
- firsttime — varchar(100)
- lasttime — varchar(100)
- duration — varchar(100)
- count — varchar(100)
- ack — varchar(100)
- eventlevel — varchar(100)
- itemcategory — varchar(100)
- itemname — varchar(300)
- itemid — varchar(100)
- orglevel — varchar(100)
- nodisplay — varchar(100)
- lastsendtime — varchar(50)
- sentsms — varchar(50)
- sentemail — varchar(50)
- actiontime — varchar(50)
- reporter — varchar(300)
- action — varchar(50)
- sms — varchar(50)
- email — varchar(50)
- ins_dttm — datetime
- ins_year — int(11)
- ins_month — int(11)
- ins_day — int(11)
- ins_cday — int(11)
- sor_Table — varchar(1000)
host_seq
- next_not_cached_value — bigint(21) — NOT NULL
- minimum_value — bigint(21) — NOT NULL
- maximum_value — bigint(21) — NOT NULL
- start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
- increment — bigint(21) — NOT NULL — increment value
- cache_size — bigint(21) — NOT NULL
- cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
- cycle_count — bigint(21) — NOT NULL — How many cycles have been done
ins_sr
- sr_id — varchar(50)
- sr_owner — varchar(50)
- sr_req_user — varchar(50)
- sr_req_comp — varchar(50)
- sr_owner_dept — varchar(50)
- sr_status — varchar(50)
- sr_req_dttm — date
- sr_agredttm — date
- sr_owari_dttm — date
- sr_delay_yn — varchar(50)
- sr_title — varchar(2000)
ins_sr_temp
- sr_id — varchar(50)
- sr_owner — varchar(50)
- sr_req_user — varchar(50)
- sr_req_comp — varchar(50)
- sr_owner_dept — varchar(50)
- sr_status — varchar(50)
- sr_req_dttm — varchar(50)
- sr_agredttm — varchar(50)
- sr_owari_dttm — varchar(50)
- sr_delay_yn — varchar(50)
- sr_title — varchar(2000)
itsm_chm
- chmId — varchar(100)
- chmAgreDeadYmd — varchar(100)
- chmCloYmdt — varchar(100)
- chmDeadReqYmdt — varchar(100)
- chmDelayYn — varchar(100)
- chmOwnDeptNm — varchar(100)
- chmOwnEmplId — varchar(100)
- chmOwnEmplNm — varchar(100)
- chmPlanStartYmdt — varchar(100)
- chmReqDeptNm — varchar(100)
- chmReqEmplId — varchar(100)
- chmReqOrgNm — varchar(100)
- chmReqTitle — varchar(3000)
- chmReqYmdt — varchar(100)
- chmSrcId — varchar(100)
- chmSysId — varchar(3000)
- chmTaskId — varchar(100)
- chmTaskNm — varchar(100)
- effOrgNm — varchar(3000)
itsm_chm_temp
- chmId — varchar(100)
- chmAgreDeadYmd — varchar(100)
- chmCloYmdt — varchar(100)
- chmDeadReqYmdt — varchar(100)
- chmDelayYn — varchar(100)
- chmOwnDeptNm — varchar(100)
- chmOwnEmplId — varchar(100)
- chmOwnEmplNm — varchar(100)
- chmPlanStartYmdt — varchar(100)
- chmReqDeptNm — varchar(100)
- chmReqEmplId — varchar(100)
- chmReqOrgNm — varchar(100)
- chmReqTitle — varchar(3000)
- chmReqYmdt — varchar(100)
- chmSrcId — varchar(100)
- chmSysId — varchar(3000)
- chmTaskId — varchar(100)
- chmTaskNm — varchar(100)
- effOrgNm — varchar(3000)
napgii
- mon — VARCHAR(2)
- totsr — BIGINT(21) — NOT NULL
- dsr — BIGINT(21)
r_event_item
- event_id — varchar(100)
- event_nm — varchar(1000)
- event_desc — varchar(3000)
- event_use — varchar(50)
- event_cat — varchar(50)
- event_meb — varchar(2000)
- event_part_cod — varchar(50)
- evt_group_cod — varchar(50)
- ind_dttm — datetime
r_eventhistory
- eventid — varchar(100)
- hostname — varchar(100)
- ontunename — varchar(100)
- name — varchar(300)
- descript — varchar(2000)
- firsttime — varchar(100)
- lasttime — varchar(100)
- updatetime — varchar(100)
- duration — varchar(100)
- count — varchar(100)
- ack — varchar(100)
- eventlevel — varchar(100)
- itemcategory — varchar(100)
- itemname — varchar(300)
- itemid — varchar(100)
- eventuser — varchar(300)
- userip — varchar(300)
- actiontime — varchar(100)
- reporter — varchar(2000)
- action — varchar(2000)
- ins_dttm — datetime
- ins_year — int(11)
- ins_month — int(11)
- ins_day — int(11)
- ins_cday — int(11)
r_host_info
- seq_id — int(11) — NOT NULL
- host_nm — varchar(100)
- host_comp_cod — varchar(100)
- host_wp_lv1 — varchar(100)
- host_wp_lv2 — varchar(100)
- host_wp_lv3 — varchar(100)
- host_wp_lv4 — varchar(100)
- host_wp_lv5 — varchar(100)
- host_use — int(11)
- host_work_g — varchar(50)
- host_ip — varchar(100)
- ins_dttm — datetime
r_wp_cod
- wp_id — int(11) — NOT NULL
- wp_nm — varchar(100)
- wp_cod — varchar(50)
- wp_lv — varchar(50)
- wp_pid — int(11)
serv_inf_ha
- seq_id — int(11)
- host_nm — varchar(200) — NOT NULL
- host_hai — varchar(200) — NOT NULL
- host_grp_cod — varchar(200) — NOT NULL
- host_comp_cod — varchar(200) — NOT NULL
- host_lv1 — varchar(200) — NOT NULL
- host_lv2 — varchar(200) — NOT NULL
- host_lv3 — varchar(200) — NOT NULL
- host_lv4 — varchar(200) — NOT NULL
- ins_dttm — datetime — NOT NULL
temp_agentinfo
- agentid — varchar(300)
- agentname — varchar(300)
- enabled — int(11)
- connected — int(11)
- updated — int(11)
- shorttermbasic — int(11)
- shorttermproc — int(11)
- shorttermio — int(11)
- shorttermcpu — int(11)
- longtermbasic — int(11)
- longtermproc — int(11)
- longtermio — int(11)
- longtermcpu — int(11)
- model — varchar(300)
- serials — varchar(500)
- groupa — varchar(1000)
- ipaddress — varchar(500)
- pscommand — varchar(1000)
- logevent — varchar(3000)
- processevent — varchar(2000)
- timecheck — varchar(1000)
- disconnectedtime — varchar(1000)
- skipdatatypes — varchar(100)
- virbasicperf — varchar(100)
- hypervisor — varchar(100)
- serviceevent — varchar(2000)
- installdate — varchar(100)
- ibmpcrate — varchar(100)
- updatedtime — varchar(100)
temp_host
- id — int(11) — NOT NULL
- hai — varchar(255)
- word — varchar(255)
urls
- user_nm — varchar(300)
- user_mail — varchar(255)
- day — int(20)
- url — varchar(255) — NOT NULL
- expiry_date — datetime
user_info
- seq_no — int(11) — NOT NULL
- user_id — varchar(100) — NOT NULL
- user_nm — varchar(100) — NOT NULL
- user_sa — varchar(100)
- user_yn — tinyint(1)
- user_pw — varchar(100)
- cre_dttm — datetime
- user_lv — int(11)
- user_mail — varchar(100) — NOT NULL
- user_job_cat — varchar(20) — NOT NULL
- email — varchar(100)
- email_token — varchar(200)
- token_expire — varchar(100)
user_seq
- next_not_cached_value — bigint(21) — NOT NULL
- minimum_value — bigint(21) — NOT NULL
- maximum_value — bigint(21) — NOT NULL
- start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
- increment — bigint(21) — NOT NULL — increment value
- cache_size — bigint(21) — NOT NULL
- cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
- cycle_count — bigint(21) — NOT NULL — How many cycles have been done
work_seq
- next_not_cached_value — bigint(21) — NOT NULL
- minimum_value — bigint(21) — NOT NULL
- maximum_value — bigint(21) — NOT NULL
- start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
- increment — bigint(21) — NOT NULL — increment value
- cache_size — bigint(21) — NOT NULL
- cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
- cycle_count — bigint(21) — NOT NULL — How many cycles have been done