Modifying how a macro is display

I was wondering how to change the output of a macro in an alert. For examply I am setting up memory usage alerts. I am using: ${NodeName} memory utilization is at ${VolumePercentUsed}. That gets me something like this:

servername memory utilization is at 64.31521

I do not want to see all the decimals. I just want to see:

servername memory utilization is at 64%. I know i can add the % at the end of alert, but can't figure out how to drop the decimals.

Find more posts tagged with

Alert

memory_utilization

Macros

Accepted answers

All comments

bleearg13

Orion used to have what was called "Raw" and "Cooked" options for displaying data, but I think that has gone by the wayside, or is only for Basic Alerts. If I'm not mistaken, I think you could do this by running a SQL query as the macro, instead of using ${VolumePercentUsed}. Unfortunately, I'm no SQL guru, so I couldn't provide you the exact query off the top of my head.

lchance

Are you looking for RAM utilization ? If so then try this one ${PercentMemoryUsed}

pguenther

The ${PercentMemoryUsed} doesn't work. The alert spits out the ${PercentMemoryUsed} text and not a number.

pguenther

I am not a SQL person either so I wouldn't have a clue how to do that.

qle

See if the following works for you. Replace ${VolumePercentUsed} with the following:

${SQL:Select round((100* memoryused / totalmemory),0) from Nodes where NodeID='${NodeID}'}

Please let me know if that works for you.