Asset
Tables (10)
INTELLIGENT_DUMP_A
- SITE_CD — VARCHAR(50) — Site Code' COLLATE 'utf8_general_ci
- CMPN_ID — VARCHAR(50) — Company ID' COLLATE 'utf8_general_ci
- VNDR — VARCHAR(50)
- ALIAS — VARCHAR(100)
- ACC_ID — VARCHAR(500)
- RGN_ID — VARCHAR(50) — Region ID' COLLATE 'utf8_general_ci
- RSRC_TYPE_ORG — VARCHAR(2000)
- RSRC_TYPE — VARCHAR(2000) — Resource Type' COLLATE 'utf8_general_ci
- RSRC_NM — VARCHAR(100)
- SVC_GRP_SET_ID — VARCHAR(50)
- SVC_GRP_SET_NM — VARCHAR(256)
- SVC_GRP_ID — VARCHAR(50)
- SVC_GRP_NM — VARCHAR(256)
- TAG_KEY — VARCHAR(250)
- TAG_VAL — VARCHAR(250)
- USE_ST_DT — DATETIME
- USE_END_DT — DATETIME
- HIST_YN — CHAR(1)
- PERF_YN — CHAR(1)
- USE_YN — CHAR(1)
- DEL_YN — CHAR(1)
- FLAG — CHAR(1)
- INDEX — `INTELLIGENT_DUMP_A`
TASM_CMPN_BZ_GRP_L (서비스 그룹 리스트)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- BZ_GRP_SET_ID (View ID) — 50
- CMPN_BZ_GRP_ID (Service Group ID) — 50
- CMPN_BZ_GRP_NM (Service Group Name) — 256
- CMPN_BZ_GRP_DESC (Service Group 설명) — 255
- FLDR_ID (Folder ID) — 50
- REPT_YN (반복 설정) — 1
- REPT_END_DT (반복 종료 시간) — -
- CREA_DT (등록 일시) — -
- CREA_ID (등록 User ID) — 50
- CREA_IPADDR (등록 User IP) — 39
- UPDT_DT (갱신 일시) — -
- UPDT_ID (갱신 User ID) — 50
- UPDT_IPADDR (갱신 User IP) — 39
TASM_CMPN_BZ_GRP_MAPP_L (서비스 그룹 맵핑 테이블)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- BZ_GRP_SET_ID (View ID) — 50
- CMPN_BZ_GRP_ID (Service Group ID) — 50
- CLOUD_VNDR_ID (Vendor ID) — 50
- ACC_ID (계정 ID) — 50
- RGN_ID (지역 ID) — 50
- RSRC_TYPE (자원 타입) — 255
- INST_ID (aws - Instance ID , azure - RSRC_SEQ) — 255
- AZR_RSRC_ID (azure seq id 에 대한 resource id) — 1024
- CND_ID (RULE CND ID) — 50
- CREA_DT (등록 일시) — -
- CREA_ID (등록 User ID) — 50
- CREA_IPADDR (등록 User IP) — 39
- UPDT_DT (갱신 일시) — -
- UPDT_ID (갱신 User ID) — 50
- UPDT_IPADDR (갱신 User IP) — 39
TASM_CMPN_BZ_GRP_SET_M (서비스 그룹 View 리스트)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- BZ_GRP_SET_ID (View ID) — 50
- BZ_GRP_SET_NM (View Name) — 100
- RULE_SET_ALIAS (RULE SET ALIAS) — 100
- SET_TYPE (A : Account, T: Tag, C: Custom) — 1
- TAG_KEY (Tag Key) — 255
- DFLT_YN (Default View 여부) — 1
- RULE_SET_DESC (RULE SET 설명) — 1000
- CREA_DT (등록 일시) — -
- CREA_ID (등록 User ID) — 50
- CREA_IPADDR (등록 User IP) — 39
- UPDT_DT (갱신 일시) — -
- UPDT_ID (갱신 User ID) — 50
- UPDT_IPADDR (갱신 User IP) — 39
TASM_IDLE_RSC_AWS_ANALY_L (Resource Optimization Unused)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- ACC_ID (계정 ID) — 50
- RGN_ID (지역 ID) — 50
- RSRC_TYPE (자원 타입) — 100
- INST_ID (Instance ID) — 100
- INST_TYPE (Instance Type) — 30
- NM_VAL (Tag Name Value) — 255
- STATE_NAME (State Name) — 30
- ATMT_ID (Attachment Instance ID) — 30
- RGN_NM (Region Name) — 50
- INSTANCE_FAMILY (Instance Family) — 30
- UNIT (Unit) — 20
- USD (Total Cost) — 20
- COST (Cost) — 20
- IDLE_TYPE (Idle Type) — 150
- DESCRIPTION (Description) — 600
- CREA_DT (등록 일시) — -
TASM_PERF_AWS_EC2_CPU_CURR_L (성능 정보)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- ACC_ID (계정 ID) — 30
- RGN_ID (지역 ID) — 20
- INST_ID (Instance ID) — 255
- ARN — 255
- TIME_STMP (Tag Name Value) — 7
- MIN (Min) — 22,0
- MAX (Max) — 22,0
- AVG (Average) — 22,0
- SAMPLE_CNT (Count) — 22,0
TASM_RIGHT_SIZE_AWS_ANALY_L (Right-Sizing List)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- ACC_ID (계정 ID) — 50
- RGN_ID (지역 ID) — 50
- RSRC_TYPE (자원 타입) — 50
- INST_ID (Instance ID) — 100
- RCMD (Recommend) — 30
- MT_TOT_COST (Metering cost) — 22,0
- CLOUD_VNDR_ID (account 30dlf) — 1
- TOT_DAY (Total Day) — 11
- INST_TYPE (Instance Type) — 30
- PREV_COST (Previous Cost) — 22,0
- PREV_ECU (Previous ECU) — 20
- PREV_USD (Previous USD(Cost)) — 22,0
- PREV_NW_PERF_ODR (Previous Nework Performance Order) — 5
- PREV_NW_PERF_NM (Previous Nework Performance Name) — 50
- PREV_MEM (Previous Memory) — 20
- PREV_STRGE (Previous Storage) — 50
- RCMD_TYPE (Recommend Type) — 30
- RCMD_COST (Recommend Cost) — 22,0
- RCMD_ECU (Recommend ECU) — 50
- RCMD_USD (Recommend USD) — 22,0
- RCMD_NW_PERF_ODR (Recommend Nework Performance Order) — 50
- RCMD_NW_PERF_NM (Recommend Nework Performance Name) — 50
- RCMD_MEM (Recommend Memory) — 50
- RCMD_STRGE (Recommend Storage) — 50
- MT_RCMD_COST (Metering Recommed Cost by instance use time) — 50
- CON_DAY (Continue Day) — 20
- INST_USE_TIME (Instance Use Time(Frequency)) — 30
- SAVG_COST (Saving Cost) — 50
- REQR_ECU_SPEC (Request ECU Specification) — 20
- REQR_MEM_SPEC (Request Memory Specification) — 20
- OPT_SYS (Operation System(OS)) — 50
- PRE_INSTL_SW (Pre-Installed Software) — 50
- LOCATION (Location(Region)) — 50
- PROD_FAMLY (Product Family) — 50
- TENCY (Tenancy) — 20
- CREA_DT (등록 일시) — -
TASM_USE_AWS_EC2_D
- SITE_CD — VARCHAR(50) — NOT NULL — Site Code' COLLATE 'utf8_general_ci
- CMPN_ID — VARCHAR(50) — NOT NULL — 고객사 아이디' COLLATE 'utf8_general_ci
- ACC_ID — VARCHAR(50) — NOT NULL — 클라우드 Account ID' COLLATE 'utf8_general_ci
- RGN_ID — VARCHAR(50) — NOT NULL — Region' COLLATE 'utf8_general_ci
- RSRC_TYPE — VARCHAR(50) — NOT NULL — Resource Type' COLLATE 'utf8_general_ci
- INST_ID — VARCHAR(100) — NOT NULL — Instance ID' COLLATE 'utf8_general_ci
- AMI_LNCH_IDX — BIGINT(20) — AmiLaunchIndex
- ARCH — VARCHAR(100) — Architecture' COLLATE 'utf8_general_ci
- BLOK_DEVICE_MAPP — TEXT(65535) — BlockDeviceMappings' COLLATE 'utf8_general_ci
- LAST_BLOK_DEVICE_MAPP — TEXT(65535)
- ATCH_CNT — INT(11) — BlockDeviceMappings Attached Count
- CLNT_TOKN — VARCHAR(100) — ClientToken' COLLATE 'utf8_general_ci
- EBS_OTMZ — VARCHAR(5) — EbsOptimized' COLLATE 'utf8_general_ci
- ENA_SPRT — VARCHAR(100) — EnaSupport' COLLATE 'utf8_general_ci
- HPVSR — VARCHAR(100) — Hypervisor' COLLATE 'utf8_general_ci
- IAM_INST_PRFL — TEXT(65535) — IamInstanceProfile' COLLATE 'utf8_general_ci
- IMG_ID — VARCHAR(100) — ImageId' COLLATE 'utf8_general_ci
- INST_LIFE_CYCL — TEXT(65535) — InstanceLifecycle' COLLATE 'utf8_general_ci
- KERNEL_ID — VARCHAR(100) — KernelId' COLLATE 'utf8_general_ci
- KEY_NAME — VARCHAR(255) — KeyName' COLLATE 'utf8_general_ci
- LNCH_TIME — VARCHAR(100) — LaunchTime' COLLATE 'utf8_general_ci
- LNCH_TIME_FRM_STR — VARCHAR(30) — LaunchTime Format to String' COLLATE 'utf8_general_ci
- MONI — TEXT(65535) — Monitoring' COLLATE 'utf8_general_ci
- NW_IF — TEXT(65535) — NetworkInterfaces' COLLATE 'utf8_general_ci
- PLCM — TEXT(65535) — Placement' COLLATE 'utf8_general_ci
- AVAIL_ZONE — VARCHAR(100) — AvailabilityZone' COLLATE 'utf8_general_ci
- PF — VARCHAR(100) — Platform' COLLATE 'utf8_general_ci
- PRV_DNS_NM — VARCHAR(100) — PrivateDnsName' COLLATE 'utf8_general_ci
- PRV_IP_ADDR — VARCHAR(100) — PrivateIpAddress' COLLATE 'utf8_general_ci
- PROD_CD — TEXT(65535) — ProductCodes' COLLATE 'utf8_general_ci
- PBL_DNS_NM — VARCHAR(100) — PublicDnsName' COLLATE 'utf8_general_ci
- PBL_IP_ADDR — VARCHAR(100) — PublicIpAddress' COLLATE 'utf8_general_ci
- RAM_DISK_ID — VARCHAR(100) — RamdiskId' COLLATE 'utf8_general_ci
- ROOT_DEVICE_NM — VARCHAR(100) — RootDeviceName' COLLATE 'utf8_general_ci
- ROOT_DEVICE_TYPE — VARCHAR(100) — RootDeviceType' COLLATE 'utf8_general_ci
- SECR_GRP — TEXT(65535) — SecurityGroups' COLLATE 'utf8_general_ci
- SRC_DEST_CHK — VARCHAR(5) — SourceDestCheck' COLLATE 'utf8_general_ci
- SPOT_INST_REQ_ID — VARCHAR(100) — SpotInstanceRequestId' COLLATE 'utf8_general_ci
- SR_IOV_NET_SPRT — VARCHAR(100) — SriovNetSupport' COLLATE 'utf8_general_ci
- STATE_RSN — TEXT(65535) — StateReason' COLLATE 'utf8_general_ci
- STATE_TRSTN_RSN — VARCHAR(100) — StateTransitionReason' COLLATE 'utf8_general_ci
- SBNET_ID — VARCHAR(100) — SubnetId' COLLATE 'utf8_general_ci
- VTZTN_TYPE — VARCHAR(100) — VirtualizationType' COLLATE 'utf8_general_ci
- VPC_ID — VARCHAR(100) — VpcId' COLLATE 'utf8_general_ci
- OWNER_ID — VARCHAR(100) — OwnerId' COLLATE 'utf8_general_ci
- RSRV_ID — VARCHAR(100) — ReservationId' COLLATE 'utf8_general_ci
- TENANCY — VARCHAR(30) — Placement-Tenancy' COLLATE 'utf8_general_ci
- ROOT_VOL_ID — VARCHAR(50)
- INST_LIFE_CYCLE — VARCHAR(30)
- TAGS — TEXT(65535)
- THREADS_PER_CORE — DOUBLE(22, 0) — ThreadsPerCore
- CORE_COUNT — DOUBLE(22, 0) — CoreCount
- CREA_DT — DATETIME — NOT NULL — 등록일시
- UPDT_DT — DATETIME — 갱신일시
- INDEX — `TASM_USE_AWS_EC2_D_IX01`
TASM_USE_AWS_L (AWS 리소스 정보)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- ACC_ID (클라우드 Account ID) — 50
- RGN_ID (Region) — 50
- RSRC_TYPE (Resource Type) — 50
- INST_ID (Instance ID) — 255
- ARN — 500
- SVC_GRP_ID (서비스 그룹 ID) — 50
- STATE_CODE (State Code) — 30
- STATE_NAME (State Name) — 100
- INST_TYPE (Instance Type) — 30
- CLCT_TIME (수집 일시) — -
- NM_VAL (Tag Name Value) — 255
- DEL_YN (삭제 여부) — 1
- DEL_DT (삭제 일시) — -
- CREA_DT (등록 일시) — -
- UPDT_DT (갱신 일시) — -
TASM_USE_AWS_TAGS_L (태그 정보)
- SITE_CD (Site Code) — 50
- CMPN_ID (고객사 ID) — 50
- ACC_ID (클라우드 Account ID) — 50
- RGN_ID (Region) — 50
- RSRC_TYPE (Resource Type) — 50
- INST_ID (Instance ID) — 255
- KEY (Key) — 255
- VAL (Value) — 300
- SYS_YN (System Tag 여부) — 1
- CLCT_TIME (수집 일시) — -
- DEL_YN (삭제 여부) — 1
- DEL_DT (삭제 일시) — -
- CREA_DT (등록 일시) — -
- UPDT_DT (갱신 일시) — -