How can I insert a value for the VolumePercentAvailable in an alert message? This is not an available field in the database, so how do I construct the math statement that will subtract the VolumePercentUsed from 100?
Thanks.
You can try using UnDP. Find out the poller associated for VolumePercentUsed, then Transform the results in UnDP using your formula, then in turn use the Custom Poller that u made in an alert.
Hope that helps.
I haven't tested this but can you do the "Define SQL Variable" part of select variable and put the math directly in there? Would come out to be ${SQL:Select 100 - ${VolumePercentUsed}}. No time to test right now though.
lhorstma,
It worked great, thank you for the post. Here is what I had done in one of our Advanced Alerts and it is reporting correctly:
Interface Speed: ${InBandwidth as Bandwidth}
Rx: ${SQL:Select 10000000/${Inbps}} Mbps
Tx: ${SQL:Select 10000000/${Outbps}} Mbps
Respectfully,
NetEng33
I am using ${SQL:Select 100 - ${VolumePercentUsed}}. any tips on removing the decimal points. This is giving me a number like 21.03253. I am having trouble getting it to truncate or round.
Try adding this... select left(convert(varchar, 100-${VolumePercentUsed}),5) ... Change the "5" up or down to get more or less. This will truncate.
CAST and CONVERT (Transact-SQL). There are other sql functions, but I'm not sure if they're supported (such as ROUND).
select round( .... , 2) ... will give you 2 decimals.
