Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > 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