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 (갱신 일시) — -