fum42083

Comments

  • Hi ss185547, converting the SQL query in the alert message to a SWQL query did the trick. Thanks!. But it think it is just a Workaround, because there might be cases were you need plain SQL in the email and the alert message.
    in Parsing Variables for Email Alerts Comment by fum42083 November 2018
  • Hello ss185547, i have the same problem. In my case i want to view trap-messages with a sql-query. the query works in the Email notification, but it fails with: MACRO SQL ERROR - ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The…
    in Parsing Variables for Email Alerts Comment by fum42083 November 2018
Avatar