Category
Hi folks.
I have kicked the K1000 into production for the patching and Help Desk. I am trying to get the category as part of the email body but have never been successful. I tried all suggestions which essentially hinged on being able to do a join on the MySQL tables but I could never make it work.
The original thread was here: http://itninja.com/question/email-body-for-ticket&mpage=1&key=
When we receive a ticket, the category only shows as Category: $TickCategory
I am really wanting to correct that so we can see the actual category.
Anyone want to work through this with me?
Thanks in advance.
--james
I have kicked the K1000 into production for the patching and Help Desk. I am trying to get the category as part of the email body but have never been successful. I tried all suggestions which essentially hinged on being able to do a join on the MySQL tables but I could never make it work.
The original thread was here: http://itninja.com/question/email-body-for-ticket&mpage=1&key=
When we receive a ticket, the category only shows as Category: $TickCategory
I am really wanting to correct that so we can see the actual category.
Anyone want to work through this with me?
Thanks in advance.
--james
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
jbowes
13 years ago
That is fantastic - it was definitely just what you thought. Lowercase... I should have noticed that.
One last thing and a real important one is the impact. I would love to have that come in as a part of the body of the email. If you have any suggestion on that, I would definitely welcome it. I already tried Impact: $impact but had no joy.
Thanks again for noticing the $tickcategory.
--james
One last thing and a real important one is the impact. I would love to have that come in as a part of the body of the email. If you have any suggestion on that, I would definitely welcome it. I already tried Impact: $impact but had no joy.
Thanks again for noticing the $tickcategory.
--james
Posted by:
steelc
13 years ago
Are you selecting the impact as part of your select statement? Only columns that are included in the select statement will be available as variables in the email.
Posted by:
GillySpy
13 years ago
Referring to the other thread you did not have HD_IMPACT.NAME anywhere in your column list so you can't use it in the email. But you did have that table joined so a simple addition of:
then you could reference it as $tickimpact in the email
select .... , HD_IMPACT.NAME TICKIMPACT, ....then you could reference it as $tickimpact in the email
Posted by:
steelc
13 years ago
I believe in the email body the variables need to be in all lower case, so have you tried $tickcategory?
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.