Table opm.threshold Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigint 19  √ 
policyId bigint 19
threshold_policy.id policyId_threshold C
name varchar 128  √  null
elementType smallint 5
element_type_definition.id elementType_threshold R
type smallint 5 0=Primary
1=Secondary
statType smallint 5
stat_type_definition.id counterType R
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
operation bit 0 Indicates if it should be a greater than, a less than or equal to operationn0=equals
1=greaterthan
2=less
severityLevel smallint 5
severityValue decimal 15,3  √  null
duration smallint 5
breachPercent tinyint 3  √  100 breachPercent is the percent value which has to be less or equal to 100

Table contained 214 rows at Tue Apr 23 04:58 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
statType Performance Asc counterType_idx
elementType Performance Asc elementType_threshold
policyId Performance Asc policyId_threshold_idx

Close relationships  within of separation: