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 |
---|---|---|---|---|---|---|---|
acquisition_info | collectionDuration | bigint | 19 | √ | -1 | ||
workload_view | conformanceStatus | int | 10 | 0 | |||
provisioning_policy_view | id | bigint | 19 | 0 | |||
storage_service_level_view | id | bigint | 19 | 0 | |||
workload_view | id | bigint | 19 | 0 | |||
acquisition_info | isHistorical | bit | 0 | √ | 0 | flag showing the collection is normal or historical. | |
continuous_event_participant | isPrimaryThreshold | bit | 0 | 0 | |||
resource_budgets | isRecommendedAssignment | bit | 0 | 0 | |||
continuous_event_participant | lastObservedTime | bigint | 19 | 0 | |||
workload_view | matchedWithSuggestedSsl | int | 10 | 0 | |||
stat_type_definition | max | int | 10 | 0 | |||
stat_type_definition | min | smallint | 5 | 0 | |||
acquisition_info | msgRcvTime | bigint | 19 | √ | 0 | ||
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 | |||
continuous_event_participant | participantId | bigint | 19 | 0 | |||
continuous_event_participant | startTime | bigint | 19 | 0 | |||
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. | ||
capacity_tier_analysis | timestamp | bigint | 19 | 0 | |||
provisioning_policy_view | workloadCount | bigint | 19 | 0 | |||
storage_service_level_view | workloadCount | bigint | 19 | 0 | |||
workload_view | workloadType | int | 10 | 0 | |||
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. | ||
workload_view | assignedAbsoluteMinIops | bigint | 19 | √ | 100 | Indicates the minimum IOPS value for a performance policy. | |
threshold | breachPercent | tinyint | 3 | √ | 100 | breachPercent is the percent value which has to be less or equal to 100 | |
workload_view | suggestedAbsoluteMinIops | bigint | 19 | √ | 100 | Indicates the minimum IOPS value for a performance policy. | |
acquisition_info | analysisDuration | bigint | 19 | √ | 300000 | ||
ext_data_config | transmitInterval | smallint | 5 | 5 | |||
coherence_change_record | isMappedObjInCoherence | bit | 1 | √ | b'1' | 1 means the mapped object is in this table, 0 means it is in netapp_model | |
bp_event | eventCategory | enum | 17 | BACKGROUND | The category of the blackout event | ||
coherence_change_record | updateTime | timestamp | 19 | CURRENT_TIMESTAMP | |||
ext_data_config | dataTransmission | enum | 7 | ENABLE | |||
tenant | status | enum | 8 | √ | ENABLED | ||
ext_data_config | dataFormat | enum | 9 | GRAPHITE | |||
workload_provision_mapping | storageServiceLevelStatus | enum | 45 | IDLE | |||
workload_view | storageServiceLevelStatus | enum | 45 | IDLE | |||
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. | ||
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. | ||
capacity_tier_analysis | cloudRecommendation | enum | 46 | LEARNING | |||
new_s_all_volumes_periodic | cloudRecommendation | varchar | 255 | √ | LEARNING | ||
s_all_volumes_periodic | cloudRecommendation | varchar | 255 | √ | LEARNING | ||
ext_data_config | vendorTag | varchar | 128 | netapp-performance | |||
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 | ||
resource_budgets | aggregateId | bigint | 19 | ||||
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 | ||
continuous_event_participant | analysisId | bigint | 19 | √ | null | ||
resource_budgets | apiRequestType | enum | 6 | Type of REST API operation. | |||
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 | ||
change_event_attribute | attribute | varchar | 255 | Name of the attribute that was updated | |||
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 | ||
disk_seed_iops | avgLatencyMillis | float | 12 | ||||
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 | ||
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 | ||
event_to_declare_bp | category | enum | 17 | The category of this event HARDWARE_FAILURE or BACKGROUND | |||
budget_summary | changed_iops | float | 12 | √ | null | ||
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 | |||
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 | ||
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 | ||||
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 | ||
resource_budgets | clusterId | bigint | 19 | ||||
resource_capability_stats | clusterId | bigint | 19 | ||||
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_provision_mapping | clusterId | bigint | 19 | ||||
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 | |
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. | |
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 | ||||
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 | ||
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 | |||
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 | ||
disk_seed_iops | disk | varchar | 128 | ||||
new_s_all_volumes_periodic | diskType | varchar | 255 | √ | null | ||
s_all_volumes_periodic | diskType | varchar | 255 | √ | null | ||
active_directory | dns | varchar | 512 | ||||
active_directory | domain | varchar | 512 | ||||
threshold | duration | smallint | 5 | ||||
upgrade_history | duration | bigint | 19 | ||||
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 | ||
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 | ||||
workload_view | elementType | smallint | 5 | √ | null | ||
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 | 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 | ||
continuous_event_participant_stats | eventParticipantId | bigint | 19 | ||||
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 | ||
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. | |||
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 | ||
shadow_table_trail | expiryTime | bigint | 19 | ||||
node_seed_iops | flashCacheSizeGB | int | 10 | √ | null | ||
continuous_event_participant_stats | forecastStatisticValue | float | 12 | √ | null | ||
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 | ||
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 | ||||
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 | ||
ext_server_config | host | varchar | 128 | ||||
node_seed_iops | hybridSsdSizeGB | int | 10 | √ | null | ||
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 | id | bigint | 19 | √ | null | ||
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 | √ | |||
resource_budgets | id | bigint | 19 | √ | |||
resource_capability_stats | id | bigint | 19 | √ | |||
stat_type_definition | id | smallint | 5 | ||||
storage_service_level | id | bigint | 19 | √ | |||
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 | √ | |||
node_seed_iops | ioBlockSize | enum | 8 | ||||
disk_seed_iops | iops | int | 10 | seed IOPS, 4K block size | |||
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 | ||
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. | |||
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 | |
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. | |||
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 | ||
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. | |||
resource_capability_stats | iopsSeed | bigint | 19 | √ | null | ||
new_s_all_qospolicygroups_periodic | isAdaptive | bit | 0 | √ | null | ||
s_all_qospolicygroups_periodic | isAdaptive | bit | 0 | √ | null | ||
new_s_all_aggregates_periodic | isInactiveDataReportingEnabled | varchar | 255 | √ | null | ||
s_all_aggregates_periodic | isInactiveDataReportingEnabled | varchar | 255 | √ | null | ||
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 | ||
coherence_workload | key | varchar | 255 | workload resource key | |||
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 | |
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. | |||
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. | |
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. | |||
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 | ||
version | maintenance | int | 10 | ||||
version | major | int | 10 | ||||
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 | ||
node_seed_iops | memorySizeGB | int | 10 | ||||
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 | ||
version | minor | int | 10 | ||||
new_s_all_qospolicygroups_periodic | minThroughput | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | minThroughput | varchar | 255 | √ | null | ||
node_seed_iops | model | varchar | 128 | ||||
coherence_workload | name | varchar | 255 | √ | null | ||
config | name | varchar | 128 | ||||
conformance_policy | name | varchar | 255 | Name of the conformance policy. | |||
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 | ||
tenant | name | varchar | 255 | ||||
threshold | name | varchar | 128 | √ | null | ||
threshold_policy | name | varchar | 128 | ||||
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 | ||
resource_budgets | nodeId | bigint | 19 | ||||
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 | ||
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 | ||||
coherence_change_record | objKey | varchar | 255 | √ | null | object resource key | |
coherence_change_record | objName | varchar | 255 | ||||
coherence_change_record | objType | smallint | 5 | ||||
coherence_workload | objType | smallint | 5 | ||||
continuous_event_participant | occurrenceId | bigint | 19 | ||||
change_event_attribute | oldValue | varchar | 255 | √ | null | Attribute value before the update | |
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 | |||
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 | ||
coherence_change_record | parentName | varchar | 255 | parent object name | |||
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. | |||
new_s_all_qospolicygroups_periodic | policyGroupClass | varchar | 255 | √ | null | ||
s_all_qospolicygroups_periodic | policyGroupClass | varchar | 255 | √ | null | ||
threshold | policyId | bigint | 19 | ||||
threshold_policy_mapping | policyId | bigint | 19 | ||||
polling_interval_history | pollInterval | tinyint | 3 | ||||
ext_server_config | port | int | 10 | ||||
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 | ||
event_to_declare_bp | purpose | enum | 9 | The purpose of this event for STARTING or ENDING blackout period | |||
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 | ||
budget_summary | reportDate | date | 10 | ||||
resource_capability_stats | resourceId | bigint | 19 | √ | null | ||
capacity_tier_analysis | resourceKey | varchar | 512 | ||||
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 | ||
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 | ||||
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 | ||
ext_data_config | serverId | int | 10 | ||||
threshold | severityLevel | smallint | 5 | ||||
threshold | severityValue | decimal | 15,3 | √ | null | ||
shadow_table_trail | shadowTableName | varchar | 255 | ||||
coherence_workload | size | bigint | 19 | ||||
disk_seed_iops | sizeTB | float | 12 | ||||
bp_event | sourceEventId | bigint | 19 | √ | null | Id of UM event that causes this blackout period | |
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. | |||
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 | ||
bp_event | startTime | bigint | 19 | The starting time of the bp event | |||
threshold_policy_mapping | startTime | bigint | 19 | ||||
upgrade_history | startTime | bigint | 19 | ||||
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 | ||
ext_data_config | statGroup | enum | 22 | ||||
resource_capability_stats | statStartTime | bigint | 19 | √ | null | ||
workload_provision_mapping | statStartTime | bigint | 19 | √ | null | ||
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 | 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 | 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 | ||
acquisition_info | time | bigint | 19 | ||||
continuous_event_participant_stats | time | bigint | 19 | ||||
forecast | time | bigint | 19 | ||||
upgrade_history | toMaintenance | int | 10 | ||||
upgrade_history | toMajor | int | 10 | ||||
upgrade_history | toMinor | int | 10 | ||||
upgrade_history | toPatch | int | 10 | ||||
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 | ||
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. | |||
new_s_all_lifs_periodic | type | varchar | 255 | √ | null | ||
new_s_all_ports_periodic | type | varchar | 255 | √ | null | ||
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 | |||
s_all_lifs_periodic | type | varchar | 255 | √ | null | ||
s_all_ports_periodic | type | varchar | 255 | √ | null | ||
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 | |||
stat_type_definition | unit | varchar | 225 | √ | null | ||
change_event | updateTime | bigint | 19 | The time that the change was made | |||
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 | ||||
continuous_event_participant_stats | upperThreshold | float | 12 | √ | null | ||
disk_seed_iops | usableSizeTB | float | 12 | ||||
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 | ||
active_directory | username | varchar | 512 | ||||
new_s_all_ports_periodic | utilization | float | 12 | √ | null | ||
s_all_ports_periodic | utilization | float | 12 | √ | null | ||
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 | ||||
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 | ||
change_event_workload | workloadId | bigint | 19 | Workload ID associated to the change. example, volumeId, clusterid, etc. | |||
resource_budgets | workloadId | bigint | 19 | ||||
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 | ||
change_event_workload | workloadTypeId | smallint | 5 | Type ID of change, references to opm.element_type_definition table | |||
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 | ||
forecast | objType | enum | 20 | QOS_VOLUME_WORKLOAD | |||
forecast | forecastType | enum | 6 | √ | SIGMA | ||
bp_event | type | enum | 13 | UM_EVENT | The type of the blackout event source type |