Schema Documentation

Source: dwh_inventory OData endpoint — Cloud Insights

Tables found: 106  |  Associations: 171

Table of Contents

Key Relationships Between Tables

acq_data_source

Referenced (parent) tableFK columnParent PK
acq_acquisition_unitacquisitionUnitIdid

auto_tiering_policy

Referenced (parent) tableFK columnParent PK
storagestorageIdid

auto_tiering_policy_constraint

Referenced (parent) tableFK columnParent PK
auto_tiering_policyautoTieringPolicyIdid
storagestorageIdid

backend_lun

Referenced (parent) tableFK columnParent PK
storagestorageIdid

backend_lun_to_volume

Referenced (parent) tableFK columnParent PK
backend_lunbackendLunIdid
storagefrontendStorageIdid
volumebackendVolumeIdid

backend_path

Referenced (parent) tableFK columnParent PK
backend_lunbackendLunIdid
storagestorageIdid

cluster_switch

Referenced (parent) tableFK columnParent PK
storagestorageIdid

cluster_switch_port

Referenced (parent) tableFK columnParent PK
cluster_switchclusterSwitchIdid
storagestorageIdid
storage_nodestorageNodeIdid

compute_resource

Referenced (parent) tableFK columnParent PK
hosthostIdid
hv_virtual_machinevmIdid

disk

Referenced (parent) tableFK columnParent PK
storagestorageIdid

disk_group

Referenced (parent) tableFK columnParent PK
storagestorageIdid

dr_internal_volume_replica

Referenced (parent) tableFK columnParent PK
internal_volumesourceInternalVolumeIdid
storagetargetStorageIdid

dr_qtree_replica

Referenced (parent) tableFK columnParent PK
qtreesourceQtreeIdid
storagetargetStorageIdid

dr_volume_replica

Referenced (parent) tableFK columnParent PK
storagetargetStorageIdid
volumesourceVolumeIdid

fc_name_server_entry

Referenced (parent) tableFK columnParent PK
switch_portconnectedSwitchPortIdid

file_system

Referenced (parent) tableFK columnParent PK
compute_resourcecomputeResourceIdid
hosthostIdid

file_system_to_virtual_disk

Referenced (parent) tableFK columnParent PK
compute_resourcecomputeResourceIdid
file_systemfileSystemIdid
hv_data_storedataStoreIdid
hv_virtual_diskvirtualDiskIdid

file_system_to_volume

Referenced (parent) tableFK columnParent PK
compute_resourcecomputeResourceIdid
file_systemfileSystemIdid
storagestorageIdid
volumevolumeIdid

generic_device_port

Referenced (parent) tableFK columnParent PK
generic_devicegenericDeviceIdid

host_adapter

Referenced (parent) tableFK columnParent PK
hosthostIdid

host_port

Referenced (parent) tableFK columnParent PK
hosthostIdid
host_adapteradapterIdid

host_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
hosthostIdid

hv_data_store_to_internal_volume

Referenced (parent) tableFK columnParent PK
hv_data_storedataStoreIdid
internal_volumeinternalVolumeIdid
qtreeqtreeIdid
storagestorageIdid

hv_data_store_to_volume

Referenced (parent) tableFK columnParent PK
hv_data_storedataStoreIdid
qtreeqtreeIdid
storagestorageIdid
volumevolumeIdid

hv_datastore_to_nas_share

Referenced (parent) tableFK columnParent PK
hv_data_storedataStoreIdid
hv_nas_sharenasShareIdid

hv_host_to_nas_share

Referenced (parent) tableFK columnParent PK
hosthostIdid
hv_nas_sharenasShareIdid

hv_lun

Referenced (parent) tableFK columnParent PK
hosthostIdid
hv_data_storedataStoreIdid

hv_lun_to_volume

Referenced (parent) tableFK columnParent PK
hosthostIdid
hv_lunhvLunIdid
storagestorageIdid
volumevolumeIdid

hv_nas_share

Referenced (parent) tableFK columnParent PK
hv_data_storedataStoreIdid

hv_nas_share_to_share

Referenced (parent) tableFK columnParent PK
hv_nas_sharenasShareIdid
nas_shareshareIdid
storagestorageIdid

hv_path

Referenced (parent) tableFK columnParent PK
hosthostIdid
hv_lunlunIdid

hv_server

Referenced (parent) tableFK columnParent PK
hosthostIdid

hv_virtual_disk

Referenced (parent) tableFK columnParent PK
hv_data_storedataStoreIdid
hv_lunlunIdid

hv_virtual_disk_to_volume

Referenced (parent) tableFK columnParent PK
hv_virtual_diskvirtualDiskIdid
qtreeqtreeIdid
storagestorageIdid
volumevolumeIdid

hv_virtual_machine

Referenced (parent) tableFK columnParent PK
hosthostIdid
hv_data_storedataStoreIdid

hv_virtual_machine_to_disk

Referenced (parent) tableFK columnParent PK
hv_virtual_diskvirtualDiskIdid
hv_virtual_machinevirtualMachineIdid

internal_volume

Referenced (parent) tableFK columnParent PK
storagestorageIdid
storage_poolstoragePoolIdid

internal_volume_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
internal_volumeinternalVolumeIdid

iscsi_logical

Referenced (parent) tableFK columnParent PK
hosthostIdid
storagestorageIdid
volumevolumeIdid

k8s_namespace

Referenced (parent) tableFK columnParent PK
k8s_clusterclusterIdid

k8s_node

Referenced (parent) tableFK columnParent PK
hv_virtual_machinevmIdid
k8s_clusterclusterIdid

k8s_pv

Referenced (parent) tableFK columnParent PK
k8s_clusterclusterIdid

k8s_pvc

Referenced (parent) tableFK columnParent PK
k8s_clusterclusterIdid
k8s_namespacenamespaceIdid
k8s_pvpvIdid

k8s_workload

Referenced (parent) tableFK columnParent PK
k8s_clusterclusterIdid
k8s_namespacenamespaceIdid

k8s_workload_to_pvc

Referenced (parent) tableFK columnParent PK
k8s_clusterclusterIdid
k8s_namespacenamespaceIdid
k8s_pvcpvcIdid
k8s_workloadworkloadIdid

logical

Referenced (parent) tableFK columnParent PK
generic_devicegenericDeviceIdid
hosthostIdid
storagestorageIdid
tapetapeIdid
volumevolumeIdid

nas_cr_logical

Referenced (parent) tableFK columnParent PK
compute_resourcecomputeResourceIdid
internal_volumeinternalVolumeIdid
nas_shareshareIdid
storagestorageIdid

nas_file_share

Referenced (parent) tableFK columnParent PK
internal_volumeinternalVolumeIdid
qtreeqtreeIdid
storagestorageIdid

nas_share

Referenced (parent) tableFK columnParent PK
nas_file_sharefileShareIdid
storagestorageIdid

nas_share_initiator

Referenced (parent) tableFK columnParent PK
nas_shareshareIdid
storagestorageIdid

object_to_annotation

Referenced (parent) tableFK columnParent PK
annotation_valueannotationValueIdid

physical_path

Referenced (parent) tableFK columnParent PK
generic_devicegenericDeviceIdid
hosthostIdid
storagestorageIdid
tapetapeIdid
volumevolumeIdid

qtree

Referenced (parent) tableFK columnParent PK
internal_volumeinternalVolumeIdid
storagestorageIdid

qtree_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
qtreeqtreeIdid

quota

Referenced (parent) tableFK columnParent PK
internal_volumeinternalVolumeIdid
qtreeqtreeIdid
storagestorageIdid

share_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
nas_shareshareIdid

storage_controller

Referenced (parent) tableFK columnParent PK
storagestorageIdid

storage_node

Referenced (parent) tableFK columnParent PK
storagestorageIdid

storage_pool

Referenced (parent) tableFK columnParent PK
storagestorageIdid

storage_port

Referenced (parent) tableFK columnParent PK
storagestorageIdid
storage_controllercontrollerIdid

storage_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
storagestorageIdid

switch

Referenced (parent) tableFK columnParent PK
fabricfabricIdid

switch_port

Referenced (parent) tableFK columnParent PK
fabricfabricIdid
switchswitchIdid
virtual_switchvirtualSwitchIdid

switch_port_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
switch_portportIdid

switch_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
switchswitchIdid

tape_controller

Referenced (parent) tableFK columnParent PK
tapetapeIdid

tape_port

Referenced (parent) tableFK columnParent PK
tapetapeIdid
tape_controllercontrollerIdid

unknown_logical

Referenced (parent) tableFK columnParent PK
hosthostIdid
storagestorageIdid
volumevolumeIdid

violation

Referenced (parent) tableFK columnParent PK
generic_devicegenericDeviceIdid
hosthostIdid
storagestorageIdid
tapetapeIdid
volumevolumeIdid

virtual_switch

Referenced (parent) tableFK columnParent PK
fabricfabricIdid

vm_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
hv_virtual_machinevmIdid

vmware_host

Referenced (parent) tableFK columnParent PK
hv_serverhvServerIdid

volume

Referenced (parent) tableFK columnParent PK
auto_tiering_policyautoTieringPolicyIdid
internal_volumeinternalVolumeIdid
qtreeqtreeIdid
storagestorageIdid

volume_map

Referenced (parent) tableFK columnParent PK
storagestorageIdid
volumevolumeIdid

volume_mask

Referenced (parent) tableFK columnParent PK
hosthostIdid
storagestorageIdid
volumevolumeIdid

volume_to_application

Referenced (parent) tableFK columnParent PK
applicationapplicationIdid
volumevolumeIdid

zone

Referenced (parent) tableFK columnParent PK
fabricfabricIdid

zone_member

Referenced (parent) tableFK columnParent PK
fabricfabricIdid
zonezoneIdid

Tables & Fields

PK Primary Key  FK Foreign Key  NOT NULL Required field

acq_acquisition_unit↑ top

Entity Set(s): acq_acquisition_unit

FieldTypeNullable
idPKInt32Yes
identifierStringYes
nameStringYes
ipStringYes
siteNameStringYes
leasePeriodInt64Yes
nextLeaseRenewalDateTimeOffsetYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
acq_data_sourceacq_data_sourcemany

acq_data_source↑ top

Entity Set(s): acq_data_source

FieldTypeNullable
idPKInt32Yes
acquisitionUnitIdFK
acq_acquisition_unit.id
Int32Yes
nameStringYes
typeStringYes
vendorStringYes
modelStringYes
auditLastStatusStringYes
auditStatusDateDateTimeOffsetYes
auditStatusSinceDateTimeOffsetYes
auditStatusCountInt32Yes
auditLastStatusMessageStringYes
additionalDataSourceMessageStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
acq_acquisition_unitacq_acquisition_unitone
JOIN: acquisitionUnitId = acq_acquisition_unit.id

annotation_value↑ top

Entity Set(s): annotation_value

FieldTypeNullable
idPKInt32Yes
annotationTypeStringYes
valueIdentifierStringYes
valueTypeStringYes
valueDateDateTimeOffsetYes
enumSequenceInt32Yes
enumCostDoubleYes
ukHashStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
object_to_annotationobject_to_annotationmany

application↑ top

Entity Set(s): application

FieldTypeNullable
idPKInt32Yes
nameStringYes
descriptionStringYes
ignoreSharingByteYes
priorityStringYes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_port_to_applicationswitch_port_to_applicationmany
internal_volume_to_applicationinternal_volume_to_applicationmany
share_to_applicationshare_to_applicationmany
storage_to_applicationstorage_to_applicationmany
vm_to_applicationvm_to_applicationmany
volume_to_applicationvolume_to_applicationmany
qtree_to_applicationqtree_to_applicationmany
switch_to_applicationswitch_to_applicationmany
host_to_applicationhost_to_applicationmany

auto_tiering_policy↑ top

Entity Set(s): auto_tiering_policy

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
identifierStringYes
nameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumemany
auto_tiering_policy_constraintauto_tiering_policy_constraintmany

auto_tiering_policy_constraint↑ top

Entity Set(s): auto_tiering_policy_constraint

FieldTypeNullable
idPKInt32Yes
autoTieringPolicyIdFK
auto_tiering_policy.id
Int32Yes
storageIdFK
storage.id
Int32Yes
vendorTierStringYes
limitPercentInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
auto_tiering_policyauto_tiering_policyone
JOIN: autoTieringPolicyId = auto_tiering_policy.id

backend_lun↑ top

Entity Set(s): backend_lun

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
nameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
backend_pathbackend_pathmany
backend_lun_to_volumebackend_lun_to_volumemany

backend_lun_to_volume↑ top

Entity Set(s): backend_lun_to_volume

FieldTypeNullable
idPKInt32Yes
frontendStorageIdFK
storage.id
Int32Yes
backendLunIdFK
backend_lun.id
Int32Yes
backendStorageIdInt32Yes
backendVolumeIdFK
volume.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
backend_lunbackend_lunone
JOIN: backendLunId = backend_lun.id
storagestorageone
JOIN: frontendStorageId = storage.id
volumevolumeone
JOIN: backendVolumeId = volume.id

backend_path↑ top

Entity Set(s): backend_path

FieldTypeNullable
idPKInt32Yes
backendLunIdFK
backend_lun.id
Int32Yes
storageIdFK
storage.id
Int32Yes
lunStringYes
initiatorPortWwnStringYes
targetPortWwnStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
backend_lunbackend_lunone
JOIN: backendLunId = backend_lun.id

business_entity↑ top

Entity Set(s): business_entity

FieldTypeNullable
idInt32Yes
fullnameStringYes
tenantStringYes
lobStringYes
businessUnitStringYes
projectStringYes

cluster_switch↑ top

Entity Set(s): cluster_switch

FieldTypeNullable
idPKInt32Yes
identifierStringYes
storageIdFK
storage.id
Int32Yes
nameStringYes
addressStringYes
serialNumberStringYes
networkStringYes
versionStringYes
modelStringYes
monitoredStringYes
monitoringEnabledStringYes
monitoringReasonStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
cluster_switch_portcluster_switch_portmany

cluster_switch_port↑ top

Entity Set(s): cluster_switch_port

FieldTypeNullable
idPKInt32Yes
identifierStringYes
clusterSwitchIdFK
cluster_switch.id
Int32Yes
storageIdFK
storage.id
Int32Yes
storageNodeIdFK
storage_node.id
Int32Yes
nameStringYes
duplexTypeStringYes
storageNodePortNameStringYes
storageNodePortMtuStringYes
portIndexStringYes
islStringYes
macAddressStringYes
mtuStringYes
numberStringYes
typeStringYes
speedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
cluster_switchcluster_switchone
JOIN: clusterSwitchId = cluster_switch.id
storage_nodestorage_nodeone
JOIN: storageNodeId = storage_node.id

compute_resource↑ top

Entity Set(s): compute_resource

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
vmIdFK
hv_virtual_machine.id
Int32Yes
identifierStringYes
nameStringYes
typeStringYes
domainStringYes
ipStringYes
osStringYes
cpuCountInt32Yes
memoryInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_virtual_machinehv_virtual_machineone
JOIN: vmId = hv_virtual_machine.id
hosthostone
JOIN: hostId = host.id
file_systemfile_systemmany
nas_cr_logicalnas_cr_logicalmany
file_system_to_virtual_diskfile_system_to_virtual_diskmany
file_system_to_volumefile_system_to_volumemany

disk↑ top

Entity Set(s): disk

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
identifierStringYes
nameStringYes
speedInt32Yes
capacityGBInt64Yes
locationStringYes
roleStringYes
vendorStringYes
modelStringYes
typeStringYes
diskGroupStringYes
statusStringYes
serialNumberStringYes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id

disk_group↑ top

Entity Set(s): disk_group

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
nameStringYes
identifierStringYes
vendorDiskGroupTypeStringYes
diskTypeStringYes
statusStringYes
redundancyStringYes
isVirtualStringYes
vendorTierStringYes
capacityMBInt64Yes
usedCapacityMBInt64Yes
physicalDiskCapacityMBInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id

disk_group_to_disk↑ top

Entity Set(s): disk_group_to_disk

FieldTypeNullable
storageIdInt32Yes
diskGroupIdInt32Yes
diskIdInt32Yes

disk_group_to_storage_pool↑ top

Entity Set(s): disk_group_to_storage_pool

FieldTypeNullable
storageIdInt32Yes
diskGroupIdInt32Yes
storagePoolIdInt32Yes

dr_internal_volume_replica↑ top

Entity Set(s): dr_internal_volume_replica

FieldTypeNullable
sourceStorageIdInt32Yes
sourceInternalVolumeIdFK
internal_volume.id
Int32Yes
targetStorageIdFK
storage.id
Int32Yes
targetInternalVolumeIdPKInt32Yes
modeStringYes
technologyStringYes
dwhCalculatedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
internal_volumeinternal_volumeone
JOIN: sourceInternalVolumeId = internal_volume.id
storagestorageone
JOIN: targetStorageId = storage.id

dr_qtree_replica↑ top

Entity Set(s): dr_qtree_replica

FieldTypeNullable
sourceStorageIdInt32Yes
sourceQtreeIdFK
qtree.id
Int32Yes
targetStorageIdFK
storage.id
Int32Yes
targetQtreeIdPKInt32Yes
modeStringYes
technologyStringYes
dwhCalculatedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtreeqtreeone
JOIN: sourceQtreeId = qtree.id
storagestorageone
JOIN: targetStorageId = storage.id

dr_replica↑ top

Entity Set(s): dr_replica

FieldTypeNullable
sourceStorageIdInt32Yes
sourceVolumeIdInt32Yes
targetStorageIdInt32Yes
targetVolumeIdInt32Yes
fabricsInt32Yes
spfByteYes
sourcePortsInt32Yes
targetPortsInt32Yes
hopsCountInt32Yes
synchStringYes

dr_volume_replica↑ top

Entity Set(s): dr_volume_replica

FieldTypeNullable
sourceStorageIdInt32Yes
sourceVolumeIdPKInt32Yes
targetStorageIdFK
storage.id
Int32Yes
targetVolumeIdPKInt32Yes
sourceVolumeGroupIdStringYes
sourceVolumeGroupNameStringYes
targetVolumeGroupIdStringYes
targetVolumeGroupNameStringYes
fabricsInt32Yes
spfByteYes
sourcePortsInt32Yes
targetPortsInt32Yes
hopsCountInt32Yes
modeStringYes
modeRawStringYes
technologyStringYes
stateStringYes
stateRawStringYes
stateStartTimeDateTimeOffsetYes
stateSampleTimeDateTimeOffsetYes
stateStartTimeCalculatedStringYes
dwhCalculatedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
volumevolumeone
JOIN: sourceVolumeId = volume.id
storagestorageone
JOIN: targetStorageId = storage.id

extended_data↑ top

Entity Set(s): extended_data

FieldTypeNullable
objectIdPKInt32Yes
objectTypePKStringYes
fieldNamePKStringYes
fieldValueStringYes

fabric↑ top

Entity Set(s): fabric

FieldTypeNullable
idPKInt32Yes
identifierStringYes
wwnStringYes
nameStringYes
vsanEnabledStringYes
vsanIdStringYes
zoningEnabledStringYes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_portswitch_portmany
zonezonemany
virtual_switchvirtual_switchmany
zone_memberzone_membermany
switchswitchmany

fc_name_server_entry↑ top

Entity Set(s): fc_name_server_entry

FieldTypeNullable
idPKInt32Yes
portIdInt32Yes
typeStringYes
wwnStringYes
connectedSwitchPortIdFK
switch_port.id
Int32Yes
connectedSwitchPortWwnStringYes
physicalPortWwnStringYes
fcIdStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_portswitch_portone
JOIN: connectedSwitchPortId = switch_port.id

file_system↑ top

Entity Set(s): file_system

FieldTypeNullable
idPKInt32Yes
computeResourceIdFK
compute_resource.id
Int32Yes
hostIdFK
host.id
Int32Yes
nameStringYes
locationStringYes
hardwareIdStringYes
typeStringYes
lastAgentReportTimeDateTimeOffsetYes
sizeMBInt64Yes
usedMBInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
compute_resourcecompute_resourceone
JOIN: computeResourceId = compute_resource.id
hosthostone
JOIN: hostId = host.id
file_system_to_virtual_diskfile_system_to_virtual_diskmany
file_system_to_volumefile_system_to_volumemany

file_system_to_virtual_disk↑ top

Entity Set(s): file_system_to_virtual_disk

FieldTypeNullable
idPKInt32Yes
virtualDiskIdFK
hv_virtual_disk.id
Int32Yes
fileSystemIdFK
file_system.id
Int32Yes
computeResourceIdFK
compute_resource.id
Int32Yes
dataStoreIdFK
hv_data_store.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
compute_resourcecompute_resourceone
JOIN: computeResourceId = compute_resource.id
file_systemfile_systemone
JOIN: fileSystemId = file_system.id
hv_virtual_diskhv_virtual_diskone
JOIN: virtualDiskId = hv_virtual_disk.id

file_system_to_volume↑ top

Entity Set(s): file_system_to_volume

FieldTypeNullable
idPKInt32Yes
computeResourceIdFK
compute_resource.id
Int32Yes
fileSystemIdFK
file_system.id
Int32Yes
storageIdFK
storage.id
Int32Yes
volumeIdFK
volume.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
compute_resourcecompute_resourceone
JOIN: computeResourceId = compute_resource.id
volumevolumeone
JOIN: volumeId = volume.id
file_systemfile_systemone
JOIN: fileSystemId = file_system.id

generic_device↑ top

Entity Set(s): generic_device

FieldTypeNullable
idPKInt32Yes
wwnStringYes
identifierStringYes
manufacturerStringYes
modelStringYes
firmwareStringYes
driverStringYes
serialNumberStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
generic_device_portgeneric_device_portmany
violationviolationmany
physical_pathphysical_pathmany
logicallogicalmany

generic_device_port↑ top

Entity Set(s): generic_device_port

FieldTypeNullable
idPKInt32Yes
genericDeviceIdFK
generic_device.id
Int32Yes
wwnStringYes
numberInt64Yes
portIdStringYes
nameStringYes
speedStringYes
urlStringYes
activeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
generic_devicegeneric_deviceone
JOIN: genericDeviceId = generic_device.id

host↑ top

Entity Set(s): host

FieldTypeNullable
idPKInt32Yes
nameStringYes
identifierStringYes
ipStringYes
osStringYes
modelStringYes
manufacturerStringYes
installedMemoryMBStringYes
hostFsFreeGBStringYes
hostFsTotalGBStringYes
hostFsUsedGBStringYes
cpuCountStringYes
cpuSpeedStringYes
nicCountStringYes
nicSpeedStringYes
urlStringYes
activeStringYes
dataCenterStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
host_porthost_portmany
hv_pathhv_pathmany
volume_maskvolume_maskmany
host_adapterhost_adaptermany
unknown_logicalunknown_logicalmany
logicallogicalmany
host_to_applicationhost_to_applicationmany
hv_host_to_nas_sharehv_host_to_nas_sharemany
file_systemfile_systemmany
hv_lunhv_lunmany
violationviolationmany
iscsi_logicaliscsi_logicalmany
hv_lun_to_volumehv_lun_to_volumemany
physical_pathphysical_pathmany
hv_serverhv_servermany
compute_resourcecompute_resourcemany
hv_virtual_machinehv_virtual_machinemany

host_adapter↑ top

Entity Set(s): host_adapter

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
wwnStringYes
modelStringYes
manufacturerStringYes
driverStringYes
firmwareStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hosthostone
JOIN: hostId = host.id
host_porthost_portmany

host_port↑ top

Entity Set(s): host_port

FieldTypeNullable
idPKInt32Yes
adapterIdFK
host_adapter.id
Int32Yes
hostIdFK
host.id
Int32Yes
wwnStringYes
nodeWwnStringYes
portIdStringYes
nameStringYes
speedStringYes
urlStringYes
activeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
host_adapterhost_adapterone
JOIN: adapterId = host_adapter.id
hosthostone
JOIN: hostId = host.id

host_to_application↑ top

Entity Set(s): host_to_application

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
applicationIdFK
application.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
applicationapplicationone
JOIN: applicationId = application.id
hosthostone
JOIN: hostId = host.id

hv_data_store↑ top

Entity Set(s): hv_data_store

FieldTypeNullable
idPKInt32Yes
naturalKeyStringYes
moidStringYes
nameStringYes
capacityMBInt64Yes
provisionedCapacityMBInt64Yes
virtualCenterIpStringYes
freeCapacityMBInt64Yes
usedCapacityMBInt64Yes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_nas_sharehv_nas_sharemany
hv_data_store_to_internal_volumehv_data_store_to_internal_volumemany
hv_lunhv_lunmany
hv_datastore_to_nas_sharehv_datastore_to_nas_sharemany
hv_virtual_diskhv_virtual_diskmany
file_system_to_virtual_diskfile_system_to_virtual_diskmany
hv_data_store_to_volumehv_data_store_to_volumemany
hv_virtual_machinehv_virtual_machinemany

hv_data_store_to_internal_volume↑ top

Entity Set(s): hv_data_store_to_internal_volume

FieldTypeNullable
dataStoreIdPKInt32Yes
storageIdFK
storage.id
Int32Yes
internalVolumeIdPKInt32Yes
qtreeIdFK
qtree.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
storagestorageone
JOIN: storageId = storage.id
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
qtreeqtreeone
JOIN: qtreeId = qtree.id

hv_data_store_to_volume↑ top

Entity Set(s): hv_data_store_to_volume

FieldTypeNullable
dataStoreIdPKInt32Yes
storageIdFK
storage.id
Int32Yes
qtreeIdFK
qtree.id
Int32Yes
volumeIdPKInt32Yes
repVolumeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
qtreeqtreeone
JOIN: qtreeId = qtree.id

hv_datastore_to_nas_share↑ top

Entity Set(s): hv_datastore_to_nas_share

FieldTypeNullable
idPKInt32Yes
dataStoreIdFK
hv_data_store.id
Int32Yes
nasShareIdFK
hv_nas_share.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
hv_nas_sharehv_nas_shareone
JOIN: nasShareId = hv_nas_share.id

hv_host_to_nas_share↑ top

Entity Set(s): hv_host_to_nas_share

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
nasShareIdFK
hv_nas_share.id
Int32Yes
readOnlyByteYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_nas_sharehv_nas_shareone
JOIN: nasShareId = hv_nas_share.id
hosthostone
JOIN: hostId = host.id

hv_lun↑ top

Entity Set(s): hv_lun

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
dataStoreIdFK
hv_data_store.id
Int32Yes
naturalKeyStringYes
numberStringYes
tidInt64Yes
policyStringYes
diskNameStringYes
volumeUuidStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
hosthostone
JOIN: hostId = host.id
hv_pathhv_pathmany
hv_lun_to_volumehv_lun_to_volumemany
hv_virtual_diskhv_virtual_diskmany

hv_lun_to_volume↑ top

Entity Set(s): hv_lun_to_volume

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
hvLunIdFK
hv_lun.id
Int32Yes
storageIdFK
storage.id
Int32Yes
volumeIdFK
volume.id
Int32Yes
typeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
hv_lunhv_lunone
JOIN: hvLunId = hv_lun.id
hosthostone
JOIN: hostId = host.id

hv_nas_share↑ top

Entity Set(s): hv_nas_share

FieldTypeNullable
idPKInt32Yes
dataStoreIdFK
hv_data_store.id
Int32Yes
naturalKeyStringYes
filerNameStringYes
filerIpStringYes
sharePathStringYes
capacityMBInt32Yes
typeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
hv_datastore_to_nas_sharehv_datastore_to_nas_sharemany
hv_nas_share_to_sharehv_nas_share_to_sharemany
hv_host_to_nas_sharehv_host_to_nas_sharemany

hv_nas_share_to_share↑ top

Entity Set(s): hv_nas_share_to_share

FieldTypeNullable
idPKInt32Yes
nasShareIdFK
hv_nas_share.id
Int32Yes
storageIdFK
storage.id
Int32Yes
shareIdFK
nas_share.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
hv_nas_sharehv_nas_shareone
JOIN: nasShareId = hv_nas_share.id
nas_sharenas_shareone
JOIN: shareId = nas_share.id

hv_path↑ top

Entity Set(s): hv_path

FieldTypeNullable
idPKInt32Yes
lunIdFK
hv_lun.id
Int32Yes
hostIdFK
host.id
Int32Yes
hostPortWwpnStringYes
storagePortWwpnStringYes
typeStringYes
activeByteYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_lunhv_lunone
JOIN: lunId = hv_lun.id
hosthostone
JOIN: hostId = host.id

hv_server↑ top

Entity Set(s): hv_server

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
naturalKeyStringYes
moidStringYes
virtualCenterIpStringYes
clusterNameStringYes
dataCenterNameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hosthostone
JOIN: hostId = host.id
vmware_hostvmware_hostmany

hv_virtual_disk↑ top

Entity Set(s): hv_virtual_disk

FieldTypeNullable
idPKInt32Yes
dataStoreIdFK
hv_data_store.id
Int32Yes
lunIdFK
hv_lun.id
Int32Yes
naturalKeyStringYes
nameStringYes
typeStringYes
capacityMBInt64Yes
usedCapacityMBInt64Yes
usedCapacityForReportingMBInt64Yes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
hv_lunhv_lunone
JOIN: lunId = hv_lun.id
hv_virtual_disk_to_volumehv_virtual_disk_to_volumemany
hv_virtual_machine_to_diskhv_virtual_machine_to_diskmany
file_system_to_virtual_diskfile_system_to_virtual_diskmany

hv_virtual_disk_to_volume↑ top

Entity Set(s): hv_virtual_disk_to_volume

FieldTypeNullable
virtualDiskIdPKInt32Yes
storageIdFK
storage.id
Int32Yes
qtreeIdFK
qtree.id
Int32Yes
volumeIdFK
volume.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
qtreeqtreeone
JOIN: qtreeId = qtree.id
hv_virtual_diskhv_virtual_diskone
JOIN: virtualDiskId = hv_virtual_disk.id

hv_virtual_machine↑ top

Entity Set(s): hv_virtual_machine

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
moidStringYes
nameStringYes
dnsNameStringYes
ipsStringYes
powerStateStringYes
powerStateChangeTimeDateTimeOffsetYes
guestStateStringYes
osStringYes
processorsInt32Yes
memoryInt64Yes
dataStoreIdFK
hv_data_store.id
Int32Yes
naturalKeyStringYes
virtualCenterIpStringYes
provisionedCapacityMBInt64Yes
usedCapacityMBInt64Yes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_data_storehv_data_storeone
JOIN: dataStoreId = hv_data_store.id
hosthostone
JOIN: hostId = host.id
vm_to_applicationvm_to_applicationmany
hv_virtual_machine_to_diskhv_virtual_machine_to_diskmany
k8s_nodek8s_nodemany
compute_resourcecompute_resourcemany

hv_virtual_machine_to_disk↑ top

Entity Set(s): hv_virtual_machine_to_disk

FieldTypeNullable
idPKInt32Yes
virtualMachineIdFK
hv_virtual_machine.id
Int32Yes
virtualDiskIdFK
hv_virtual_disk.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_virtual_machinehv_virtual_machineone
JOIN: virtualMachineId = hv_virtual_machine.id
hv_virtual_diskhv_virtual_diskone
JOIN: virtualDiskId = hv_virtual_disk.id

internal_volume↑ top

Entity Set(s): internal_volume

FieldTypeNullable
idPKInt32Yes
storagePoolIdFK
storage_pool.id
Int32Yes
storageIdFK
storage.id
Int32Yes
identifierStringYes
nameStringYes
typeStringYes
thinProvisioningSupportedStringYes
thinProvisionedStringYes
spaceGuaranteeStringYes
dedupeEnabledStringYes
cloneSourceIdInt32Yes
snapshotCountInt32Yes
lastSnapshotTimeDateTimeOffsetYes
lastKnownAccessTimeDateTimeOffsetYes
statusStringYes
virtualStorageStringYes
protectionTypeStringYes
flashPoolEligibilityStringYes
dedupeRatioDoubleYes
dedupeSavingsGBInt64Yes
totalAllocatedCapacityMBInt64Yes
totalUsedCapacityMBInt64Yes
totalUsedCapacityFromDeviceMBInt64Yes
dataAllocatedCapacityMBInt64Yes
dataUsedCapacityMBInt64Yes
snapshotAllocatedCapacityMBInt64Yes
snapshotUsedCapacityMBInt64Yes
rawToUsableRatioDoubleYes
otherUsedCapacityMBInt64Yes
otherAllocatedCapacityMBInt64Yes
totalCloneSavedCapacityMBInt64Yes
compressionEnabledStringYes
compressionRatioDoubleYes
compressionSavingsGBInt64Yes
compressionSavingsPercentDoubleYes
uuidStringYes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
storage_poolstorage_poolone
JOIN: storagePoolId = storage_pool.id
volumevolumemany
qtreeqtreemany
dr_internal_volume_replicadr_internal_volume_replicamany
internal_volume_to_applicationinternal_volume_to_applicationmany
nas_file_sharenas_file_sharemany
hv_data_store_to_internal_volumehv_data_store_to_internal_volumemany
quotaquotamany
nas_cr_logicalnas_cr_logicalmany

internal_volume_to_application↑ top

Entity Set(s): internal_volume_to_application

FieldTypeNullable
idPKInt32Yes
applicationIdFK
application.id
Int32Yes
internalVolumeIdFK
internal_volume.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
applicationapplicationone
JOIN: applicationId = application.id

iscsi_logical↑ top

Entity Set(s): iscsi_logical

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
storageIdFK
storage.id
Int32Yes
volumeIdFK
volume.id
Int32Yes
numberOfSessionsInt32Yes
numberOfConnectionsInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
hosthostone
JOIN: hostId = host.id

k8s_cluster↑ top

Entity Set(s): k8s_cluster

FieldTypeNullable
idPKInt32Yes
nameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
k8s_namespacek8s_namespacemany
k8s_workloadk8s_workloadmany
k8s_workload_to_pvck8s_workload_to_pvcmany
k8s_nodek8s_nodemany
k8s_pvk8s_pvmany
k8s_pvck8s_pvcmany

k8s_label↑ top

Entity Set(s): k8s_label

FieldTypeNullable
objectIdPKInt32Yes
objectTypePKStringYes
labelNamePKStringYes
labelValueStringYes

k8s_namespace↑ top

Entity Set(s): k8s_namespace

FieldTypeNullable
idPKInt32Yes
identifierStringYes
clusterIdFK
k8s_cluster.id
Int32Yes
nameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
k8s_clusterk8s_clusterone
JOIN: clusterId = k8s_cluster.id
k8s_workloadk8s_workloadmany
k8s_workload_to_pvck8s_workload_to_pvcmany
k8s_pvck8s_pvcmany

k8s_node↑ top

Entity Set(s): k8s_node

FieldTypeNullable
idPKInt32Yes
identifierStringYes
clusterIdFK
k8s_cluster.id
Int32Yes
nameStringYes
vmIdFK
hv_virtual_machine.id
Int32Yes
internalIpStringYes
osImageStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_virtual_machinehv_virtual_machineone
JOIN: vmId = hv_virtual_machine.id
k8s_clusterk8s_clusterone
JOIN: clusterId = k8s_cluster.id

k8s_pv↑ top

Entity Set(s): k8s_pv

FieldTypeNullable
idPKInt32Yes
identifierStringYes
nameStringYes
objectIdInt32Yes
objectTypeStringYes
clusterIdFK
k8s_cluster.id
Int32Yes
phaseStringYes
sizeBytesInt64Yes
storageClassStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
k8s_clusterk8s_clusterone
JOIN: clusterId = k8s_cluster.id
k8s_pvck8s_pvcmany

k8s_pvc↑ top

Entity Set(s): k8s_pvc

FieldTypeNullable
idPKInt32Yes
identifierStringYes
nameStringYes
pvIdFK
k8s_pv.id
Int32Yes
clusterIdFK
k8s_cluster.id
Int32Yes
namespaceIdFK
k8s_namespace.id
Int32Yes
phaseStringYes
sizeBytesInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
k8s_pvk8s_pvone
JOIN: pvId = k8s_pv.id
k8s_namespacek8s_namespaceone
JOIN: namespaceId = k8s_namespace.id
k8s_clusterk8s_clusterone
JOIN: clusterId = k8s_cluster.id
k8s_workload_to_pvck8s_workload_to_pvcmany

k8s_workload↑ top

Entity Set(s): k8s_workload

FieldTypeNullable
idPKInt32Yes
identifierStringYes
nameStringYes
namespaceIdFK
k8s_namespace.id
Int32Yes
clusterIdFK
k8s_cluster.id
Int32Yes
typeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
k8s_namespacek8s_namespaceone
JOIN: namespaceId = k8s_namespace.id
k8s_clusterk8s_clusterone
JOIN: clusterId = k8s_cluster.id
k8s_workload_to_pvck8s_workload_to_pvcmany

k8s_workload_to_pvc↑ top

Entity Set(s): k8s_workload_to_pvc

FieldTypeNullable
workloadIdPKInt32Yes
pvcIdPKInt32Yes
clusterIdFK
k8s_cluster.id
Int32Yes
namespaceIdFK
k8s_namespace.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
k8s_workloadk8s_workloadone
JOIN: workloadId = k8s_workload.id
k8s_pvck8s_pvcone
JOIN: pvcId = k8s_pvc.id
k8s_namespacek8s_namespaceone
JOIN: namespaceId = k8s_namespace.id
k8s_clusterk8s_clusterone
JOIN: clusterId = k8s_cluster.id

logical↑ top

Entity Set(s): logical

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
genericDeviceIdFK
generic_device.id
Int32Yes
storageIdFK
storage.id
Int32Yes
tapeIdFK
tape.id
Int32Yes
volumeIdFK
volume.id
Int32Yes
minHopNumberInt32Yes
hopsToDisplayStringYes
numberOfFabricsInt32Yes
numberOfHostPortsInt32Yes
numberOfStoragePortsInt32Yes
spfByteYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
tapetapeone
JOIN: tapeId = tape.id
hosthostone
JOIN: hostId = host.id
generic_devicegeneric_deviceone
JOIN: genericDeviceId = generic_device.id

nas_cr_logical↑ top

Entity Set(s): nas_cr_logical

FieldTypeNullable
idPKInt32Yes
computeResourceIdFK
compute_resource.id
Int32Yes
storageIdFK
storage.id
Int32Yes
internalVolumeIdFK
internal_volume.id
Int32Yes
shareIdFK
nas_share.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
compute_resourcecompute_resourceone
JOIN: computeResourceId = compute_resource.id
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
nas_sharenas_shareone
JOIN: shareId = nas_share.id

nas_file_share↑ top

Entity Set(s): nas_file_share

FieldTypeNullable
idPKInt32Yes
internalVolumeIdFK
internal_volume.id
Int32Yes
storageIdFK
storage.id
Int32Yes
qtreeIdFK
qtree.id
Int32Yes
nameStringYes
pathStringYes
statusStringYes
securityTypeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
qtreeqtreeone
JOIN: qtreeId = qtree.id
nas_sharenas_sharemany

nas_logical↑ top

Entity Set(s): nas_logical

FieldTypeNullable
idInt32Yes
hostIdInt32Yes
storageIdInt32Yes
shareIdInt32Yes

nas_share↑ top

Entity Set(s): nas_share

FieldTypeNullable
idPKInt32Yes
fileShareIdFK
nas_file_share.id
Int32Yes
storageIdFK
storage.id
Int32Yes
identifierStringYes
nameStringYes
protocolStringYes
ipInterfacesStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
nas_file_sharenas_file_shareone
JOIN: fileShareId = nas_file_share.id
share_to_applicationshare_to_applicationmany
nas_share_initiatornas_share_initiatormany
hv_nas_share_to_sharehv_nas_share_to_sharemany
nas_cr_logicalnas_cr_logicalmany

nas_share_initiator↑ top

Entity Set(s): nas_share_initiator

FieldTypeNullable
idPKInt32Yes
shareIdFK
nas_share.id
Int32Yes
storageIdFK
storage.id
Int32Yes
initiatorStringYes
permissionStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
nas_sharenas_shareone
JOIN: shareId = nas_share.id

object_to_annotation↑ top

Entity Set(s): object_to_annotation

FieldTypeNullable
annotationValueIdPKInt32Yes
objectIdPKInt32Yes
objectTypePKStringYes
annotationTypeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
annotation_valueannotation_valueone
JOIN: annotationValueId = annotation_value.id

physical_path↑ top

Entity Set(s): physical_path

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
genericDeviceIdFK
generic_device.id
Int32Yes
storageIdFK
storage.id
Int32Yes
tapeIdFK
tape.id
Int32Yes
volumeIdFK
volume.id
Int32Yes
hostPortWwnStringYes
storagePortWwnStringYes
lunStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
tapetapeone
JOIN: tapeId = tape.id
hosthostone
JOIN: hostId = host.id
generic_devicegeneric_deviceone
JOIN: genericDeviceId = generic_device.id

port_connectivity↑ top

Entity Set(s): port_connectivity

FieldTypeNullable
idPKInt32Yes
portIdInt32Yes
typeStringYes
wwnStringYes
connectedIdInt32Yes
connectedTypeStringYes
connectedWwnStringYes

qtree↑ top

Entity Set(s): qtree

FieldTypeNullable
idPKInt32Yes
internalVolumeIdFK
internal_volume.id
Int32Yes
storageIdFK
storage.id
Int32Yes
identifierStringYes
nameStringYes
quotaHardCapacityLimitMBInt64Yes
quotaSoftCapacityLimitMBInt64Yes
quotaUsedCapacityMBInt64Yes
typeStringYes
securityStyleStringYes
statusStringYes
oplocksStringYes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
volumevolumemany
nas_file_sharenas_file_sharemany
hv_data_store_to_internal_volumehv_data_store_to_internal_volumemany
dr_qtree_replicadr_qtree_replicamany
quotaquotamany
hv_virtual_disk_to_volumehv_virtual_disk_to_volumemany
qtree_to_applicationqtree_to_applicationmany
hv_data_store_to_volumehv_data_store_to_volumemany

qtree_to_application↑ top

Entity Set(s): qtree_to_application

FieldTypeNullable
idPKInt32Yes
applicationIdFK
application.id
Int32Yes
qtreeIdFK
qtree.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
applicationapplicationone
JOIN: applicationId = application.id
qtreeqtreeone
JOIN: qtreeId = qtree.id

quota↑ top

Entity Set(s): quota

FieldTypeNullable
idPKInt32Yes
internalVolumeIdFK
internal_volume.id
Int32Yes
storageIdFK
storage.id
Int32Yes
qtreeIdFK
qtree.id
Int32Yes
identifierStringYes
targetUserStringYes
typeStringYes
hardFileLimitInt64Yes
softFileLimitInt64Yes
hardCapacityLimitMBInt64Yes
softCapacityLimitMBInt64Yes
thresholdMBInt64Yes
usedFilesInt64Yes
usedCapacityMBInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
qtreeqtreeone
JOIN: qtreeId = qtree.id

service_level↑ top

Entity Set(s): service_level

FieldTypeNullable
idInt32Yes
nameStringYes
sequenceInt32Yes
costDoubleYes

share_to_application↑ top

Entity Set(s): share_to_application

FieldTypeNullable
idPKInt32Yes
applicationIdFK
application.id
Int32Yes
shareIdFK
nas_share.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
applicationapplicationone
JOIN: applicationId = application.id
nas_sharenas_shareone
JOIN: shareId = nas_share.id

storage↑ top

Entity Set(s): storage

FieldTypeNullable
idPKInt32Yes
nameStringYes
identifierStringYes
ipStringYes
modelStringYes
manufacturerStringYes
serialNumberStringYes
microcodeVersionStringYes
rawCapacityMBInt64Yes
spareRawCapacityMBInt64Yes
failedRawCapacityMBInt64Yes
memoryMBInt64Yes
cpuCountInt32Yes
manageURLStringYes
familyStringYes
isVirtualStringYes
clusterStringYes
urlStringYes
lastAcquiredTimeDateTimeOffsetYes
activeStringYes
dataCenterStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
dr_internal_volume_replicadr_internal_volume_replicamany
nas_sharenas_sharemany
storage_controllerstorage_controllermany
nas_share_initiatornas_share_initiatormany
nas_cr_logicalnas_cr_logicalmany
unknown_logicalunknown_logicalmany
volume_mapvolume_mapmany
file_system_to_volumefile_system_to_volumemany
cluster_switch_portcluster_switch_portmany
backend_lun_to_volumebackend_lun_to_volumemany
quotaquotamany
iscsi_logicaliscsi_logicalmany
hv_lun_to_volumehv_lun_to_volumemany
storage_poolstorage_poolmany
hv_nas_share_to_sharehv_nas_share_to_sharemany
hv_data_store_to_volumehv_data_store_to_volumemany
qtreeqtreemany
dr_qtree_replicadr_qtree_replicamany
cluster_switchcluster_switchmany
volume_maskvolume_maskmany
auto_tiering_policyauto_tiering_policymany
auto_tiering_policy_constraintauto_tiering_policy_constraintmany
dr_volume_replicadr_volume_replicamany
hv_virtual_disk_to_volumehv_virtual_disk_to_volumemany
logicallogicalmany
volumevolumemany
backend_pathbackend_pathmany
diskdiskmany
internal_volumeinternal_volumemany
nas_file_sharenas_file_sharemany
hv_data_store_to_internal_volumehv_data_store_to_internal_volumemany
storage_to_applicationstorage_to_applicationmany
backend_lunbackend_lunmany
violationviolationmany
storage_portstorage_portmany
physical_pathphysical_pathmany
disk_groupdisk_groupmany
storage_nodestorage_nodemany

storage_controller↑ top

Entity Set(s): storage_controller

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
wwnStringYes
modelStringYes
manufacturerStringYes
driverStringYes
firmwareStringYes
numberOfPortsStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
storage_portstorage_portmany

storage_node↑ top

Entity Set(s): storage_node

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
nameStringYes
identifierStringYes
versionStringYes
modelStringYes
serialNumberStringYes
stateStringYes
partnerNodeIdInt32Yes
memorySizeMBInt64Yes
cacheSizeMBInt64Yes
numberOfProcessorsInt32Yes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
cluster_switch_portcluster_switch_portmany

storage_node_to_internal_volume↑ top

Entity Set(s): storage_node_to_internal_volume

FieldTypeNullable
storageIdInt32Yes
storageNodeIdInt32Yes
internalVolumeIdInt32Yes

storage_node_to_port↑ top

Entity Set(s): storage_node_to_port

FieldTypeNullable
storageIdInt32Yes
storageNodeIdInt32Yes
portIdInt32Yes

storage_node_to_storage_pool↑ top

Entity Set(s): storage_node_to_storage_pool

FieldTypeNullable
storageIdInt32Yes
storageNodeIdInt32Yes
storagePoolIdInt32Yes

storage_node_to_volume↑ top

Entity Set(s): storage_node_to_volume

FieldTypeNullable
storageIdInt32Yes
storageNodeIdInt32Yes
volumeIdInt32Yes

storage_pool↑ top

Entity Set(s): storage_pool

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
identifierStringYes
typeStringYes
nameStringYes
thinProvisioningSupportedStringYes
includeInDwhCapacityStringYes
isVirtualStringYes
raidGroupStringYes
vendorTierStringYes
autoTieringStringYes
usesFlashPoolsStringYes
redundancyStringYes
statusStringYes
snapshotAllocatedCapacityMBInt64Yes
snapshotUsedCapacityMBInt64Yes
dataAllocatedCapacityMBInt64Yes
dataUsedCapacityMBInt64Yes
totalAllocatedCapacityMBInt64Yes
totalUsedCapacityMBInt64Yes
rawToUsableRatioDoubleYes
reservedCapacityMBInt64Yes
otherUsedCapacityMBInt64Yes
otherAllocatedCapacityMBInt64Yes
physicalDiskCapacityMBInt64Yes
softLimitCapacityMBInt64Yes
dedupeEnabledStringYes
compressionEnabledStringYes
compactionEnabledStringYes
dedupeRatioDoubleYes
dedupeSavingsGBInt64Yes
compressionRatioDoubleYes
compressionSavingsGBInt64Yes
compressionSavingsPercentDoubleYes
compactionSavingsGBInt64Yes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
internal_volumeinternal_volumemany

storage_pool_to_backend_lun↑ top

Entity Set(s): storage_pool_to_backend_lun

FieldTypeNullable
storageIdInt32Yes
storagePoolIdInt32Yes
backendLunIdInt32Yes

storage_pool_to_disk↑ top

Entity Set(s): storage_pool_to_disk

FieldTypeNullable
storageIdInt32Yes
storagePoolIdInt32Yes
diskIdInt32Yes

storage_port↑ top

Entity Set(s): storage_port

FieldTypeNullable
idPKInt32Yes
controllerIdFK
storage_controller.id
Int32Yes
storageIdFK
storage.id
Int32Yes
wwnStringYes
nodeWwnStringYes
portIdStringYes
nameStringYes
speedStringYes
controllerStringYes
urlStringYes
activeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
storage_controllerstorage_controllerone
JOIN: controllerId = storage_controller.id

storage_to_application↑ top

Entity Set(s): storage_to_application

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
applicationIdFK
application.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
applicationapplicationone
JOIN: applicationId = application.id

switch↑ top

Entity Set(s): switch

FieldTypeNullable
idPKInt32Yes
fabricIdFK
fabric.id
Int32Yes
identifierStringYes
wwnStringYes
ipStringYes
nameStringYes
manufacturerStringYes
modelStringYes
firmwareStringYes
domainIdStringYes
domainIdTypeStringYes
priorityStringYes
vsanEnabledStringYes
serialNumberStringYes
manageURLStringYes
sanRouteEnabledStringYes
npvStringYes
isGeneratedStringYes
typeStringYes
urlStringYes
lastAcquiredTimeDateTimeOffsetYes
activeStringYes
dataCenterStringYes
switchLevelStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
fabricfabricone
JOIN: fabricId = fabric.id
switch_portswitch_portmany
switch_to_applicationswitch_to_applicationmany

switch_port↑ top

Entity Set(s): switch_port

FieldTypeNullable
idPKInt32Yes
switchIdFK
switch.id
Int32Yes
fabricIdFK
fabric.id
Int32Yes
virtualSwitchIdFK
virtual_switch.id
Int32Yes
wwnStringYes
statusStringYes
rawPortStatusStringYes
typeStringYes
portPhysicalStateStringYes
numberInt64Yes
bladeInt64Yes
portIdStringYes
nameStringYes
speedStringYes
fc4ProtocolStringYes
classOfServiceStringYes
gbicTypeStringYes
urlStringYes
isGeneratedStringYes
activeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
virtual_switchvirtual_switchone
JOIN: virtualSwitchId = virtual_switch.id
fabricfabricone
JOIN: fabricId = fabric.id
switchswitchone
JOIN: switchId = switch.id
switch_port_to_applicationswitch_port_to_applicationmany
fc_name_server_entryfc_name_server_entrymany

switch_port_to_application↑ top

Entity Set(s): switch_port_to_application

FieldTypeNullable
idPKInt32Yes
applicationIdFK
application.id
Int32Yes
portIdFK
switch_port.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_portswitch_portone
JOIN: portId = switch_port.id
applicationapplicationone
JOIN: applicationId = application.id

switch_to_application↑ top

Entity Set(s): switch_to_application

FieldTypeNullable
idPKInt32Yes
switchIdFK
switch.id
Int32Yes
applicationIdFK
application.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switchswitchone
JOIN: switchId = switch.id
applicationapplicationone
JOIN: applicationId = application.id

tape↑ top

Entity Set(s): tape

FieldTypeNullable
idPKInt32Yes
nameStringYes
identifierStringYes
ipStringYes
manufacturerStringYes
serialNumberStringYes
activeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
tape_controllertape_controllermany
violationviolationmany
tape_porttape_portmany
physical_pathphysical_pathmany
logicallogicalmany

tape_controller↑ top

Entity Set(s): tape_controller

FieldTypeNullable
idPKInt32Yes
tapeIdFK
tape.id
Int32Yes
wwnStringYes
modelStringYes
manufacturerStringYes
driverStringYes
firmwareStringYes
numberOfPortsStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
tapetapeone
JOIN: tapeId = tape.id
tape_porttape_portmany

tape_port↑ top

Entity Set(s): tape_port

FieldTypeNullable
idPKInt32Yes
controllerIdFK
tape_controller.id
Int32Yes
tapeIdFK
tape.id
Int32Yes
wwnStringYes
nodeWwnStringYes
portIdStringYes
nameStringYes
speedStringYes
controllerStringYes
urlStringYes
activeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
tape_controllertape_controllerone
JOIN: controllerId = tape_controller.id
tapetapeone
JOIN: tapeId = tape.id

tier↑ top

Entity Set(s): tier

FieldTypeNullable
idInt32Yes
nameStringYes
sequenceInt32Yes
costDoubleYes

unknown_logical↑ top

Entity Set(s): unknown_logical

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
storageIdFK
storage.id
Int32Yes
volumeIdFK
volume.id
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
hosthostone
JOIN: hostId = host.id

violation↑ top

Entity Set(s): violation

FieldTypeNullable
idPKInt32Yes
hostIdFK
host.id
Int32Yes
genericDeviceIdFK
generic_device.id
Int32Yes
storageIdFK
storage.id
Int32Yes
tapeIdFK
tape.id
Int32Yes
volumeIdFK
volume.id
Int32Yes
volumeNameStringYes
typeStringYes
technologyTypeStringYes
sinceDateTimeOffsetYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
tapetapeone
JOIN: tapeId = tape.id
hosthostone
JOIN: hostId = host.id
generic_devicegeneric_deviceone
JOIN: genericDeviceId = generic_device.id

virtual_switch↑ top

Entity Set(s): virtual_switch

FieldTypeNullable
idPKInt32Yes
fabricIdFK
fabric.id
Int32Yes
wwnStringYes
ipStringYes
nameStringYes
domainIdStringYes
domainIdTypeStringYes
priorityStringYes
switchRoleStringYes
chassisWwnStringYes
npvStringYes
isGeneratedStringYes
typeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
fabricfabricone
JOIN: fabricId = fabric.id
switch_portswitch_portmany

virtual_to_backend_volume↑ top

Entity Set(s): virtual_to_backend_volume

FieldTypeNullable
virtualVolumeIdInt32Yes
backendVolumeIdInt32Yes

vm_to_application↑ top

Entity Set(s): vm_to_application

FieldTypeNullable
idPKInt32Yes
vmIdFK
hv_virtual_machine.id
Int32Yes
applicationIdFK
application.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
applicationapplicationone
JOIN: applicationId = application.id
hv_virtual_machinehv_virtual_machineone
JOIN: vmId = hv_virtual_machine.id

vmware_host↑ top

Entity Set(s): vmware_host

FieldTypeNullable
idPKInt32Yes
identifierStringYes
hvServerIdFK
hv_server.id
Int32Yes
nameStringYes
numCpuCoresInt64Yes
numCpuPackagesInt64Yes
numCpuThreadsInt64Yes
numNodesInt64Yes
hyperThreadActiveStringYes
hyperThreadAvailableStringYes
hyperThreadConfigStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
hv_serverhv_serverone
JOIN: hvServerId = hv_server.id

volume↑ top

Entity Set(s): volume

FieldTypeNullable
idPKInt32Yes
storageIdFK
storage.id
Int32Yes
internalVolumeIdFK
internal_volume.id
Int32Yes
qtreeIdFK
qtree.id
Int32Yes
nameStringYes
labelStringYes
thinProvisionedStringYes
capacityMBInt64Yes
consumedCapacityMBInt64Yes
writtenCapacityMBInt64Yes
rawCapacityMBInt64Yes
typeStringYes
replicaSourceStringYes
replicaTargetStringYes
snapshotStringYes
cylindersInt32Yes
diskGroupStringYes
isVirtualStringYes
metaStringYes
virtualStorageStringYes
headStringYes
protectionTypeStringYes
technologyTypeStringYes
autoTieringPolicyIdFK
auto_tiering_policy.id
Int32Yes
autoTieringStringYes
uuidStringYes
isMainframeStringYes
lastKnownAccessTimeDateTimeOffsetYes
urlStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
internal_volumeinternal_volumeone
JOIN: internalVolumeId = internal_volume.id
auto_tiering_policyauto_tiering_policyone
JOIN: autoTieringPolicyId = auto_tiering_policy.id
qtreeqtreeone
JOIN: qtreeId = qtree.id
volume_maskvolume_maskmany
dr_volume_replicadr_volume_replicamany
hv_virtual_disk_to_volumehv_virtual_disk_to_volumemany
unknown_logicalunknown_logicalmany
volume_mapvolume_mapmany
logicallogicalmany
file_system_to_volumefile_system_to_volumemany
backend_lun_to_volumebackend_lun_to_volumemany
violationviolationmany
volume_to_applicationvolume_to_applicationmany
iscsi_logicaliscsi_logicalmany
hv_lun_to_volumehv_lun_to_volumemany
physical_pathphysical_pathmany
hv_data_store_to_volumehv_data_store_to_volumemany

volume_in_storage_pool↑ top

Entity Set(s): volume_in_storage_pool

FieldTypeNullable
storageIdInt32Yes
volumeIdInt32Yes
storagePoolIdInt32Yes
volumeMembersCapacityMBInt64Yes
volumeMembersRawCapacityMBInt64Yes

volume_map↑ top

Entity Set(s): volume_map

FieldTypeNullable
idPKInt32Yes
volumeIdFK
volume.id
Int32Yes
storageIdFK
storage.id
Int32Yes
protocolControllerStringYes
lunStringYes
tidInt32Yes
storagePortWwnStringYes
wwnSecurityValidityByteYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id

volume_mask↑ top

Entity Set(s): volume_mask

FieldTypeNullable
idPKInt32Yes
volumeIdFK
volume.id
Int32Yes
storageIdFK
storage.id
Int32Yes
protocolControllerStringYes
storagePortWwnStringYes
initiatorWwnStringYes
hostIdFK
host.id
Int32Yes
typeStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storagestorageone
JOIN: storageId = storage.id
volumevolumeone
JOIN: volumeId = volume.id
hosthostone
JOIN: hostId = host.id

volume_to_application↑ top

Entity Set(s): volume_to_application

FieldTypeNullable
idPKInt32Yes
applicationIdFK
application.id
Int32Yes
volumeIdFK
volume.id
Int32Yes
inheritedStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
volumevolumeone
JOIN: volumeId = volume.id
applicationapplicationone
JOIN: applicationId = application.id

zone↑ top

Entity Set(s): zone

FieldTypeNullable
idPKInt32Yes
fabricIdFK
fabric.id
Int32Yes
nameStringYes
fabricWwnStringYes
configurationNameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
fabricfabricone
JOIN: fabricId = fabric.id
zone_memberzone_membermany

zone_member↑ top

Entity Set(s): zone_member

FieldTypeNullable
idPKInt32Yes
zoneIdFK
zone.id
Int32Yes
fabricIdFK
fabric.id
Int32Yes
typeStringYes
wwnStringYes
zoneNameStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
fabricfabricone
JOIN: fabricId = fabric.id
zonezoneone
JOIN: zoneId = zone.id