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 Volumes WHERE…
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.