Scripting

We have long used Custom Ticket Rules to create regularly scheduled tickets. The setup for this is based upon this article: https://www.itninja.com/blog/view/scheduling-ticket-creation. This recommended sql query, for pulling the email address used to submit tickets, is no longer working:

select
"servicedesk" as EMAILCOLUMN

It seems as though directly referencing the email address of a queue is no longer supported. Instead of returning the email address for the queue, it simply returns the word, "servicedesk". Honestly, I'm not sure how this query ever worked; I'm guessing there was some sort of hard-coded variable system that returned the right value?

I've implemented the following query as a workaround:

SELECT HD_QUEUE.Alt_Email_Addr AS EMAILCOLUMN
FROM HD_QUEUE
WHERE Name = "Help Desk"

I'd prefer to use the original method, though, as it is easier to incorporate into more advanced queries, since it doesn't require pulling data from a table (and thus having to join tables).

Anyone have any guesses as to what has changed? Any ideas for a better way to pull the email address for a queue?