Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Server & Application Monitor (SAM) > Unable to display GB/MB with the MemoryUsed variable used in the email action in alert

Unable to display GB/MB with the MemoryUsed variable used in the email action in alert

Overview

Unable to display GB/MB with the MemoryUsed variable used in the email action in alert.

Environment

All SAM versions

Resolution

Run the following (one line) SQL command to correct the conversion issue:

${SQL:SELECT top 1 (CASE WHEN ${MemoryUsed} > 1073741824 THEN CAST( round(${MemoryUsed}/1024/1024/1024,1) AS varchar(50))+' GB' WHEN ${MemoryUsed} > 1048576 THEN CAST( round(${MemoryUsed}/1024/1024,1) AS varchar(50))+' MB' WHEN ${MemoryUsed} > 1024 THEN CAST( round(${MemoryUsed}/1024,1) AS varchar(50))+' KB' ELSE CAST( ${MemoryUsed} AS varchar(50)) +' B' END) as mem FROM APM_ProcessEvidence_Detail }

 

Last modified

Tags

Classifications

Public