The attached report will show each component of an application monitored by SAM and its currently configured threshold values
The attached report will show each component of an application monitored by SAM and its currently configured threshold values
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
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.