SchemaSpy Analysis of opm - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Apr 23 04:58 EDT 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

opm contains 903 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
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.
continuous_event_participant actualTargetId bigint 19  √  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
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 assignedExpectedIopsPerTB bigint 19  √  null Specifies the minimum expected IOPS allocated based on the storage object allocated size.
workload_view assignedPeakIopsPerTB bigint 19  √  null Specifies the maximum possible IOPS per TB allocated based on the storage object used size.
new_s_all_qospolicygroups_periodic associatedObjectCount bigint 19  √  null
s_all_qospolicygroups_periodic associatedObjectCount bigint 19  √  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
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
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
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 currentNodeId bigint 19  √  null
s_all_lifs_periodic currentNodeId bigint 19  √  null
new_s_all_lifs_periodic currentPortId bigint 19  √  null
s_all_lifs_periodic currentPortId bigint 19  √  null
threshold_policy deleteTime bigint 19  √  null
upgrade_history duration bigint 19
bp_event endTime bigint 19  √  null The end time of the bp event
threshold_policy_mapping endTime bigint 19  √  null
continuous_event_participant_stats eventParticipantId bigint 19
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
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 homeNodeId bigint 19  √  null
s_all_lifs_periodic homeNodeId bigint 19  √  null
new_s_all_lifs_periodic homePortId bigint 19  √  null
s_all_lifs_periodic homePortId bigint 19  √  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  √ 
coherence_change_record id bigint 19  √ 
coherence_workload id bigint 19  √ 
conformance_policy id bigint 19  √ 
continuous_event_participant id bigint 19  √ 
continuous_event_participant_stats id bigint 19  √ 
disk_seed_iops id bigint 19  √ 
event id bigint 19  √  null
event_to_declare_bp id bigint 19  √ 
forecast id bigint 19  √ 
node_seed_iops id bigint 19  √ 
provisioning_policy id bigint 19  √ 
provisioning_policy_view id bigint 19 0
resource_budgets id bigint 19  √ 
resource_capability_stats id bigint 19  √ 
storage_service_level id bigint 19  √ 
storage_service_level_view id bigint 19 0
tenant id bigint 19  √ 
threshold id bigint 19  √ 
threshold_policy id bigint 19  √ 
threshold_policy_mapping id bigint 19  √ 
upgrade_history id bigint 19  √ 
version id bigint 19  √ 
workload_provision_mapping id bigint 19  √ 
workload_view id bigint 19 0
resource_capability_stats iopsSeed bigint 19  √  null
continuous_event_participant lastObservedTime bigint 19 0
workload_provision_mapping lastSslUpdateTime bigint 19  √  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
acquisition_info msgRcvTime bigint 19  √  0
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
capacity_tier_analysis objectId bigint 19
threshold_policy_mapping objectId bigint 19
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
continuous_event_participant occurrenceId bigint 19
node_seed_iops overwriteHybridIops bigint 19  √  null
continuous_event_participant participantId bigint 19 0
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
resource_capability_stats preferredStorageServiceLevelId bigint 19  √  null
workload_provision_mapping provisioningPolicyId bigint 19  √  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
resource_capability_stats resourceId bigint 19  √  null
bp_event resourceObjId bigint 19 The object id that this bp event associated with
coherence_workload size bigint 19
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
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
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
workload_provision_mapping storageServiceLevelId bigint 19  √  null
continuous_event_participant subPolicyId bigint 19  √  null
workload_view suggestedAbsoluteMinIops bigint 19  √  100 Indicates the minimum IOPS value for a performance policy.
workload_view suggestedExpectedIopsPerTB bigint 19  √  null Specifies the minimum expected IOPS allocated based on the storage object allocated size.
workload_view suggestedPeakIopsPerTB bigint 19  √  null Specifies the maximum possible IOPS per TB allocated based on the storage object used size.
workload_provision_mapping suggestedStorageServiceLevelId bigint 19  √  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
active_directory tenant_id bigint 19  √  null
acquisition_info time bigint 19
continuous_event_participant_stats time bigint 19
forecast time bigint 19
capacity_tier_analysis timestamp bigint 19 0
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_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
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
new_s_all_qospolicygroups_periodic vserverId bigint 19  √  null
s_all_qospolicygroups_periodic vserverId bigint 19  √  null
workload_view workloadCapacity bigint 19  √  null
workload_view workloadCapacityUsed bigint 19  √  null
budget_summary workloadCount bigint 19  √  null
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_provision_mapping workloadId bigint 19  √  null
node_seed_iops writeSataSasIops bigint 19  √  null
node_seed_iops writeSsdIops bigint 19  √  null
new_s_all_qospolicygroups_periodic enforceFloor bit 0  √  null
s_all_qospolicygroups_periodic enforceFloor bit 0  √  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.
continuous_event_participant isPrimaryThreshold bit 0 0
resource_budgets isRecommendedAssignment bit 0 0
new_s_all_qospolicygroups_periodic isShared bit 0  √  null
s_all_qospolicygroups_periodic isShared bit 0  √  null
continuous_event_participant isTriggered bit 0  √  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
threshold operation bit 0 Indicates if it should be a greater than, a less than or equal to operationn0=equals
1=greaterthan
2=less
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.
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.
threshold_policy enabled bit 1 A flag to enable and disable a threshold Policy
threshold_policy hidden bit 1
coherence_change_record isMappedObjInCoherence bit 1  √  b'1' 1 means the mapped object is in this table, 0 means it is in netapp_model
forecast rtOps blob 65535  √  null
forecast writeData blob 65535  √  null
budget_summary reportDate date 10
new_s_all_qospolicygroups_periodic expectedLatency decimal 15,3  √  null
s_all_qospolicygroups_periodic expectedLatency decimal 15,3  √  null
threshold severityValue decimal 15,3  √  null
workload_view assignedExpectedIops decimal 39  √  null
workload_view suggestedExpectedIops decimal 39  √  null
storage_service_level_view usedCapacity decimal 41  √  null
workload_view assignedPeakIops double 40  √  null
workload_view suggestedPeakIops double 40  √  null
workload_provision_mapping provisioningPolicyStatus enum 5  √  null
resource_budgets apiRequestType enum 6 Type of REST API operation.
forecast forecastType enum 6  √  SIGMA
disk_seed_iops type enum 6
coherence_change_record changeType enum 7
ext_data_config dataTransmission enum 7 ENABLE
node_seed_iops ioBlockSize enum 8
tenant status enum 8  √  ENABLED
ext_data_config dataFormat enum 9 GRAPHITE
event_to_declare_bp endBy enum 9 Describes how this event ends other event
event_to_declare_bp purpose enum 9 The purpose of this event for STARTING or ENDING blackout period
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.
budget_summary operationType enum 10 Specifies whether the budgeted iops is reclaimed or consumed
new_s_all_volumes_periodic derivedStyle enum 11
s_all_volumes_periodic derivedStyle enum 11
shadow_table_trail bulkLoadDone enum 12  √  null
coherence_change_record status enum 12
bp_event type enum 13 UM_EVENT The type of the blackout event source type
storage_service_level peakIopsAllocationPolicy enum 15 Indicates peak IOPS allocation policy.
storage_service_level_view peakIopsAllocationPolicy enum 15 Indicates peak IOPS allocation policy.
event_to_declare_bp category enum 17 The category of this event HARDWARE_FAILURE or BACKGROUND
bp_event eventCategory enum 17 BACKGROUND The category of the blackout event
forecast objType enum 20 QOS_VOLUME_WORKLOAD
ext_data_config statGroup enum 22
workload_provision_mapping storageServiceLevelStatus enum 45 IDLE
workload_view storageServiceLevelStatus enum 45 IDLE
capacity_tier_analysis cloudRecommendation enum 46 LEARNING
continuous_event_participant_stats absChangeStatisticValue float 12  √  null
resource_budgets aggregateExpectedBudgetedIOPS float 12  √  null
resource_budgets aggregateExpectedNonBudgetedIOPS float 12  √  null
resource_budgets aggregatePeakBudgetedIOPS float 12  √  null
resource_budgets aggregatePeakNonBudgetedIOPS float 12  √  null
new_s_all_aggregates_periodic aggregateUtilization float 12  √  null
s_all_aggregates_periodic aggregateUtilization float 12  √  null
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
resource_capability_stats budgetedIops float 12  √  null
workload_provision_mapping budgetedIops float 12  √  null
resource_capability_stats budgetedNoSslIops float 12  √  null
new_s_all_nodes_periodic cacheReadThroughput float 12  √  null
s_all_nodes_periodic cacheReadThroughput float 12  √  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
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
continuous_event_participant_stats dynamicRangeChange float 12  √  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
storage_service_level expectedLatency float 12  √  null
storage_service_level_view expectedLatency float 12  √  null
continuous_event_participant_stats forecastStatisticValue float 12  √  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
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
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
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
continuous_event_participant_stats linearTrend float 12  √  null
continuous_event_participant_stats lowerThreshold float 12  √  null
resource_capability_stats maxBudgetedIops float 12  √  null
workload_provision_mapping maxBudgetedIops float 12  √  null
resource_capability_stats maxBudgetedNoSslIops float 12  √  null
resource_budgets nodeExpectedBudgetedIOPS float 12  √  null
resource_budgets nodeExpectedNonBudgetedIOPS float 12  √  null
resource_budgets nodePeakBudgetedIOPS float 12  √  null
resource_budgets nodePeakNonBudgetedIOPS float 12  √  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 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
new_s_all_nodes_periodic readThroughput float 12  √  null
s_all_nodes_periodic readThroughput float 12  √  null
disk_seed_iops sizeTB float 12
workload_view targetLatency float 12  √  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
continuous_event_participant_stats upperThreshold float 12  √  null
disk_seed_iops usableSizeTB float 12
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
workload_view clusterCommStatus int 10  √  null
workload_view conformanceStatus int 10 0
new_s_all_nodes_periodic eventSeverity int 10  √  null
s_all_nodes_periodic eventSeverity int 10  √  null
node_seed_iops flashCacheSizeGB int 10  √  null
upgrade_history fromMaintenance int 10
upgrade_history fromMajor int 10
upgrade_history fromMinor int 10
upgrade_history fromPatch int 10
node_seed_iops hybridSsdSizeGB int 10  √  null
config id int 10  √ 
ext_data_config id int 10  √ 
ext_server_config id int 10  √ 
disk_seed_iops iops int 10 seed IOPS, 4K block size
workload_view isOnline int 10  √  null
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
version minor int 10
new_s_all_clusters_periodic nodeCount int 10  √  null
s_all_clusters_periodic nodeCount int 10  √  null
node_seed_iops numOfCores int 10
version patch int 10
ext_server_config port int 10
ext_data_config serverId int 10
upgrade_history toMaintenance int 10
upgrade_history toMajor int 10
upgrade_history toMinor int 10
upgrade_history toPatch int 10
workload_view workloadType int 10 0
capacity_tier_analysis recommendationData json 0  √  null
new_s_all_volumes_periodic recommendationData json 0  √  null
s_all_volumes_periodic recommendationData json 0  √  null
change_event changeTypeId smallint 5 Type ID of change, references to opm.change_type_definition table
continuous_event_participant contentionAnalysisRole smallint 5
threshold duration smallint 5
continuous_event_participant_stats dynState smallint 5  √  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
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_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_ports_periodic eventSeverity smallint 5  √  null
s_all_svms_periodic eventSeverity smallint 5  √  null
s_all_volumes_periodic eventSeverity smallint 5  √  null
change_type_definition id smallint 5 OPM defined ID for the change type
contention_analysis_role_definition id smallint 5 OPM defined ID for Contention Analysis Role
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
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
stat_type_definition id smallint 5
target_type_definition id smallint 5 OPM defined ID for target type
threshold_policy_type_definition id smallint 5 UM defined ID for the threshold policy type
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.
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_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.
coherence_change_record mappedObjType smallint 5  √  null type of the mapped object
stat_type_definition min smallint 5 0
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
change_event objectTypeId smallint 5 Type ID of change, references to opm.element_type_definition table
coherence_change_record objType smallint 5
coherence_workload objType smallint 5
continuous_event_participant participantType smallint 5
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
threshold severityLevel smallint 5
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
continuous_event_participant thresholdAnalysisRole smallint 5  √  null
ext_data_config transmitInterval smallint 5 5
threshold type smallint 5 0=Primary
1=Secondary
threshold_policy type smallint 5
workload_provision_mapping workloadType smallint 5  √  null
change_event_workload workloadTypeId smallint 5 Type ID of change, references to opm.element_type_definition table
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.
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_volumes_periodic tieringPolicy text 65535  √  null
s_all_volumes_periodic tieringPolicy text 65535  √  null
coherence_change_record updateTime timestamp 19 CURRENT_TIMESTAMP
threshold breachPercent tinyint 3  √  100 breachPercent is the percent value which has to be less or equal to 100
polling_interval_history pollInterval tinyint 3
config value varchar 32
disk_seed_iops disk varchar 128
event_to_declare_bp eventType varchar 128 The name of the event type defined in ocum.eventtype
ext_server_config host varchar 128
node_seed_iops model varchar 128
config name varchar 128
threshold name varchar 128  √  null
threshold_policy name varchar 128
ext_data_config vendorTag varchar 128 netapp-performance
stat_type_definition name varchar 225  √  null
capacity_tier_analysis objectName varchar 225
stat_type_definition type varchar 225
stat_type_definition unit varchar 225  √  null
new_s_all_aggregates_periodic aggregateDerivedType varchar 255  √  null
s_all_aggregates_periodic aggregateDerivedType varchar 255  √  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
new_s_all_aggregates_periodic aggregateType varchar 255  √  null
s_all_aggregates_periodic aggregateType varchar 255  √  null
workload_view assignedSslName varchar 255  √  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_qospolicygroups_periodic blockSize varchar 255  √  null
s_all_qospolicygroups_periodic blockSize varchar 255  √  null
new_s_all_volumes_periodic cloudRecommendation varchar 255  √  LEARNING
s_all_volumes_periodic cloudRecommendation varchar 255  √  LEARNING
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 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_lifs_periodic currentLocation varchar 255  √  null
s_all_lifs_periodic currentLocation varchar 255  √  null
new_s_all_lifs_periodic currentNodeName varchar 255  √  null
s_all_lifs_periodic currentNodeName varchar 255  √  null
new_s_all_lifs_periodic currentPortName varchar 255  √  null
s_all_lifs_periodic currentPortName varchar 255  √  null
new_s_all_volumes_periodic diskType varchar 255  √  null
s_all_volumes_periodic diskType varchar 255  √  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_lifs_periodic homeLocation varchar 255  √  null
s_all_lifs_periodic homeLocation varchar 255  √  null
new_s_all_lifs_periodic homeNodeName varchar 255  √  null
s_all_lifs_periodic homeNodeName varchar 255  √  null
new_s_all_lifs_periodic homePortName varchar 255  √  null
s_all_lifs_periodic homePortName varchar 255  √  null
new_s_all_aggregates_periodic isInactiveDataReportingEnabled varchar 255  √  null
s_all_aggregates_periodic isInactiveDataReportingEnabled varchar 255  √  null
coherence_workload key varchar 255 workload resource key
new_s_all_clusters_periodic managementIp varchar 255  √  null
s_all_clusters_periodic managementIp varchar 255  √  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
coherence_workload name varchar 255  √  null
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
storage_service_level name varchar 255  √  null
storage_service_level_view name varchar 255  √  null
tenant name varchar 255
change_event_attribute newValue varchar 255  √  null Attribute value after the update
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
coherence_change_record objKey varchar 255  √  null object resource key
coherence_change_record objName varchar 255
change_event_attribute oldValue varchar 255  √  null Attribute value before the update
coherence_change_record parentName varchar 255 parent object name
new_s_all_qospolicygroups_periodic policyGroupClass varchar 255  √  null
s_all_qospolicygroups_periodic policyGroupClass varchar 255  √  null
workload_view provisioningPolicyName varchar 255  √  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_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
new_s_all_clusters_periodic serialNumber varchar 255  √  null
s_all_clusters_periodic serialNumber varchar 255  √  null
shadow_table_trail shadowTableName varchar 255
new_s_all_namespaces_periodic state varchar 255  √  null
s_all_namespaces_periodic state varchar 255  √  null
new_s_all_namespaces_periodic subsystem varchar 255  √  null
s_all_namespaces_periodic subsystem varchar 255  √  null
workload_view suggestedSslName varchar 255  √  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
change_type_definition type varchar 255 Change type name.
contention_analysis_role_definition type varchar 255 Contention Analysis Role Name
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
target_type_definition type varchar 255 Target Type name
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
new_s_all_clusters_periodic version varchar 255  √  null
s_all_clusters_periodic version varchar 255  √  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_qospolicygroups_periodic vserverName varchar 255  √  null
s_all_qospolicygroups_periodic vserverName varchar 255  √  null
workload_view workloadAggregateName varchar 255  √  null
workload_view workloadAggregateUuid varchar 255  √  null
workload_provision_mapping workloadKey varchar 255  √  null
workload_view workloadKey varchar 255  √  null
workload_view workloadName varchar 255  √  null
workload_view workloadSvmName varchar 255  √  null
workload_view workloadVolumeKey varchar 255  √  null
workload_view workloadVolumeName varchar 255  √  null
new_s_all_qospolicygroups_periodic capacityUnit varchar 256  √  null
s_all_qospolicygroups_periodic capacityUnit varchar 256  √  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
workload_view assignedSslUuid varchar 512  √  null
workload_view clusterKey varchar 512  √  null
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
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 currentNodeResourceKey varchar 512  √  null
s_all_lifs_periodic currentNodeResourceKey varchar 512  √  null
new_s_all_lifs_periodic currentPortResourceKey varchar 512  √  null
s_all_lifs_periodic currentPortResourceKey varchar 512  √  null
bp_event description varchar 512 The discription of this blackout period event
active_directory dns varchar 512
active_directory domain varchar 512
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
new_s_all_lifs_periodic homeNodeResourceKey varchar 512  √  null
s_all_lifs_periodic homeNodeResourceKey varchar 512  √  null
new_s_all_lifs_periodic homePortResourceKey varchar 512  √  null
s_all_lifs_periodic homePortResourceKey varchar 512  √  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
active_directory password varchar 512
workload_view provisioningPolicyUuid varchar 512  √  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
workload_view suggestedSslUuid varchar 512  √  null
active_directory svm_key varchar 512  √  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
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
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
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 vserverResourceKey varchar 512  √  null
s_all_qospolicygroups_periodic vserverResourceKey varchar 512  √  null
workload_view workloadSvmKey varchar 512  √  null
threshold_policy description varchar 1024  √  null