The most recent content from our members.
This alert has been in place for years without issues; now all of sudden I'm getting MACRO SQL ERROR - Incorrect syntax near... This the definition of the Alert Message: ALERT: ${NodeName} ${SQL:Select Substring ('${Caption}',1,30) AS Caption} Volume is ${SQL:Select Round ('${VolumePercentUsed}',0) from…
I'm attempting to configure an alert for the File Size Monitor template to return the file path in the body of the message. I'm using this thread as a reference and I have no SQL experience. The goal is to be able to apply this to multiple different files/nodes without having to change or create separate alerts for each by…
Hello, Since upgrading SAM 6.0 / NPM 10.6 to SAM 6.2.1 / NPM 11.5.2 we have had issues with alerts that have conversions. The message of the alert now states the following: This alert has been active for MACRO SQL ERROR - Conversion failed when converting date and/or time from character string. days and MACRO SQL ERROR -…
It looks like you're new here. Sign in or register to get started.