I am working on a query to get all information about an apm component from the database, but cannot get the threshold operators (<, <=, !=, etc...)
I can get the thresholds from either the APM_AlertsAndReportsData table or the APM_ThresholdsByComponent table, but neither have the operators, and the APM_Threshold table only shows operators for really old components, I am guessing it is legacy.
Attached is the sql query I have so far. The fields I am trying to fill are PercentCPUThresholdOperatior, Percent MemoryThresholdOperator, PercentVirtualMemoryThresholdOperator, etc...
Any help would be great, thanks.
thresholds are stored in APM_Threshold table. This table contains thresholds for both templates and components.
Please note column 'IsTemplate' - it indicates if column 'ID' contains Component ID (from table APM_Component) or component template ID (from table APM_ComponentTemplate)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.