Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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