Component Monitor Threshold Value Report

This is great alterego... and I'm really glad someone else knows their SQL well enough to put something like this together!

This is fantastic!  I updated the query in my report so it turns the extreme values that are set for "not set" values (1.7976931348623157E+308,-1.7976931348623157E-308) into nulls.

I don't know if I can add an attachment to this post, so I'm pasting in the SQL query here.  (if I find a way to attach the .OrionReport file I'll do so and remove the query)

SELECT AppT.Name AS 'Template Name', CompT.Name AS 'Component Name', CompD.Name AS 'Component Type', Thres.ThresholdName, Thres.ThresholdOperator,
CASE WHEN Thres.Warning > 1.797E+300 THEN null WHEN Thres.Warning < -1.797E-300 THEN null ELSE Thres.Warning END AS 'ThresholdWarning',
CASE WHEN Thres.Critical > 1.797E+300 THEN null  WHEN Thres.Critical < -1.797E-300 THEN null ELSE Thres.Critical END AS 'ThresholdCritical'

FROM APM_ApplicationTemplate AS AppT  
INNER JOIN APM_ComponentTemplate AS CompT ON AppT.ID = CompT.ApplicationTemplateID   
INNER JOIN APM_ComponentDefinition AS CompD ON CompD.ComponentType = CompT.ComponentType  
LEFT JOIN APM_Threshold AS Thres ON CompT.ID = Thres.ID  
WHERE CompD.ComponentEvidenceType <> 3  
UNION  
SELECT AppT.Name AS 'Template Name', CompT.Name AS 'Component Name', CompD.Name AS 'Component Type', cs.Label, cs.ThresholdOperator,
CASE WHEN cs.ThresholdWarning > 1.797E+300 THEN null WHEN cs.ThresholdWarning < -1.797E-300 THEN null ELSE cs.ThresholdWarning END AS 'ThresholdWarning',
CASE WHEN cs.ThresholdCritical  > 1.797E+300 THEN null WHEN cs.ThresholdCritical  < -1.797E-300 THEN null ELSE cs.ThresholdCritical END AS 'ThresholdCritical'

FROM APM_ApplicationTemplate AS AppT  
INNER JOIN APM_ComponentTemplate AS CompT ON AppT.ID = CompT.ApplicationTemplateID  
INNER JOIN APM_ComponentDefinition AS CompD ON CompD.ComponentType = CompT.ComponentType  
INNER JOIN APM_DynamicEvidenceColumnSchema cs ON CompT.ID = cs.ComponentTemplateID  
WHERE cs.[Type] = 1

I like this... those strange default values make the report look funny.  Thanks everyone!  I uploaded it.

Component_Monitor_Threshold_Value_Report_(with_nulls).OrionReport

This seems to show all templates regardless if they are applied are not.  Is there an easy way to filter to just a certain application or applications?

aLTeReGo​ thanks for sharing the report -- I was looking for something similar.

Sadly looks that it lost compatibility with XML schemas -- during import I got an error:

Couldn't import report from Component_Monitor_Threshold_Value_Report.OrionReport.xml. Error:

Expecting element 'Report' from namespace 'http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models'.. Encountered 'Element'  with name 'Report', namespace ''.

Orion Platform 2016.1.5300, IVIM 2.1.2, VNQM 4.2.4, SRM 6.3.0, DPA 10.0.1, NPM 12.0, QoE 2.1.0, NTA 4.2.0, IPAM 4.3.2, NetPath 1.0, SAM 6.2.4

This is a report written in the legacy Win32 Report Writer application. It must be copied manually to the 'Reports' directory on your Orion server. The default location is 'C:\Program Files (x86)\SolarWinds\Orion\Reports'.