SchemaSpy Analysis of opm - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Tue Apr 23 04:58 EDT 2019 |
| ||||||
|
opm contains 903 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
continuous_event_participant_stats | absChangeStatisticValue | float | 12 | √ | null | ||
continuous_event_participant | actualTargetId | bigint | 19 | √ | null | ||
new_s_all_aggregates_periodic | aggregateDerivedType | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | aggregateDerivedType | varchar | 255 | √ | null | ||
resource_budgets | aggregateExpectedBudgetedIOPS | float | 12 | √ | null | ||
resource_budgets | aggregateExpectedNonBudgetedIOPS | float | 12 | √ | null | ||
new_s_all_luns_periodic | aggregateId | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | aggregateId | bigint | 19 | √ | null | ||
s_all_luns_periodic | aggregateId | bigint | 19 | √ | null | ||
s_all_volumes_periodic | aggregateId | bigint | 19 | √ | null | ||
new_s_all_luns_periodic | aggregateName | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | aggregateName | varchar | 255 | √ | null | ||
s_all_luns_periodic | aggregateName | varchar | 255 | √ | null | ||
s_all_volumes_periodic | aggregateName | varchar | 255 | √ | null | ||
resource_budgets | aggregatePeakBudgetedIOPS | float | 12 | √ | null | ||
resource_budgets | aggregatePeakNonBudgetedIOPS | float | 12 | √ | null | ||
new_s_all_luns_periodic | aggregateResourceKey | varchar | 512 | √ | null | ||
new_s_all_volumes_periodic | aggregateResourceKey | varchar | 512 | √ | null | ||
s_all_luns_periodic | aggregateResourceKey | varchar | 512 | √ | null | ||
s_all_volumes_periodic | aggregateResourceKey | varchar | 512 | √ | null | ||
new_s_all_aggregates_periodic | aggregateType | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | aggregateType | varchar | 255 | √ | null | ||
new_s_all_aggregates_periodic | aggregateUtilization | float | 12 | √ | null | ||
s_all_aggregates_periodic | aggregateUtilization | float | 12 | √ | null | ||
acquisition_info | analysisDuration | bigint | 19 | √ | 300000 | ||
continuous_event_participant | analysisId | bigint | 19 | √ | null | ||
workload_view | assignedAbsoluteMinIops | bigint | 19 | √ | 100 | Indicates the minimum IOPS value for a performance policy. | |
workload_view | assignedExpectedIops | decimal | 39 | √ | null | ||
workload_view | assignedExpectedIopsPerTB | bigint | 19 | √ | null | Specifies the minimum expected IOPS allocated based on the storage object allocated size. | |
workload_view | assignedPeakIops | double | 40 | √ | null | ||
workload_view | assignedPeakIopsPerTB | bigint | 19 | √ | null | Specifies the maximum possible IOPS per TB allocated based on the storage object used size. | |
workload_view | assignedSslName | varchar | 255 | √ | null | ||
workload_view | assignedSslUuid | varchar | 512 | √ | null | ||
new_s_all_qospolicygroups_periodic | associatedObjectCount | bigint | 19 | √ | null | ||
s_all_qospolicygroups_periodic | associatedObjectCount | bigint | 19 | √ | null | ||
resource_budgets | attributeChanged | varchar | 255 | √ | null | Attribute changed during Workload PATCH request | |
new_s_all_aggregates_periodic | availableOps | float | 12 | √ | null | ||
new_s_all_nodes_periodic | availableOps | float | 12 | √ | null | ||
s_all_aggregates_periodic | availableOps | float | 12 | √ | null | ||
s_all_nodes_periodic | availableOps | float | 12 | √ | null | ||
continuous_event_participant_stats | avgStatisticValue | float | 12 | √ | null | ||
new_s_all_qospolicygroups_periodic | blockSize | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | blockSize | varchar | 255 | √ | null | ||
threshold | breachPercent | tinyint | 3 | √ | 100 | breachPercent is the percent value which has to be less or equal to 100 | |
resource_capability_stats | budgetedIops | float | 12 | √ | null | ||
workload_provision_mapping | budgetedIops | float | 12 | √ | null | ||
resource_capability_stats | budgetedNoSslIops | float | 12 | √ | null | ||
shadow_table_trail | bulkLoadDone | enum | 12 | √ | null | ||
new_s_all_nodes_periodic | cacheReadThroughput | float | 12 | √ | null | ||
s_all_nodes_periodic | cacheReadThroughput | float | 12 | √ | null | ||
new_s_all_qospolicygroups_periodic | capacityUnit | varchar | 256 | √ | null | ||
s_all_qospolicygroups_periodic | capacityUnit | varchar | 256 | √ | null | ||
workload_provision_mapping | capUsed95th | float | 12 | √ | null | ||
workload_view | capUsed95th | float | 12 | √ | null | ||
workload_provision_mapping | capUsedAvg | float | 12 | √ | null | ||
workload_view | capUsedAvg | float | 12 | √ | null | Capacity used custom percentile, can be modified based on requirement | |
workload_provision_mapping | capUsedCustom | float | 12 | √ | null | Capacity used custom percentile, can be modified based on requirement | |
workload_provision_mapping | capUsedMax | float | 12 | √ | null | ||
workload_view | capUsedMax | float | 12 | √ | null | ||
workload_provision_mapping | capUsedMedian | float | 12 | √ | null | ||
workload_view | capUsedMedian | float | 12 | √ | null | ||
budget_summary | changed_iops | float | 12 | √ | null | ||
new_s_all_volumes_periodic | cloudRecommendation | varchar | 255 | √ | LEARNING | ||
s_all_volumes_periodic | cloudRecommendation | varchar | 255 | √ | LEARNING | ||
workload_view | clusterCommStatus | int | 10 | √ | null | ||
new_s_all_aggregates_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_clusters_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_namespaces_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_nodes_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_svms_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_clusters_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_lifs_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_luns_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_nodes_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_ports_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_svms_periodic | clusterFqdn | varchar | 255 | √ | null | ||
s_all_volumes_periodic | clusterFqdn | varchar | 255 | √ | null | ||
new_s_all_aggregates_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_luns_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_nodes_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_ports_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_qospolicygroups_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_svms_periodic | clusterId | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_aggregates_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_lifs_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_luns_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_namespaces_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_nodes_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_ports_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_qospolicygroups_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_svms_periodic | clusterId | bigint | 19 | √ | null | ||
s_all_volumes_periodic | clusterId | bigint | 19 | √ | null | ||
threshold_policy_mapping | clusterId | bigint | 19 | √ | null | ||
workload_view | clusterKey | varchar | 512 | √ | null | ||
new_s_all_aggregates_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_namespaces_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_nodes_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_svms_periodic | clusterName | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_lifs_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_luns_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_nodes_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_ports_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_svms_periodic | clusterName | varchar | 255 | √ | null | ||
s_all_volumes_periodic | clusterName | varchar | 255 | √ | null | ||
workload_view | clusterName | varchar | 255 | √ | null | Textual name | |
new_s_all_aggregates_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_lifs_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_luns_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_namespaces_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_nodes_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_ports_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_qospolicygroups_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_svms_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
new_s_all_volumes_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_aggregates_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_luns_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_namespaces_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_nodes_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_ports_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_qospolicygroups_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_svms_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
s_all_volumes_periodic | clusterResourceKey | varchar | 512 | √ | null | ||
capacity_tier_analysis | coldData | bigint | 19 | √ | null | This is the inactive data in bytes - null if not detected yet | |
new_s_all_volumes_periodic | coldData | bigint | 19 | √ | null | ||
s_all_volumes_periodic | coldData | bigint | 19 | √ | null | ||
capacity_tier_analysis | coldDataPercent | bigint | 19 | √ | null | This is the inactive data as a percentage of used data - null if not detected yet | |
acquisition_info | collectionDuration | bigint | 19 | √ | -1 | ||
storage_service_level | conformancePolicyUuid | varchar | 512 | √ | null | Conformance policy associated with the performance policy. | |
storage_service_level_view | conformancePolicyUuid | varchar | 512 | √ | null | Conformance policy associated with the performance policy. | |
new_s_all_lifs_periodic | currentLocation | varchar | 255 | √ | null | ||
s_all_lifs_periodic | currentLocation | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | currentNodeId | bigint | 19 | √ | null | ||
s_all_lifs_periodic | currentNodeId | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | currentNodeName | varchar | 255 | √ | null | ||
s_all_lifs_periodic | currentNodeName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | currentNodeResourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | currentNodeResourceKey | varchar | 512 | √ | null | ||
new_s_all_lifs_periodic | currentPortId | bigint | 19 | √ | null | ||
s_all_lifs_periodic | currentPortId | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | currentPortName | varchar | 255 | √ | null | ||
s_all_lifs_periodic | currentPortName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | currentPortResourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | currentPortResourceKey | varchar | 512 | √ | null | ||
continuous_event_participant_stats | currentStatisticValue | float | 12 | √ | null | ||
new_s_all_svms_periodic | data | float | 12 | √ | null | ||
new_s_all_volumes_periodic | data | float | 12 | √ | null | ||
s_all_svms_periodic | data | float | 12 | √ | null | ||
s_all_volumes_periodic | data | float | 12 | √ | null | ||
threshold_policy | deleteTime | bigint | 19 | √ | null | ||
config | description | text | 65535 | √ | null | ||
conformance_policy | description | text | 65535 | √ | null | ||
provisioning_policy | description | text | 65535 | √ | null | Provisioning policy used for workload provisioning. | |
provisioning_policy_view | description | text | 65535 | √ | null | Provisioning policy used for workload provisioning. | |
storage_service_level | description | text | 65535 | √ | null | Performance policy used to ensure workload performance. | |
storage_service_level_view | description | text | 65535 | √ | null | Performance policy used to ensure workload performance. | |
threshold_policy | description | varchar | 1024 | √ | null | ||
new_s_all_volumes_periodic | diskType | varchar | 255 | √ | null | ||
s_all_volumes_periodic | diskType | varchar | 255 | √ | null | ||
continuous_event_participant_stats | dynamicRangeChange | float | 12 | √ | null | ||
continuous_event_participant_stats | dynState | smallint | 5 | √ | null | ||
new_s_all_nodes_periodic | elementName | varchar | 255 | √ | null | ||
new_s_all_svms_periodic | elementName | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | elementName | varchar | 255 | √ | null | ||
s_all_nodes_periodic | elementName | varchar | 255 | √ | null | ||
s_all_svms_periodic | elementName | varchar | 255 | √ | null | ||
s_all_volumes_periodic | elementName | varchar | 255 | √ | null | ||
new_s_all_nodes_periodic | elementResourceKey | varchar | 512 | √ | null | ||
new_s_all_svms_periodic | elementResourceKey | varchar | 512 | √ | null | ||
new_s_all_volumes_periodic | elementResourceKey | varchar | 512 | √ | null | ||
s_all_nodes_periodic | elementResourceKey | varchar | 512 | √ | null | ||
s_all_svms_periodic | elementResourceKey | varchar | 512 | √ | null | ||
s_all_volumes_periodic | elementResourceKey | varchar | 512 | √ | null | ||
workload_view | elementType | smallint | 5 | √ | null | ||
bp_event | endTime | bigint | 19 | √ | null | The end time of the bp event | |
threshold_policy_mapping | endTime | bigint | 19 | √ | null | ||
new_s_all_qospolicygroups_periodic | enforceFloor | bit | 0 | √ | null | ||
s_all_qospolicygroups_periodic | enforceFloor | bit | 0 | √ | null | ||
resource_capability_stats | estIops95th | float | 12 | √ | null | ||
resource_capability_stats | estIopsAvg | float | 12 | √ | null | ||
resource_capability_stats | estIopsCustom | float | 12 | √ | null | Estimated IOPS custom percentile, can be modified based on requirement | |
resource_capability_stats | estIopsMax | float | 12 | √ | null | ||
resource_capability_stats | estIopsMedian | float | 12 | √ | null | ||
new_s_all_aggregates_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_clusters_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_lifs_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_luns_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_namespaces_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_nodes_periodic | eventSeverity | int | 10 | √ | null | ||
new_s_all_ports_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_svms_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_volumes_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_aggregates_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_clusters_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_lifs_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_luns_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_namespaces_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_nodes_periodic | eventSeverity | int | 10 | √ | null | ||
s_all_ports_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_svms_periodic | eventSeverity | smallint | 5 | √ | null | ||
s_all_volumes_periodic | eventSeverity | smallint | 5 | √ | null | ||
new_s_all_qospolicygroups_periodic | expectedLatency | decimal | 15,3 | √ | null | ||
s_all_qospolicygroups_periodic | expectedLatency | decimal | 15,3 | √ | null | ||
storage_service_level | expectedLatency | float | 12 | √ | null | ||
storage_service_level_view | expectedLatency | float | 12 | √ | null | ||
node_seed_iops | flashCacheSizeGB | int | 10 | √ | null | ||
continuous_event_participant_stats | forecastStatisticValue | float | 12 | √ | null | ||
forecast | forecastType | enum | 6 | √ | SIGMA | ||
new_s_all_aggregates_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_clusters_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_luns_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_nodes_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_svms_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_aggregates_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_clusters_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_luns_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_namespaces_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_nodes_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_svms_periodic | freeCapacity | bigint | 19 | √ | null | ||
s_all_volumes_periodic | freeCapacity | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | homeLocation | varchar | 255 | √ | null | ||
s_all_lifs_periodic | homeLocation | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | homeNodeId | bigint | 19 | √ | null | ||
s_all_lifs_periodic | homeNodeId | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | homeNodeName | varchar | 255 | √ | null | ||
s_all_lifs_periodic | homeNodeName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | homeNodeResourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | homeNodeResourceKey | varchar | 512 | √ | null | ||
new_s_all_lifs_periodic | homePortId | bigint | 19 | √ | null | ||
s_all_lifs_periodic | homePortId | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | homePortName | varchar | 255 | √ | null | ||
s_all_lifs_periodic | homePortName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | homePortResourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | homePortResourceKey | varchar | 512 | √ | null | ||
node_seed_iops | hybridSsdSizeGB | int | 10 | √ | null | ||
event | id | bigint | 19 | √ | null | ||
resource_capability_stats | iops95th | float | 12 | √ | null | ||
workload_provision_mapping | iops95th | float | 12 | √ | null | ||
workload_view | iops95th | float | 12 | √ | null | ||
resource_capability_stats | iopsAvg | float | 12 | √ | null | ||
workload_provision_mapping | iopsAvg | float | 12 | √ | null | ||
workload_view | iopsAvg | float | 12 | √ | null | IOPS custom percentile, can be modified based on requirement | |
workload_view | iopsBudgeted | float | 12 | √ | null | ||
resource_capability_stats | iopsCustom | float | 12 | √ | null | IOPS custom percentile, can be modified based on requirement | |
workload_provision_mapping | iopsCustom | float | 12 | √ | null | IOPS custom percentile, can be modified based on requirement | |
resource_capability_stats | iopsMax | float | 12 | √ | null | ||
workload_provision_mapping | iopsMax | float | 12 | √ | null | ||
workload_view | iopsMax | float | 12 | √ | null | ||
resource_capability_stats | iopsMedian | float | 12 | √ | null | ||
workload_provision_mapping | iopsMedian | float | 12 | √ | null | ||
workload_view | iopsMedian | float | 12 | √ | null | ||
resource_capability_stats | iopsSeed | bigint | 19 | √ | null | ||
new_s_all_qospolicygroups_periodic | isAdaptive | bit | 0 | √ | null | ||
s_all_qospolicygroups_periodic | isAdaptive | bit | 0 | √ | null | ||
acquisition_info | isHistorical | bit | 0 | √ | 0 | flag showing the collection is normal or historical. | |
new_s_all_aggregates_periodic | isInactiveDataReportingEnabled | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | isInactiveDataReportingEnabled | varchar | 255 | √ | null | ||
coherence_change_record | isMappedObjInCoherence | bit | 1 | √ | b'1' | 1 means the mapped object is in this table, 0 means it is in netapp_model | |
workload_view | isOnline | int | 10 | √ | null | ||
new_s_all_qospolicygroups_periodic | isShared | bit | 0 | √ | null | ||
s_all_qospolicygroups_periodic | isShared | bit | 0 | √ | null | ||
continuous_event_participant | isTriggered | bit | 0 | √ | null | ||
workload_provision_mapping | lastSslUpdateTime | bigint | 19 | √ | null | ||
new_s_all_aggregates_periodic | latency | float | 12 | √ | null | ||
new_s_all_lifs_periodic | latency | float | 12 | √ | null | ||
new_s_all_luns_periodic | latency | float | 12 | √ | null | ||
new_s_all_namespaces_periodic | latency | float | 12 | √ | null | ||
new_s_all_nodes_periodic | latency | float | 12 | √ | null | ||
new_s_all_svms_periodic | latency | float | 12 | √ | null | ||
new_s_all_volumes_periodic | latency | float | 12 | √ | null | ||
s_all_aggregates_periodic | latency | float | 12 | √ | null | ||
s_all_lifs_periodic | latency | float | 12 | √ | null | ||
s_all_luns_periodic | latency | float | 12 | √ | null | ||
s_all_namespaces_periodic | latency | float | 12 | √ | null | ||
s_all_nodes_periodic | latency | float | 12 | √ | null | ||
s_all_svms_periodic | latency | float | 12 | √ | null | ||
s_all_volumes_periodic | latency | float | 12 | √ | null | ||
workload_provision_mapping | latency95th | float | 12 | √ | null | ||
workload_view | latency95th | float | 12 | √ | null | ||
workload_provision_mapping | latencyAvg | float | 12 | √ | null | ||
workload_view | latencyAvg | float | 12 | √ | null | Latency custom percentile, can be modified based on requirement | |
workload_provision_mapping | latencyCustom | float | 12 | √ | null | Latency custom percentile, can be modified based on requirement | |
workload_provision_mapping | latencyMax | float | 12 | √ | null | ||
workload_view | latencyMax | float | 12 | √ | null | ||
workload_provision_mapping | latencyMedian | float | 12 | √ | null | ||
workload_view | latencyMedian | float | 12 | √ | null | ||
workload_view | latencyObservationDuration | smallint | 5 | √ | null | The window size (in minutes) defines the time period from the current time within which all the relevant samples are analyzed for identifying any risk and incident resulting from conformance violations. | |
workload_view | latencyRiskThresholdPercent | smallint | 5 | √ | null | If the percentage of non-conforming samples w.r.t. total samples in a given observation_window exceeds this threshold, a risk event is raised. | |
continuous_event_participant_stats | linearTrend | float | 12 | √ | null | ||
continuous_event_participant_stats | lowerThreshold | float | 12 | √ | null | ||
new_s_all_qospolicygroups_periodic | managedByNslm | bit | 0 | √ | null | ||
new_s_all_volumes_periodic | managedByNslm | bit | 0 | √ | null | ||
s_all_qospolicygroups_periodic | managedByNslm | bit | 0 | √ | null | ||
s_all_volumes_periodic | managedByNslm | bit | 0 | √ | null | ||
new_s_all_clusters_periodic | managementIp | varchar | 255 | √ | null | ||
s_all_clusters_periodic | managementIp | varchar | 255 | √ | null | ||
coherence_change_record | mappedId | bigint | 19 | √ | null | coherence_change_record table id, OR netapp_model table object id, of the mapped object, depends on isMappedObjInCoherence | |
coherence_change_record | mappedObjType | smallint | 5 | √ | null | type of the mapped object | |
resource_capability_stats | maxBudgetedIops | float | 12 | √ | null | ||
workload_provision_mapping | maxBudgetedIops | float | 12 | √ | null | ||
resource_capability_stats | maxBudgetedNoSslIops | float | 12 | √ | null | ||
new_s_all_qospolicygroups_periodic | maxThroughput | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | maxThroughput | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | minAllocation | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | minAllocation | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | minIOPsAllocation | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | minIOPsAllocation | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | minThroughput | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | minThroughput | varchar | 255 | √ | null | ||
acquisition_info | msgRcvTime | bigint | 19 | √ | 0 | ||
coherence_workload | name | varchar | 255 | √ | null | ||
new_s_all_aggregates_periodic | name | varchar | 255 | √ | null | ||
new_s_all_clusters_periodic | name | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | name | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | name | varchar | 255 | √ | null | ||
new_s_all_namespaces_periodic | name | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | name | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | name | varchar | 255 | √ | null | ||
provisioning_policy | name | varchar | 255 | √ | null | ||
provisioning_policy_view | name | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | name | varchar | 255 | √ | null | ||
s_all_clusters_periodic | name | varchar | 255 | √ | null | ||
s_all_lifs_periodic | name | varchar | 255 | √ | null | ||
s_all_luns_periodic | name | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | name | varchar | 255 | √ | null | ||
s_all_ports_periodic | name | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | name | varchar | 255 | √ | null | ||
stat_type_definition | name | varchar | 225 | √ | null | ||
storage_service_level | name | varchar | 255 | √ | null | ||
storage_service_level_view | name | varchar | 255 | √ | null | ||
threshold | name | varchar | 128 | √ | null | ||
change_event_attribute | newValue | varchar | 255 | √ | null | Attribute value after the update | |
new_s_all_clusters_periodic | nodeCount | int | 10 | √ | null | ||
s_all_clusters_periodic | nodeCount | int | 10 | √ | null | ||
resource_budgets | nodeExpectedBudgetedIOPS | float | 12 | √ | null | ||
resource_budgets | nodeExpectedNonBudgetedIOPS | float | 12 | √ | null | ||
new_s_all_aggregates_periodic | nodeId | bigint | 19 | √ | null | ||
new_s_all_luns_periodic | nodeId | bigint | 19 | √ | null | ||
new_s_all_ports_periodic | nodeId | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | nodeId | bigint | 19 | √ | null | ||
s_all_aggregates_periodic | nodeId | bigint | 19 | √ | null | ||
s_all_luns_periodic | nodeId | bigint | 19 | √ | null | ||
s_all_ports_periodic | nodeId | bigint | 19 | √ | null | ||
s_all_volumes_periodic | nodeId | bigint | 19 | √ | null | ||
new_s_all_aggregates_periodic | nodeName | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | nodeName | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | nodeName | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | nodeName | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | nodeName | varchar | 255 | √ | null | ||
s_all_luns_periodic | nodeName | varchar | 255 | √ | null | ||
s_all_ports_periodic | nodeName | varchar | 255 | √ | null | ||
s_all_volumes_periodic | nodeName | varchar | 255 | √ | null | ||
resource_budgets | nodePeakBudgetedIOPS | float | 12 | √ | null | ||
resource_budgets | nodePeakNonBudgetedIOPS | float | 12 | √ | null | ||
new_s_all_aggregates_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
new_s_all_luns_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
new_s_all_ports_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
new_s_all_volumes_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
s_all_aggregates_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
s_all_luns_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
s_all_ports_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
s_all_volumes_periodic | nodeResourceKey | varchar | 512 | √ | null | ||
new_s_all_nodes_periodic | nodeUtilization | float | 12 | √ | null | ||
s_all_nodes_periodic | nodeUtilization | float | 12 | √ | null | ||
workload_provision_mapping | nonConformingData | float | 12 | √ | null | ||
workload_view | nonConformingData | float | 12 | √ | null | ||
new_s_all_aggregates_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_clusters_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_lifs_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_luns_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_namespaces_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_nodes_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_ports_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_svms_periodic | numberOfHours | smallint | 5 | √ | null | ||
new_s_all_volumes_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_aggregates_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_clusters_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_lifs_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_luns_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_namespaces_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_nodes_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_ports_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_svms_periodic | numberOfHours | smallint | 5 | √ | null | ||
s_all_volumes_periodic | numberOfHours | smallint | 5 | √ | null | ||
coherence_change_record | objKey | varchar | 255 | √ | null | object resource key | |
change_event_attribute | oldValue | varchar | 255 | √ | null | Attribute value before the update | |
new_s_all_aggregates_periodic | ops | float | 12 | √ | null | ||
new_s_all_clusters_periodic | ops | float | 12 | √ | null | ||
new_s_all_lifs_periodic | ops | float | 12 | √ | null | ||
new_s_all_luns_periodic | ops | float | 12 | √ | null | ||
new_s_all_namespaces_periodic | ops | float | 12 | √ | null | ||
new_s_all_nodes_periodic | ops | float | 12 | √ | null | ||
new_s_all_svms_periodic | ops | float | 12 | √ | null | ||
new_s_all_volumes_periodic | ops | float | 12 | √ | null | ||
s_all_aggregates_periodic | ops | float | 12 | √ | null | ||
s_all_clusters_periodic | ops | float | 12 | √ | null | ||
s_all_lifs_periodic | ops | float | 12 | √ | null | ||
s_all_luns_periodic | ops | float | 12 | √ | null | ||
s_all_namespaces_periodic | ops | float | 12 | √ | null | ||
s_all_nodes_periodic | ops | float | 12 | √ | null | ||
s_all_svms_periodic | ops | float | 12 | √ | null | ||
s_all_volumes_periodic | ops | float | 12 | √ | null | ||
new_s_all_volumes_periodic | opsPerTB | float | 12 | √ | null | ||
s_all_volumes_periodic | opsPerTB | float | 12 | √ | null | ||
node_seed_iops | overwriteHybridIops | bigint | 19 | √ | null | ||
new_s_all_qospolicygroups_periodic | policyGroupClass | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | policyGroupClass | varchar | 255 | √ | null | ||
resource_capability_stats | preferredStorageServiceLevelId | bigint | 19 | √ | null | ||
workload_provision_mapping | provisioningPolicyId | bigint | 19 | √ | null | ||
workload_view | provisioningPolicyName | varchar | 255 | √ | null | ||
workload_provision_mapping | provisioningPolicyStatus | enum | 5 | √ | null | ||
workload_view | provisioningPolicyUuid | varchar | 512 | √ | null | ||
new_s_all_luns_periodic | qosPolicyGroup | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | qosPolicyGroup | varchar | 255 | √ | null | ||
s_all_luns_periodic | qosPolicyGroup | varchar | 255 | √ | null | ||
s_all_volumes_periodic | qosPolicyGroup | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | qosPolicyGroupId | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | qosPolicyGroupId | bigint | 19 | √ | null | ||
s_all_luns_periodic | qosPolicyGroupId | bigint | 19 | √ | null | ||
s_all_volumes_periodic | qosPolicyGroupId | bigint | 19 | √ | null | ||
workload_provision_mapping | qosPolicyGroupId | bigint | 19 | √ | null | ||
node_seed_iops | readFlashCacheIops | bigint | 19 | √ | null | ||
node_seed_iops | readHybridIops | bigint | 19 | √ | null | ||
node_seed_iops | readSasIops | bigint | 19 | √ | null | ||
node_seed_iops | readSataIops | bigint | 19 | √ | null | ||
node_seed_iops | readSsdIops | bigint | 19 | √ | null | ||
new_s_all_nodes_periodic | readThroughput | float | 12 | √ | null | ||
s_all_nodes_periodic | readThroughput | float | 12 | √ | null | ||
capacity_tier_analysis | recommendationData | json | 0 | √ | null | ||
new_s_all_volumes_periodic | recommendationData | json | 0 | √ | null | ||
s_all_volumes_periodic | recommendationData | json | 0 | √ | null | ||
resource_capability_stats | resourceId | bigint | 19 | √ | null | ||
new_s_all_aggregates_periodic | resourceKey | varchar | 512 | √ | null | ||
new_s_all_clusters_periodic | resourceKey | varchar | 512 | √ | null | ||
new_s_all_lifs_periodic | resourceKey | varchar | 512 | √ | null | ||
new_s_all_luns_periodic | resourceKey | varchar | 512 | √ | null | ||
new_s_all_namespaces_periodic | resourceKey | varchar | 512 | √ | null | ||
new_s_all_ports_periodic | resourceKey | varchar | 512 | √ | null | ||
new_s_all_qospolicygroups_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_aggregates_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_clusters_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_luns_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_namespaces_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_ports_periodic | resourceKey | varchar | 512 | √ | null | ||
s_all_qospolicygroups_periodic | resourceKey | varchar | 512 | √ | null | ||
resource_capability_stats | resourceType | smallint | 5 | √ | null | ||
new_s_all_lifs_periodic | role | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | role | varchar | 255 | √ | null | ||
s_all_lifs_periodic | role | varchar | 255 | √ | null | ||
s_all_ports_periodic | role | varchar | 255 | √ | null | ||
forecast | rtOps | blob | 65535 | √ | null | ||
new_s_all_clusters_periodic | serialNumber | varchar | 255 | √ | null | ||
s_all_clusters_periodic | serialNumber | varchar | 255 | √ | null | ||
threshold | severityValue | decimal | 15,3 | √ | null | ||
bp_event | sourceEventId | bigint | 19 | √ | null | Id of UM event that causes this blackout period | |
new_s_all_ports_periodic | speed | bigint | 19 | √ | null | ||
s_all_ports_periodic | speed | bigint | 19 | √ | null | ||
budget_summary | sslId | bigint | 19 | √ | null | ||
resource_budgets | sslId | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | state | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | state | varchar | 255 | √ | null | ||
resource_capability_stats | statEndTime | bigint | 19 | √ | null | ||
workload_provision_mapping | statEndTime | bigint | 19 | √ | null | ||
resource_capability_stats | statStartTime | bigint | 19 | √ | null | ||
workload_provision_mapping | statStartTime | bigint | 19 | √ | null | ||
tenant | status | enum | 8 | √ | ENABLED | ||
workload_provision_mapping | storageServiceLevelId | bigint | 19 | √ | null | ||
continuous_event_participant | subPolicyId | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | subsystem | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | subsystem | varchar | 255 | √ | null | ||
workload_view | suggestedAbsoluteMinIops | bigint | 19 | √ | 100 | Indicates the minimum IOPS value for a performance policy. | |
workload_view | suggestedExpectedIops | decimal | 39 | √ | null | ||
workload_view | suggestedExpectedIopsPerTB | bigint | 19 | √ | null | Specifies the minimum expected IOPS allocated based on the storage object allocated size. | |
workload_view | suggestedPeakIops | double | 40 | √ | null | ||
workload_view | suggestedPeakIopsPerTB | bigint | 19 | √ | null | Specifies the maximum possible IOPS per TB allocated based on the storage object used size. | |
workload_view | suggestedSslName | varchar | 255 | √ | null | ||
workload_view | suggestedSslUuid | varchar | 512 | √ | null | ||
workload_provision_mapping | suggestedStorageServiceLevelId | bigint | 19 | √ | null | ||
active_directory | svm_key | varchar | 512 | √ | null | ||
new_s_all_lifs_periodic | svmId | bigint | 19 | √ | null | ||
new_s_all_luns_periodic | svmId | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | svmId | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | svmId | bigint | 19 | √ | null | ||
s_all_lifs_periodic | svmId | bigint | 19 | √ | null | ||
s_all_luns_periodic | svmId | bigint | 19 | √ | null | ||
s_all_namespaces_periodic | svmId | bigint | 19 | √ | null | ||
s_all_volumes_periodic | svmId | bigint | 19 | √ | null | ||
coherence_workload | svmKey | varchar | 255 | √ | null | svm resource key | |
coherence_workload | svmName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | svmName | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | svmName | varchar | 255 | √ | null | ||
new_s_all_namespaces_periodic | svmName | varchar | 255 | √ | null | ||
new_s_all_volumes_periodic | svmName | varchar | 255 | √ | null | ||
s_all_lifs_periodic | svmName | varchar | 255 | √ | null | ||
s_all_luns_periodic | svmName | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | svmName | varchar | 255 | √ | null | ||
s_all_volumes_periodic | svmName | varchar | 255 | √ | null | ||
new_s_all_lifs_periodic | svmResourceKey | varchar | 512 | √ | null | ||
new_s_all_luns_periodic | svmResourceKey | varchar | 512 | √ | null | ||
new_s_all_namespaces_periodic | svmResourceKey | varchar | 512 | √ | null | ||
new_s_all_volumes_periodic | svmResourceKey | varchar | 512 | √ | null | ||
s_all_lifs_periodic | svmResourceKey | varchar | 512 | √ | null | ||
s_all_luns_periodic | svmResourceKey | varchar | 512 | √ | null | ||
s_all_namespaces_periodic | svmResourceKey | varchar | 512 | √ | null | ||
s_all_volumes_periodic | svmResourceKey | varchar | 512 | √ | null | ||
workload_view | targetLatency | float | 12 | √ | null | ||
active_directory | tenant_id | bigint | 19 | √ | null | ||
continuous_event_participant | thresholdAnalysisRole | smallint | 5 | √ | null | ||
new_s_all_aggregates_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_clusters_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_lifs_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_luns_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_namespaces_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_nodes_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_ports_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_svms_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_volumes_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_aggregates_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_clusters_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_lifs_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_luns_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_namespaces_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_nodes_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_ports_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_svms_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
s_all_volumes_periodic | thresholdPolicyId | varchar | 512 | √ | null | ||
new_s_all_aggregates_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_clusters_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_lifs_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_luns_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_namespaces_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_nodes_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_ports_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_svms_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_volumes_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_aggregates_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_clusters_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_lifs_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_luns_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_namespaces_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_nodes_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_ports_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_svms_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
s_all_volumes_periodic | thresholdPolicyName | text | 65535 | √ | null | ||
new_s_all_aggregates_periodic | throughput | float | 12 | √ | null | ||
new_s_all_clusters_periodic | throughput | float | 12 | √ | null | ||
new_s_all_lifs_periodic | throughput | float | 12 | √ | null | ||
new_s_all_luns_periodic | throughput | float | 12 | √ | null | ||
new_s_all_namespaces_periodic | throughput | float | 12 | √ | null | ||
new_s_all_nodes_periodic | throughput | float | 12 | √ | null | ||
new_s_all_ports_periodic | throughput | float | 12 | √ | null | ||
s_all_aggregates_periodic | throughput | float | 12 | √ | null | ||
s_all_clusters_periodic | throughput | float | 12 | √ | null | ||
s_all_lifs_periodic | throughput | float | 12 | √ | null | ||
s_all_luns_periodic | throughput | float | 12 | √ | null | ||
s_all_namespaces_periodic | throughput | float | 12 | √ | null | ||
s_all_nodes_periodic | throughput | float | 12 | √ | null | ||
s_all_ports_periodic | throughput | float | 12 | √ | null | ||
new_s_all_volumes_periodic | tieringPolicy | text | 65535 | √ | null | ||
s_all_volumes_periodic | tieringPolicy | text | 65535 | √ | null | ||
new_s_all_aggregates_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_clusters_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_luns_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_nodes_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_svms_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_volumes_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_aggregates_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_clusters_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_luns_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_namespaces_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_nodes_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_svms_periodic | totalCapacity | bigint | 19 | √ | null | ||
s_all_volumes_periodic | totalCapacity | bigint | 19 | √ | null | ||
new_s_all_lifs_periodic | type | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | type | varchar | 255 | √ | null | ||
s_all_lifs_periodic | type | varchar | 255 | √ | null | ||
s_all_ports_periodic | type | varchar | 255 | √ | null | ||
stat_type_definition | unit | varchar | 225 | √ | null | ||
continuous_event_participant_stats | upperThreshold | float | 12 | √ | null | ||
storage_service_level_view | usedCapacity | decimal | 41 | √ | null | ||
new_s_all_aggregates_periodic | usedHeadroom | float | 12 | √ | null | ||
new_s_all_nodes_periodic | usedHeadroom | float | 12 | √ | null | ||
s_all_aggregates_periodic | usedHeadroom | float | 12 | √ | null | ||
s_all_nodes_periodic | usedHeadroom | float | 12 | √ | null | ||
new_s_all_ports_periodic | utilization | float | 12 | √ | null | ||
s_all_ports_periodic | utilization | float | 12 | √ | null | ||
new_s_all_clusters_periodic | version | varchar | 255 | √ | null | ||
s_all_clusters_periodic | version | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | volumeId | bigint | 19 | √ | null | ||
new_s_all_namespaces_periodic | volumeId | bigint | 19 | √ | null | ||
s_all_luns_periodic | volumeId | bigint | 19 | √ | null | ||
s_all_namespaces_periodic | volumeId | bigint | 19 | √ | null | ||
coherence_workload | volumeKey | varchar | 255 | √ | null | volume resource key | |
coherence_workload | volumeName | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | volumeName | varchar | 255 | √ | null | ||
new_s_all_namespaces_periodic | volumeName | varchar | 255 | √ | null | ||
s_all_luns_periodic | volumeName | varchar | 255 | √ | null | ||
s_all_namespaces_periodic | volumeName | varchar | 255 | √ | null | ||
new_s_all_luns_periodic | volumeResourceKey | varchar | 512 | √ | null | ||
new_s_all_namespaces_periodic | volumeResourceKey | varchar | 512 | √ | null | ||
s_all_luns_periodic | volumeResourceKey | varchar | 512 | √ | null | ||
s_all_namespaces_periodic | volumeResourceKey | varchar | 512 | √ | null | ||
new_s_all_qospolicygroups_periodic | vserverId | bigint | 19 | √ | null | ||
s_all_qospolicygroups_periodic | vserverId | bigint | 19 | √ | null | ||
new_s_all_qospolicygroups_periodic | vserverName | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | vserverName | varchar | 255 | √ | null | ||
new_s_all_qospolicygroups_periodic | vserverResourceKey | varchar | 512 | √ | null | ||
s_all_qospolicygroups_periodic | vserverResourceKey | varchar | 512 | √ | null | ||
workload_view | workloadAggregateName | varchar | 255 | √ | null | ||
workload_view | workloadAggregateUuid | varchar | 255 | √ | null | ||
workload_view | workloadCapacity | bigint | 19 | √ | null | ||
workload_view | workloadCapacityUsed | bigint | 19 | √ | null | ||
budget_summary | workloadCount | bigint | 19 | √ | null | ||
workload_provision_mapping | workloadId | bigint | 19 | √ | null | ||
workload_provision_mapping | workloadKey | varchar | 255 | √ | null | ||
workload_view | workloadKey | varchar | 255 | √ | null | ||
workload_view | workloadName | varchar | 255 | √ | null | ||
workload_view | workloadSvmKey | varchar | 512 | √ | null | ||
workload_view | workloadSvmName | varchar | 255 | √ | null | ||
workload_provision_mapping | workloadType | smallint | 5 | √ | null | ||
workload_view | workloadVolumeKey | varchar | 255 | √ | null | ||
workload_view | workloadVolumeName | varchar | 255 | √ | null | ||
forecast | writeData | blob | 65535 | √ | null | ||
node_seed_iops | writeSataSasIops | bigint | 19 | √ | null | ||
node_seed_iops | writeSsdIops | bigint | 19 | √ | null | ||
storage_service_level | absoluteMinIops | bigint | 19 | 100 | Indicates the minimum IOPS value for a performance policy. | ||
storage_service_level_view | absoluteMinIops | bigint | 19 | 100 | Indicates the minimum IOPS value for a performance policy. | ||
resource_budgets | aggregateId | bigint | 19 | ||||
resource_budgets | apiRequestType | enum | 6 | Type of REST API operation. | |||
change_event_attribute | attribute | varchar | 255 | Name of the attribute that was updated | |||
disk_seed_iops | avgLatencyMillis | float | 12 | ||||
event_to_declare_bp | category | enum | 17 | The category of this event HARDWARE_FAILURE or BACKGROUND | |||
change_event_attribute | changeEventId | bigint | 19 | References to ID of change_event table | |||
change_event_workload | changeEventId | bigint | 19 | References to ID of change_event table | |||
polling_interval_history | changeTime | bigint | 19 | ||||
coherence_change_record | changeType | enum | 7 | ||||
change_event | changeTypeId | smallint | 5 | Type ID of change, references to opm.change_type_definition table | |||
capacity_tier_analysis | cloudRecommendation | enum | 46 | LEARNING | |||
acquisition_info | clusterId | bigint | 19 | ||||
change_event | clusterId | bigint | 19 | Id of the cluster for which this update was made | |||
coherence_change_record | clusterId | bigint | 19 | ||||
coherence_workload | clusterId | bigint | 19 | ||||
resource_budgets | clusterId | bigint | 19 | ||||
resource_capability_stats | clusterId | bigint | 19 | ||||
workload_provision_mapping | clusterId | bigint | 19 | ||||
provisioning_policy | compression | enum | 10 | INLINE | Specifies whether or not and what type of compression to be applied on the provisioned data. | ||
provisioning_policy_view | compression | enum | 10 | INLINE | Specifies whether or not and what type of compression to be applied on the provisioned data. | ||
workload_view | conformanceStatus | int | 10 | 0 | |||
continuous_event_participant | contentionAnalysisRole | smallint | 5 | ||||
conformance_policy | createTime | bigint | 19 | ||||
provisioning_policy | createTime | bigint | 19 | ||||
provisioning_policy_view | createTime | bigint | 19 | ||||
resource_budgets | createTime | bigint | 19 | ||||
storage_service_level | createTime | bigint | 19 | ||||
storage_service_level_view | createTime | bigint | 19 | ||||
ext_data_config | dataFormat | enum | 9 | GRAPHITE | |||
ext_data_config | dataTransmission | enum | 7 | ENABLE | |||
provisioning_policy | deduplication | enum | 10 | INLINE | Specifies whether or not and what type of deduplication to be applied on the provisioned data. | ||
provisioning_policy_view | deduplication | enum | 10 | INLINE | Specifies whether or not and what type of deduplication to be applied on the provisioned data. | ||
new_s_all_volumes_periodic | derivedStyle | enum | 11 | ||||
s_all_volumes_periodic | derivedStyle | enum | 11 | ||||
bp_event | description | varchar | 512 | The discription of this blackout period event | |||
disk_seed_iops | disk | varchar | 128 | ||||
active_directory | dns | varchar | 512 | ||||
active_directory | domain | varchar | 512 | ||||
threshold | duration | smallint | 5 | ||||
upgrade_history | duration | bigint | 19 | ||||
threshold | elementType | smallint | 5 | ||||
threshold_policy | elementType | smallint | 5 | Supported element types: 0=Cluster 1=SVM (Storage Virtual Machine, formerly Vserver) 2=Node 3=Aggregate 4=Volume 5=LUN 6=LIF 7=FC Port 8=Network Port |
|||
threshold_policy_mapping | elementType | smallint | 5 | ||||
threshold_policy | enabled | bit | 1 | A flag to enable and disable a threshold Policy | |||
event_to_declare_bp | endBy | enum | 9 | Describes how this event ends other event | |||
bp_event | eventCategory | enum | 17 | BACKGROUND | The category of the blackout event | ||
continuous_event_participant_stats | eventParticipantId | bigint | 19 | ||||
event_to_declare_bp | eventType | varchar | 128 | The name of the event type defined in ocum.eventtype | |||
storage_service_level | expectedIopsPerTB | bigint | 19 | Specifies the minimum expected IOPS allocated based on the storage object allocated size. | |||
storage_service_level_view | expectedIopsPerTB | bigint | 19 | Specifies the minimum expected IOPS allocated based on the storage object allocated size. | |||
shadow_table_trail | expiryTime | bigint | 19 | ||||
upgrade_history | fromMaintenance | int | 10 | ||||
upgrade_history | fromMajor | int | 10 | ||||
upgrade_history | fromMinor | int | 10 | ||||
upgrade_history | fromPatch | int | 10 | ||||
threshold_policy | hidden | bit | 1 | ||||
ext_server_config | host | varchar | 128 | ||||
active_directory | id | bigint | 19 | √ | |||
bp_event | id | bigint | 19 | √ | |||
budget_summary | id | bigint | 19 | √ | |||
capacity_tier_analysis | id | bigint | 19 | √ | |||
change_event | id | bigint | 19 | √ | |||
change_type_definition | id | smallint | 5 | OPM defined ID for the change type | |||
coherence_change_record | id | bigint | 19 | √ | |||
coherence_workload | id | bigint | 19 | √ | |||
config | id | int | 10 | √ | |||
conformance_policy | id | bigint | 19 | √ | |||
contention_analysis_role_definition | id | smallint | 5 | OPM defined ID for Contention Analysis Role | |||
continuous_event_participant | id | bigint | 19 | √ | |||
continuous_event_participant_stats | id | bigint | 19 | √ | |||
disk_seed_iops | id | bigint | 19 | √ | |||
dyn_state_definition | id | smallint | 5 | OPM defined ID for dynamic state definition | |||
element_type_definition | id | smallint | 5 | OPM defined ID for the element type | |||
event_to_declare_bp | id | bigint | 19 | √ | |||
ext_data_config | id | int | 10 | √ | |||
ext_server_config | id | int | 10 | √ | |||
forecast | id | bigint | 19 | √ | |||
node_seed_iops | id | bigint | 19 | √ | |||
notification_dynamic_event_option_definition | id | smallint | 5 | OPM defined ID for notification dynamic event option definition | |||
notification_level_definition | id | smallint | 5 | OPM Notification Levels | |||
notification_scope_definition | id | smallint | 5 | OPM defined ID for notification scope definition | |||
notification_type_definition | id | smallint | 5 | OPM defined ID for notification type definition | |||
notification_umevent_definition | id | smallint | 5 | OPM defined ID for UM event type definition | |||
provisioning_policy | id | bigint | 19 | √ | |||
provisioning_policy_view | id | bigint | 19 | 0 | |||
resource_budgets | id | bigint | 19 | √ | |||
resource_capability_stats | id | bigint | 19 | √ | |||
stat_type_definition | id | smallint | 5 | ||||
storage_service_level | id | bigint | 19 | √ | |||
storage_service_level_view | id | bigint | 19 | 0 | |||
target_type_definition | id | smallint | 5 | OPM defined ID for target type | |||
tenant | id | bigint | 19 | √ | |||
threshold | id | bigint | 19 | √ | |||
threshold_policy | id | bigint | 19 | √ | |||
threshold_policy_mapping | id | bigint | 19 | √ | |||
threshold_policy_type_definition | id | smallint | 5 | UM defined ID for the threshold policy type | |||
upgrade_history | id | bigint | 19 | √ | |||
version | id | bigint | 19 | √ | |||
workload_provision_mapping | id | bigint | 19 | √ | |||
workload_view | id | bigint | 19 | 0 | |||
node_seed_iops | ioBlockSize | enum | 8 | ||||
disk_seed_iops | iops | int | 10 | seed IOPS, 4K block size | |||
conformance_policy | iopsCapacityBufferInTB | float | 12 | Capacity buffer in TB used to calculate expected IOPS value. | |||
conformance_policy | iopsCapacityStepInTB | float | 12 | Capacity step in TB used to calculate current IOPS value. | |||
conformance_policy | iopsIncidentThresholdPercent | smallint | 5 | If the percentage of non-conforming samples w.r.t. total samples in a given observation_window exceeds this threshold, a incident event is raised. | |||
conformance_policy | iopsObservationWindow | smallint | 5 | The window size (in minutes) defines the time period from the current time within which all the relevant samples are analyzed for identifying any risk and incident resulting from conformance violations. | |||
conformance_policy | iopsRiskThresholdPercent | smallint | 5 | If the percentage of non-conforming samples w.r.t. total samples in a given observation_window exceeds this threshold, a risk event is raised. | |||
continuous_event_participant | isPrimaryThreshold | bit | 0 | 0 | |||
resource_budgets | isRecommendedAssignment | bit | 0 | 0 | |||
coherence_workload | key | varchar | 255 | workload resource key | |||
continuous_event_participant | lastObservedTime | bigint | 19 | 0 | |||
conformance_policy | latencyIncidentThresholdPercent | smallint | 5 | If the percentage of non-conforming samples w.r.t. total samples in a given observation_window exceeds this threshold, a incident event is raised. | |||
conformance_policy | latencyObservationWindow | smallint | 5 | The window size (in minutes) defines the time period from the current time within which all the relevant samples are analyzed for identifying any risk and incident resulting from conformance violations. | |||
conformance_policy | latencyRiskThresholdPercent | smallint | 5 | If the percentage of non-conforming samples w.r.t. total samples in a given observation_window exceeds this threshold, a risk event is raised. | |||
version | maintenance | int | 10 | ||||
version | major | int | 10 | ||||
workload_view | matchedWithSuggestedSsl | int | 10 | 0 | |||
stat_type_definition | max | int | 10 | 0 | |||
node_seed_iops | memorySizeGB | int | 10 | ||||
stat_type_definition | min | smallint | 5 | 0 | |||
version | minor | int | 10 | ||||
node_seed_iops | model | varchar | 128 | ||||
config | name | varchar | 128 | ||||
conformance_policy | name | varchar | 255 | Name of the conformance policy. | |||
tenant | name | varchar | 255 | ||||
threshold_policy | name | varchar | 128 | ||||
resource_budgets | nodeId | bigint | 19 | ||||
node_seed_iops | numOfCores | int | 10 | ||||
capacity_tier_analysis | objectId | bigint | 19 | ||||
threshold_policy_mapping | objectId | bigint | 19 | ||||
capacity_tier_analysis | objectName | varchar | 225 | ||||
change_event | objectTypeId | smallint | 5 | Type ID of change, references to opm.element_type_definition table | |||
change_event | objId | bigint | 19 | Id of the object that was updated | |||
forecast | objId | bigint | 19 | ||||
new_s_all_aggregates_periodic | objid | bigint | 19 | 0 | |||
new_s_all_clusters_periodic | objid | bigint | 19 | 0 | |||
new_s_all_lifs_periodic | objid | bigint | 19 | 0 | |||
new_s_all_luns_periodic | objid | bigint | 19 | 0 | |||
new_s_all_namespaces_periodic | objid | bigint | 19 | 0 | |||
new_s_all_nodes_periodic | objid | bigint | 19 | 0 | |||
new_s_all_ports_periodic | objid | bigint | 19 | 0 | |||
new_s_all_qospolicygroups_periodic | objid | bigint | 19 | 0 | |||
new_s_all_svms_periodic | objid | bigint | 19 | 0 | |||
new_s_all_volumes_periodic | objid | bigint | 19 | 0 | |||
s_all_aggregates_periodic | objid | bigint | 19 | 0 | |||
s_all_clusters_periodic | objid | bigint | 19 | 0 | |||
s_all_lifs_periodic | objid | bigint | 19 | 0 | |||
s_all_luns_periodic | objid | bigint | 19 | 0 | |||
s_all_namespaces_periodic | objid | bigint | 19 | 0 | |||
s_all_nodes_periodic | objid | bigint | 19 | 0 | |||
s_all_ports_periodic | objid | bigint | 19 | 0 | |||
s_all_qospolicygroups_periodic | objid | bigint | 19 | 0 | |||
s_all_svms_periodic | objid | bigint | 19 | 0 | |||
s_all_volumes_periodic | objid | bigint | 19 | 0 | |||
coherence_change_record | objName | varchar | 255 | ||||
coherence_change_record | objType | smallint | 5 | ||||
coherence_workload | objType | smallint | 5 | ||||
forecast | objType | enum | 20 | QOS_VOLUME_WORKLOAD | |||
continuous_event_participant | occurrenceId | bigint | 19 | ||||
threshold | operation | bit | 0 | Indicates if it should be a greater than, a less than or equal to operationn0=equals 1=greaterthan 2=less |
|||
budget_summary | operationType | enum | 10 | Specifies whether the budgeted iops is reclaimed or consumed | |||
coherence_change_record | parentName | varchar | 255 | parent object name | |||
continuous_event_participant | participantId | bigint | 19 | 0 | |||
continuous_event_participant | participantType | smallint | 5 | ||||
active_directory | password | varchar | 512 | ||||
version | patch | int | 10 | ||||
storage_service_level | peakIopsAllocationPolicy | enum | 15 | Indicates peak IOPS allocation policy. | |||
storage_service_level_view | peakIopsAllocationPolicy | enum | 15 | Indicates peak IOPS allocation policy. | |||
storage_service_level | peakIopsPerTB | bigint | 19 | Specifies the maximum possible IOPS per TB allocated based on the storage object used size. | |||
storage_service_level_view | peakIopsPerTB | bigint | 19 | Specifies the maximum possible IOPS per TB allocated based on the storage object used size. | |||
threshold | policyId | bigint | 19 | ||||
threshold_policy_mapping | policyId | bigint | 19 | ||||
polling_interval_history | pollInterval | tinyint | 3 | ||||
ext_server_config | port | int | 10 | ||||
event_to_declare_bp | purpose | enum | 9 | The purpose of this event for STARTING or ENDING blackout period | |||
budget_summary | reportDate | date | 10 | ||||
capacity_tier_analysis | resourceKey | varchar | 512 | ||||
bp_event | resourceObjId | bigint | 19 | The object id that this bp event associated with | |||
bp_event | resourceType | smallint | 5 | The object type that this bp event associated with referencing opm.element_type_definition | |||
capacity_tier_analysis | resourceType | smallint | 5 | ||||
ext_data_config | serverId | int | 10 | ||||
threshold | severityLevel | smallint | 5 | ||||
shadow_table_trail | shadowTableName | varchar | 255 | ||||
coherence_workload | size | bigint | 19 | ||||
disk_seed_iops | sizeTB | float | 12 | ||||
provisioning_policy | spaceThinProvisioned | bit | 0 | Specifies whether to use thin-provisioning for storage items. | |||
provisioning_policy_view | spaceThinProvisioned | bit | 0 | Specifies whether to use thin-provisioning for storage items. | |||
bp_event | startTime | bigint | 19 | The starting time of the bp event | |||
continuous_event_participant | startTime | bigint | 19 | 0 | |||
threshold_policy_mapping | startTime | bigint | 19 | ||||
upgrade_history | startTime | bigint | 19 | ||||
ext_data_config | statGroup | enum | 22 | ||||
continuous_event_participant_stats | statType | smallint | 5 | ||||
threshold | statType | smallint | 5 | Supported counter types: Cluster Total IOPS Total MB/sec SVM Average Latency Total IOPS Total MB/sec Average NFS Latency Total NFS IOPS Total NFS MB/sec Average CIFS Latency Total CIFS IOPS Total CIFS MB/sec Average iSCSI Latency Total iSCSI IOPS Total iSCSI MB/sec Average FCP Latency Total FCP IOPS Total FCP MB, sec Node Average Latency Total IOPS Total MB/sec % CPU Utilization Aggregate Average Latency Total IOPS Total MB/sec Average % Disk Utilization Average Queue Length Volume Average Latency Total IOPS Total MB/sec % Cache Hit Ratio LUN Average Latency Total IOPS Total MB/sec LIF Total MB/sec Port % Bandwidth Utilization Total Errors/min Total Data/sec |
|||
coherence_change_record | status | enum | 12 | ||||
workload_provision_mapping | storageServiceLevelStatus | enum | 45 | IDLE | |||
workload_view | storageServiceLevelStatus | enum | 45 | IDLE | |||
acquisition_info | success | bit | 0 | 0 | |||
conformance_policy | systemDefined | bit | 0 | 0 | Indicates if this is a system-provided conformance policy. | ||
provisioning_policy | systemDefined | bit | 0 | 0 | Indicates if this is a system-provided provisioningg policy. | ||
provisioning_policy_view | systemDefined | bit | 0 | 0 | Indicates if this is a system-provided provisioningg policy. | ||
storage_service_level | systemDefined | bit | 0 | 0 | Indicates if this is a system-provided performance policy. | ||
storage_service_level_view | systemDefined | bit | 0 | 0 | Indicates if this is a system-provided performance policy. | ||
acquisition_info | time | bigint | 19 | ||||
continuous_event_participant_stats | time | bigint | 19 | ||||
forecast | time | bigint | 19 | ||||
capacity_tier_analysis | timestamp | bigint | 19 | 0 | |||
upgrade_history | toMaintenance | int | 10 | ||||
upgrade_history | toMajor | int | 10 | ||||
upgrade_history | toMinor | int | 10 | ||||
upgrade_history | toPatch | int | 10 | ||||
ext_data_config | transmitInterval | smallint | 5 | 5 | |||
bp_event | type | enum | 13 | UM_EVENT | The type of the blackout event source type | ||
change_type_definition | type | varchar | 255 | Change type name. | |||
contention_analysis_role_definition | type | varchar | 255 | Contention Analysis Role Name | |||
disk_seed_iops | type | enum | 6 | ||||
dyn_state_definition | type | varchar | 255 | Dyn state name | |||
element_type_definition | type | varchar | 255 | Element type name. | |||
notification_dynamic_event_option_definition | type | varchar | 255 | notification dynamic event option type | |||
notification_level_definition | type | varchar | 255 | notification name | |||
notification_scope_definition | type | varchar | 255 | scope type | |||
notification_type_definition | type | varchar | 255 | notification type | |||
notification_umevent_definition | type | varchar | 255 | UM Event type | |||
stat_type_definition | type | varchar | 225 | ||||
target_type_definition | type | varchar | 255 | Target Type name | |||
threshold | type | smallint | 5 | 0=Primary 1=Secondary |
|||
threshold_policy | type | smallint | 5 | ||||
threshold_policy_type_definition | type | varchar | 255 | Threshold policy type name | |||
event_to_declare_bp | uniqueName | varchar | 255 | The name of the event type value defined in ocum.eventtypevalue | |||
change_event | updateTime | bigint | 19 | The time that the change was made | |||
coherence_change_record | updateTime | timestamp | 19 | CURRENT_TIMESTAMP | |||
conformance_policy | updateTime | bigint | 19 | ||||
provisioning_policy | updateTime | bigint | 19 | ||||
provisioning_policy_view | updateTime | bigint | 19 | ||||
storage_service_level | updateTime | bigint | 19 | ||||
storage_service_level_view | updateTime | bigint | 19 | ||||
disk_seed_iops | usableSizeTB | float | 12 | ||||
active_directory | username | varchar | 512 | ||||
active_directory | uuid | varchar | 512 | ||||
conformance_policy | uuid | varchar | 512 | ||||
provisioning_policy | uuid | varchar | 512 | ||||
provisioning_policy_view | uuid | varchar | 512 | ||||
storage_service_level | uuid | varchar | 512 | ||||
storage_service_level_view | uuid | varchar | 512 | ||||
tenant | uuid | varchar | 512 | ||||
config | value | varchar | 32 | ||||
ext_data_config | vendorTag | varchar | 128 | netapp-performance | |||
provisioning_policy_view | workloadCount | bigint | 19 | 0 | |||
storage_service_level_view | workloadCount | bigint | 19 | 0 | |||
change_event_workload | workloadId | bigint | 19 | Workload ID associated to the change. example, volumeId, clusterid, etc. | |||
resource_budgets | workloadId | bigint | 19 | ||||
workload_view | workloadType | int | 10 | 0 | |||
change_event_workload | workloadTypeId | smallint | 5 | Type ID of change, references to opm.element_type_definition table |