Symantec Management Platform (Notification Server)

I am trying the use token &JOBUSER% -  The name of the user logged in to the Deployment console.  I created a new token called JOBSUER.  I do not know the SQL code to retrieve the new token JOBUSER, that I created. When I try to display the token value, nothing displays. I am using ITMS SMP 7.6. Does anyone know the SQL code that I need to use to get JOBUSER token to display?

What are the System Variable Tokens Used by the Deployment Solution and Can be Inserted in SQL Scripts?
https://www.symantec.com/connect/articles/what-are-system-variable-tokens-used-deployment-solution-and-can-be-inserted-sql-scripts

Tokens in Deployment Solution 7.x
https://www.symantec.com/connect/articles/tokens-deployment-solution-7x

Adding tokens for deployment tasks
https://support.symantec.com/en_US/article.HOWTO100020.html

The variable and tokens used in Delpoyment Solution and inserted in SQL scripts?
https://support.symantec.com/en_US/article.HOWTO21640.html

Thanks for information but I still need help. I know the token name is JOBUSER. I already added the token JOBUSER. How do I get the value  that is stored in JOBUSER?  Is there a SQL query statement that I need to add to the token to initialize it?

So you added a token in the NS at

Settings | Deployment | Tokens

You called it JOBUSER and you'd like the SQL used to get the JOBUSER to put into the Job.

Did you leave it blank currently?

Example

NS Server name

/*** A token to return the NS server name ***/
/*** %NSSERVER% : Returns NS server name ***/
select [Server] from [dbo].[vComputer] where [Guid] = '%COMPUTERID%' 

Yes, it is blank because I do not know the SQL statement to put in text box. Can you tell me the SQL statement?

Have you tried just adding %JOBUSER% to a script and testing a sample Task

Manage | Jobs and Tasks

Right Click | New | Task

Run Script

Choose: Command Script

echo %JOBUSER%
pause

You can set to save output back to the Task and view it in the Console.

Schedule to a machine.

---

Token Woes - https://www.symantec.com/connect/blogs/token-woes

Send Email Notification to Tech After Completed Job - https://www.symantec.com/connect/blogs/send-email-notification-tech-after-completed-job

I had to enable security in the Deployment Console.

Pull User Name of the person that scheduled the Job https://www.symantec.com/connect/forums/pull-user-name-person-scheduled-job

If you have a job or task that schedules a 2nd job then the %JOBUSER% token won't work inside the 2nd job.

---