Part 1 of 8 listing all the fields in all the
tables of the dwh_capacity Data Mart
Part
1 of 8: dwh_capacity
Part 2 of 8: dwh_capacity_efficiency
Part 3 of 8: dwh_cloud_cost
~~~~~~~~~~~: dwh_custom {skipped as custom}
Part 4 of 8: dwh_fs_util
Part 5 of 8: dwh_inventory
Part 6 of 8: dwh_performance
Part 7 of 8: dwh_ports
Part 8 of 8: dwh_reports
Key = Database.Table.Field
dwh_capacity.application_dimension.tk
dwh_capacity.application_dimension.name
dwh_capacity.application_dimension.description
dwh_capacity.application_dimension.businessUnit
dwh_capacity.application_dimension.priority
dwh_capacity.application_dimension.url
dwh_capacity.application_dimension.id
dwh_capacity.application_dimension.latest
dwh_capacity.application_dimension.dateTk
dwh_capacity.application_group_bridge.appGroupTk
dwh_capacity.application_group_bridge.appTk
dwh_capacity.application_group_bridge.isRep
dwh_capacity.application_group_bridge.businessUnit
dwh_capacity.application_group_dimension.tk
dwh_capacity.application_group_dimension.repApp
dwh_capacity.application_group_dimension.repAppTk
dwh_capacity.application_group_dimension.cardinality
dwh_capacity.application_group_dimension.dateTk
dwh_capacity.business_entity_dimension.tk
dwh_capacity.business_entity_dimension.fullname
dwh_capacity.business_entity_dimension.tenant
dwh_capacity.business_entity_dimension.lob
dwh_capacity.business_entity_dimension.businessUnit
dwh_capacity.business_entity_dimension.project
dwh_capacity.business_entity_dimension.id
dwh_capacity.business_entity_dimension.latest
dwh_capacity.business_entity_dimension.dateTk
dwh_capacity.capacity_type.type
dwh_capacity.capacity_type.used
dwh_capacity.capacity_type.vmSpecific
dwh_capacity.capacity_type.replicationSpecific
dwh_capacity.capacity_type.description
dwh_capacity.cardinals.digit
dwh_capacity.chargeback_fact.tk
dwh_capacity.chargeback_fact.dateTk
dwh_capacity.chargeback_fact.storageTk
dwh_capacity.chargeback_fact.storagePoolTk
dwh_capacity.chargeback_fact.internalVolumeTk
dwh_capacity.chargeback_fact.qtreeTk
dwh_capacity.chargeback_fact.hostTk
dwh_capacity.chargeback_fact.hostGroupTk
dwh_capacity.chargeback_fact.applicationTk
dwh_capacity.chargeback_fact.applicationGroupTk
dwh_capacity.chargeback_fact.tierTk
dwh_capacity.chargeback_fact.serviceLevelTk
dwh_capacity.chargeback_fact.businessUnit
dwh_capacity.chargeback_fact.businessEntityTk
dwh_capacity.chargeback_fact.protectionType
dwh_capacity.chargeback_fact.storageAccessType
dwh_capacity.chargeback_fact.resourceName
dwh_capacity.chargeback_fact.resourceType
dwh_capacity.chargeback_fact.mappedByVM
dwh_capacity.chargeback_fact.virtualStorage
dwh_capacity.chargeback_fact.provisionedCapacityMB
dwh_capacity.chargeback_fact.usedCapacityMB
dwh_capacity.datastore_dimension.tk
dwh_capacity.datastore_dimension.naturalKey
dwh_capacity.datastore_dimension.name
dwh_capacity.datastore_dimension.moid
dwh_capacity.datastore_dimension.virtualCenterIp
dwh_capacity.datastore_dimension.url
dwh_capacity.datastore_dimension.id
dwh_capacity.datastore_dimension.latest
dwh_capacity.datastore_dimension.dateTk
dwh_capacity.date_dimension.tk
dwh_capacity.date_dimension.fullDate
dwh_capacity.date_dimension.dayInMonth
dwh_capacity.date_dimension.dayInYear
dwh_capacity.date_dimension.dateYear
dwh_capacity.date_dimension.yearLabel
dwh_capacity.date_dimension.monthNum
dwh_capacity.date_dimension.monthLabel
dwh_capacity.date_dimension.dayInWeekNum
dwh_capacity.date_dimension.quarter
dwh_capacity.date_dimension.quarterLabel
dwh_capacity.date_dimension.dayInQuarter
dwh_capacity.date_dimension.repQuarter
dwh_capacity.date_dimension.repMonth
dwh_capacity.date_dimension.repWeek
dwh_capacity.date_dimension.repDay
dwh_capacity.date_dimension.repMonthOrLatest
dwh_capacity.date_dimension.sspFlag
dwh_capacity.date_dimension.latest
dwh_capacity.date_dimension.future
dwh_capacity.disk_group_capacity_fact.tk
dwh_capacity.disk_group_capacity_fact.dateTk
dwh_capacity.disk_group_capacity_fact.storageTk
dwh_capacity.disk_group_capacity_fact.storagePoolTk
dwh_capacity.disk_group_capacity_fact.diskGroupTk
dwh_capacity.disk_group_capacity_fact.capacityMB
dwh_capacity.disk_group_capacity_fact.usedCapacityMB
dwh_capacity.disk_group_capacity_fact.physicalDiskCapacityMB
dwh_capacity.disk_group_capacity_future_fact.tk
dwh_capacity.disk_group_capacity_future_fact.dateTk
dwh_capacity.disk_group_capacity_future_fact.storageTk
dwh_capacity.disk_group_capacity_future_fact.storagePoolTk
dwh_capacity.disk_group_capacity_future_fact.diskGroupTk
dwh_capacity.disk_group_capacity_future_fact.capacityMB
dwh_capacity.disk_group_capacity_future_fact.usedCapacityMB
dwh_capacity.disk_group_dimension.tk
dwh_capacity.disk_group_dimension.name
dwh_capacity.disk_group_dimension.identifier
dwh_capacity.disk_group_dimension.vendorDiskGroupType
dwh_capacity.disk_group_dimension.diskType
dwh_capacity.disk_group_dimension.status
dwh_capacity.disk_group_dimension.redundancy
dwh_capacity.disk_group_dimension.isVirtual
dwh_capacity.disk_group_dimension.vendorTier
dwh_capacity.disk_group_dimension.id
dwh_capacity.disk_group_dimension.latest
dwh_capacity.disk_group_dimension.dateTk
dwh_capacity.host_dimension.tk
dwh_capacity.host_dimension.name
dwh_capacity.host_dimension.identifier
dwh_capacity.host_dimension.ip
dwh_capacity.host_dimension.os
dwh_capacity.host_dimension.model
dwh_capacity.host_dimension.manufacturer
dwh_capacity.host_dimension.url
dwh_capacity.host_dimension.id
dwh_capacity.host_dimension.latest
dwh_capacity.host_dimension.dateTk
dwh_capacity.host_dimension.dataCenter
dwh_capacity.host_group_bridge.hostGroupTk
dwh_capacity.host_group_bridge.hostTk
dwh_capacity.host_group_bridge.isRep
dwh_capacity.host_group_dimension.tk
dwh_capacity.host_group_dimension.repHost
dwh_capacity.host_group_dimension.repHostTk
dwh_capacity.host_group_dimension.cardinality
dwh_capacity.host_group_dimension.dateTk
dwh_capacity.internal_volume_capacity_fact.tk
dwh_capacity.internal_volume_capacity_fact.dateTk
dwh_capacity.internal_volume_capacity_fact.storageTk
dwh_capacity.internal_volume_capacity_fact.storagePoolTk
dwh_capacity.internal_volume_capacity_fact.internalVolumeTk
dwh_capacity.internal_volume_capacity_fact.virtualStorageTk
dwh_capacity.internal_volume_capacity_fact.tierTk
dwh_capacity.internal_volume_capacity_fact.applicationTk
dwh_capacity.internal_volume_capacity_fact.applicationGroupTk
dwh_capacity.internal_volume_capacity_fact.serviceLevelTk
dwh_capacity.internal_volume_capacity_fact.businessUnit
dwh_capacity.internal_volume_capacity_fact.businessEntityTk
dwh_capacity.internal_volume_capacity_fact.storageAccessType
dwh_capacity.internal_volume_capacity_fact.protectionType
dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB
dwh_capacity.internal_volume_capacity_fact.consumedCapacityMB
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB
dwh_capacity.internal_volume_capacity_fact.dataUsedCapacityMB
dwh_capacity.internal_volume_capacity_fact.dataUnusedCapacityMB
dwh_capacity.internal_volume_capacity_fact.snapshotAllocatedCapacityMB
dwh_capacity.internal_volume_capacity_fact.snapshotUsedCapacityMB
dwh_capacity.internal_volume_capacity_fact.totalCloneSavedCapacityMB
dwh_capacity.internal_volume_capacity_fact.dedupeRatio
dwh_capacity.internal_volume_capacity_fact.rawToUsableRatio
dwh_capacity.internal_volume_capacity_fact.snapshotCount
dwh_capacity.internal_volume_capacity_fact.lastSnapshotTime
dwh_capacity.internal_volume_capacity_fact.compressionRatio
dwh_capacity.internal_volume_dimension.tk
dwh_capacity.internal_volume_dimension.name
dwh_capacity.internal_volume_dimension.identifier
dwh_capacity.internal_volume_dimension.storagePoolIdentifier
dwh_capacity.internal_volume_dimension.storageName
dwh_capacity.internal_volume_dimension.storageIP
dwh_capacity.internal_volume_dimension.type
dwh_capacity.internal_volume_dimension.virtualStorage
dwh_capacity.internal_volume_dimension.spaceGuarantee
dwh_capacity.internal_volume_dimension.thinProvisioningSupported
dwh_capacity.internal_volume_dimension.thinProvisioned
dwh_capacity.internal_volume_dimension.uuid
dwh_capacity.internal_volume_dimension.url
dwh_capacity.internal_volume_dimension.id
dwh_capacity.internal_volume_dimension.latest
dwh_capacity.internal_volume_dimension.dateTk
dwh_capacity.qtree_capacity_fact.tk
dwh_capacity.qtree_capacity_fact.dateTk
dwh_capacity.qtree_capacity_fact.storageTk
dwh_capacity.qtree_capacity_fact.storagePoolTk
dwh_capacity.qtree_capacity_fact.internalVolumeTk
dwh_capacity.qtree_capacity_fact.qtreeTk
dwh_capacity.qtree_capacity_fact.virtualStorageTk
dwh_capacity.qtree_capacity_fact.tierTk
dwh_capacity.qtree_capacity_fact.serviceLevelTk
dwh_capacity.qtree_capacity_fact.applicationTk
dwh_capacity.qtree_capacity_fact.applicationGroupTk
dwh_capacity.qtree_capacity_fact.businessUnit
dwh_capacity.qtree_capacity_fact.businessEntityTk
dwh_capacity.qtree_capacity_fact.storageAccessType
dwh_capacity.qtree_capacity_fact.protectionType
dwh_capacity.qtree_capacity_fact.hardLimitCapacityMB
dwh_capacity.qtree_capacity_fact.softLimitCapacityMB
dwh_capacity.qtree_capacity_fact.usedCapacityMB
dwh_capacity.qtree_capacity_fact.rawToUsableRatio
dwh_capacity.qtree_capacity_fact.missingQuotaLimits
dwh_capacity.qtree_dimension.tk
dwh_capacity.qtree_dimension.name
dwh_capacity.qtree_dimension.identifier
dwh_capacity.qtree_dimension.storageIdentifier
dwh_capacity.qtree_dimension.type
dwh_capacity.qtree_dimension.url
dwh_capacity.qtree_dimension.id
dwh_capacity.qtree_dimension.latest
dwh_capacity.qtree_dimension.dateTk
dwh_capacity.service_level_dimension.tk
dwh_capacity.service_level_dimension.name
dwh_capacity.service_level_dimension.sequence
dwh_capacity.service_level_dimension.cost
dwh_capacity.service_level_dimension.id
dwh_capacity.service_level_dimension.latest
dwh_capacity.service_level_dimension.dateTk
dwh_capacity.sp_time_to_fill.saspFactTk
dwh_capacity.sp_time_to_fill.daysToStoragePoolFull
dwh_capacity.sp_time_to_fill.dateAtStoragePoolFull
dwh_capacity.storage_and_storage_pool_capacity_fact.tk
dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk
dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk
dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk
dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk
dwh_capacity.storage_and_storage_pool_capacity_fact.backend
dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual
dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.usedRawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.snapshotUsedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.snapshotUsedRawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.softLimitCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.unconfiguredRawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.spareRawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.failedRawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.unusedVolumeCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.mappedVolumeCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.maskedVolumeCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeUsedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_fact.dedupeRatio
dwh_capacity.storage_and_storage_pool_capacity_fact.compressionRatio
dwh_capacity.storage_and_storage_pool_capacity_future_fact.tk
dwh_capacity.storage_and_storage_pool_capacity_future_fact.dateTk
dwh_capacity.storage_and_storage_pool_capacity_future_fact.storagePoolTk
dwh_capacity.storage_and_storage_pool_capacity_future_fact.storageTk
dwh_capacity.storage_and_storage_pool_capacity_future_fact.tierTk
dwh_capacity.storage_and_storage_pool_capacity_future_fact.backend
dwh_capacity.storage_and_storage_pool_capacity_future_fact.isVirtual
dwh_capacity.storage_and_storage_pool_capacity_future_fact.capacityMB
dwh_capacity.storage_and_storage_pool_capacity_future_fact.rawCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedCapacityMB
dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedRawCapacityMB
dwh_capacity.storage_dimension.tk
dwh_capacity.storage_dimension.name
dwh_capacity.storage_dimension.identifier
dwh_capacity.storage_dimension.ip
dwh_capacity.storage_dimension.model
dwh_capacity.storage_dimension.manufacturer
dwh_capacity.storage_dimension.serialNumber
dwh_capacity.storage_dimension.microcodeVersion
dwh_capacity.storage_dimension.family
dwh_capacity.storage_dimension.url
dwh_capacity.storage_dimension.id
dwh_capacity.storage_dimension.latest
dwh_capacity.storage_dimension.dateTk
dwh_capacity.storage_dimension.dataCenter
dwh_capacity.storage_pool_dimension.tk
dwh_capacity.storage_pool_dimension.identifier
dwh_capacity.storage_pool_dimension.name
dwh_capacity.storage_pool_dimension.storageName
dwh_capacity.storage_pool_dimension.storageIP
dwh_capacity.storage_pool_dimension.type
dwh_capacity.storage_pool_dimension.redundancy
dwh_capacity.storage_pool_dimension.thinProvisioningSupported
dwh_capacity.storage_pool_dimension.isVirtual
dwh_capacity.storage_pool_dimension.usesFlashPools
dwh_capacity.storage_pool_dimension.url
dwh_capacity.storage_pool_dimension.id
dwh_capacity.storage_pool_dimension.latest
dwh_capacity.storage_pool_dimension.dateTk
dwh_capacity.tier_dimension.tk
dwh_capacity.tier_dimension.name
dwh_capacity.tier_dimension.sequence
dwh_capacity.tier_dimension.cost
dwh_capacity.tier_dimension.id
dwh_capacity.tier_dimension.latest
dwh_capacity.tier_dimension.dateTk
dwh_capacity.vm_capacity_fact.tk
dwh_capacity.vm_capacity_fact.dateTk
dwh_capacity.vm_capacity_fact.hostTk
dwh_capacity.vm_capacity_fact.storageTk
dwh_capacity.vm_capacity_fact.virtualStorageTk
dwh_capacity.vm_capacity_fact.internalVolumeTk
dwh_capacity.vm_capacity_fact.qtreeTk
dwh_capacity.vm_capacity_fact.hostGroupTk
dwh_capacity.vm_capacity_fact.applicationTk
dwh_capacity.vm_capacity_fact.applicationGroupTk
dwh_capacity.vm_capacity_fact.tierTk
dwh_capacity.vm_capacity_fact.serviceLevelTk
dwh_capacity.vm_capacity_fact.vmTk
dwh_capacity.vm_capacity_fact.dataStoreTk
dwh_capacity.vm_capacity_fact.dataStoreName
dwh_capacity.vm_capacity_fact.dataStoreId
dwh_capacity.vm_capacity_fact.virtualCenterIp
dwh_capacity.vm_capacity_fact.businessUnit
dwh_capacity.vm_capacity_fact.businessEntityTk
dwh_capacity.vm_capacity_fact.storageAccessType
dwh_capacity.vm_capacity_fact.capacityType
dwh_capacity.vm_capacity_fact.actualMB
dwh_capacity.vm_capacity_fact.provisionedMB
dwh_capacity.vm_dimension.tk
dwh_capacity.vm_dimension.name
dwh_capacity.vm_dimension.naturalKey
dwh_capacity.vm_dimension.os
dwh_capacity.vm_dimension.virtualCenterIp
dwh_capacity.vm_dimension.ips
dwh_capacity.vm_dimension.url
dwh_capacity.vm_dimension.id
dwh_capacity.vm_dimension.latest
dwh_capacity.vm_dimension.dateTk
dwh_capacity.volume_capacity_fact.volumeTk
dwh_capacity.volume_capacity_fact.chargebackFactTk
dwh_capacity.volume_capacity_fact.storageAndSpFactTk
dwh_capacity.volume_capacity_fact.hostTk
dwh_capacity.volume_capacity_fact.storageTk
dwh_capacity.volume_capacity_fact.hostGroupTk
dwh_capacity.volume_capacity_fact.tierTk
dwh_capacity.volume_capacity_fact.serviceLevelTk
dwh_capacity.volume_capacity_fact.storagePoolTk
dwh_capacity.volume_capacity_fact.internalVolumeTk
dwh_capacity.volume_capacity_fact.qtreeTk
dwh_capacity.volume_capacity_fact.isVirtual
dwh_capacity.volume_capacity_fact.isBackend
dwh_capacity.volume_capacity_fact.protectionType
dwh_capacity.volume_capacity_fact.isAccessed
dwh_capacity.volume_capacity_fact.isOrphaned
dwh_capacity.volume_capacity_fact.isProtection
dwh_capacity.volume_capacity_fact.isUnused
dwh_capacity.volume_capacity_fact.provisionedCapacityMB
dwh_capacity.volume_capacity_fact.accessedCapacityMB
dwh_capacity.volume_capacity_fact.orphanedCapacityMB
dwh_capacity.volume_capacity_fact.protectionCapacityMB
dwh_capacity.volume_capacity_fact.unusedCapacityMB
dwh_capacity.volume_capacity_fact.daysSinceLastAccessed
dwh_capacity.volume_dimension.tk
dwh_capacity.volume_dimension.storageIdentifier
dwh_capacity.volume_dimension.name
dwh_capacity.volume_dimension.label
dwh_capacity.volume_dimension.thinProvisioned
dwh_capacity.volume_dimension.type
dwh_capacity.volume_dimension.isVirtual
dwh_capacity.volume_dimension.meta
dwh_capacity.volume_dimension.snapshot
dwh_capacity.volume_dimension.technologyType
dwh_capacity.volume_dimension.uuid
dwh_capacity.volume_dimension.isMainframe
dwh_capacity.volume_dimension.url
dwh_capacity.volume_dimension.id
dwh_capacity.volume_dimension.latest
dwh_capacity.volume_dimension.dateTk
dwh_capacity.volume_fact_current.chargebackFactTk
dwh_capacity.volume_fact_current.volumeId
dwh_capacity.volume_fact_current.storageId
dwh_capacity.volume_fact_current.volumeName
dwh_capacity.volume_fact_current.volumeType
dwh_capacity.volume_fact_current.thinProvisioned
dwh_capacity.volume_fact_current.isVirtual
dwh_capacity.volume_fact_current.snapshot
dwh_capacity.volume_fact_current.technologyType
dwh_capacity.volume_fact_current.physicalUsableMB
dwh_capacity.volume_fact_current.physicalRawMB
dwh_capacity.volume_fact_current.provisionedUsableMB
dwh_capacity.volume_fact_current.provisionedRawMB
dwh_capacity.volume_history_capacity_fact.tk
dwh_capacity.volume_history_capacity_fact.dateTk
dwh_capacity.volume_history_capacity_fact.volumeTk
dwh_capacity.volume_history_capacity_fact.chargebackFactTk
dwh_capacity.volume_history_capacity_fact.storageAndSpFactTk
dwh_capacity.volume_history_capacity_fact.hostTk
dwh_capacity.volume_history_capacity_fact.storageTk
dwh_capacity.volume_history_capacity_fact.hostGroupTk
dwh_capacity.volume_history_capacity_fact.tierTk
dwh_capacity.volume_history_capacity_fact.serviceLevelTk
dwh_capacity.volume_history_capacity_fact.storagePoolTk
dwh_capacity.volume_history_capacity_fact.internalVolumeTk
dwh_capacity.volume_history_capacity_fact.qtreeTk
dwh_capacity.volume_history_capacity_fact.isVirtual
dwh_capacity.volume_history_capacity_fact.isBackend
dwh_capacity.volume_history_capacity_fact.protectionType
dwh_capacity.volume_history_capacity_fact.isAccessed
dwh_capacity.volume_history_capacity_fact.isOrphaned
dwh_capacity.volume_history_capacity_fact.isProtection
dwh_capacity.volume_history_capacity_fact.isUnused
dwh_capacity.volume_history_capacity_fact.isMasked
dwh_capacity.volume_history_capacity_fact.isMapped
dwh_capacity.volume_history_capacity_fact.provisionedCapacityMB
dwh_capacity.volume_history_capacity_fact.accessedCapacityMB
dwh_capacity.volume_history_capacity_fact.orphanedCapacityMB
dwh_capacity.volume_history_capacity_fact.protectionCapacityMB
dwh_capacity.volume_history_capacity_fact.unusedCapacityMB
dwh_capacity.volume_history_capacity_fact.consumedCapacityMB
dwh_capacity.volume_history_capacity_fact.daysSinceLastAccessed
Comments
Post a Comment