Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register for your free eCourse.

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