Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Add the temperature variable for hardware sensor alerts

Add the temperature variable for hardware sensor alerts

Table of contents

Updated June 20, 2017

Overview

This article describes how to add an alert variable for temperature in Fahrenheit for hardware sensor based alerts.

Currently, SolarWinds stores temperature information in the database in Celsius. The trigger conditions using this value need to be defined when you set up the hardware alert on the sensors with temperature metrics.

Environment

SAM 6.2 and later

Steps

  1. Make sure that the email alert is based on the hardware sensor.
    Note: The ${N=SwisEntity;M=Value} variable gives you a temperature value in Celsius in the email alert.
  2. Add the following variable or function to the email action of the alert:
    ${SQL: SELECT (${N=SwisEntity;M=Value}* 9 / 5) + 32 }

 

Last modified

Tags

Classifications

Public