Automic Workload Automation

  • Private Community

  • 1.  Is there a way to hide a variable value on a job report? .

    Posted Jan 06, 2014 02:09 PM

    Is there a way to hide a variable value on a job report?  Some of our variables are passwords and we wish to hide them from the job report.




  • 2.  Is there a way to hide a variable value on a job report? .
    Best Answer

    Posted Jan 06, 2014 03:19 PM

    If you use a prompt set you can can config the text value as a password.

    You then get an encrypted value back on the report.

    2014-01-06 14:57:54 - U0020206 Variable '&TEXTFIELD1#' was stored with value '--1088504CD34B2352F3A70CFB1C77492C8A'.

    You will then need to unencrypt that value before you use it with the &UC_JOBMD  command

    FYI V9 did have bugs with doing this depending on which SP you were on



  • 3.  Is there a way to hide a variable value on a job report? .

    Posted Jan 06, 2014 04:22 PM

    Thank you.



  • 4.  Is there a way to hide a variable value on a job report? .

    Posted Jan 06, 2014 04:30 PM

     

    I have run into buggy behavior with encrypted passwords in V9-SP5 (which we are on).  The first two bytes that are returned can be the wrong characters.  I worked around this problem by replacing the first two bytes with additional scripting logic.

    Regarding &UC_JOBMD, it demands that you use double-quote delimiters around the command line string it is to execute, and this can be a real problem if you also need to send double-quote delimiters within your command line string. 



  • 5.  Is there a way to hide a variable value on a job report? .

    Posted Jan 07, 2014 11:30 AM

    The quote problem is a good one. The problem is really any character after the password VARA when using &UC_JOBMD

     

    Here is the one way to get it to work. Unencrypt the password and save it to a file. You can then save that value and use it on the command line.

    Example code:

    ! Temp file for password set pwFile=%temp%\pass_&$RESTART_RUNID#.txt ! Unencrypt password must have a space after the password field TEXTFIELD1 &UC_JOBMD CMD="echo &TEXTFIELD1# >%pwFile%" ! Put password in var value pw set /P pw=<%pwFile% ! Strip off that extra space set pw=%pw:~0,-1% ! Now you can put quotes around the password or anything else echo Unencrypt value quote working = "%pw%" ! delete temp password file del %pwFile%
    6e1c0731c8a9ebad70ad06b3ab849c.pnghttps://us.v-cdn.net/5019921/uploads/FileUpload/93/6e1c0731c8a9ebad70ad06b3ab849c.png" width="1171">


  • 6.  Is there a way to hide a variable value on a job report? .

    Posted Aug 14, 2014 05:13 PM

    I ended up doing something simple.  turning echo off but echoing the string back to see the other variable values except for the variable that contained the pwd value.  Only echo back the pwd variable name (exL OraOLTPPwd).

    The current logic was:

    %batchhome%\bin\ACBS\AcbsEdwExtract.bat &dtsxpth\&JNM.dtsx &OraUsr &OraOLTPPwd &TNS &SQLSrv &DaysToSave &SQLDBName

    changed it to be:

    @echo off

    echo %batchhome%\bin\ACBS\AcbsEdwExtract.bat &dtsxpth\&JNM.dtsx &OraUsr OraOLTPPwd &TNS &SQLSrv &DaysToSave &SQLDBName
    %batchhome%\bin\ACBS\AcbsEdwExtract.bat &dtsxpth\&JNM.dtsx &OraUsr &OraOLTPPwd &TNS &SQLSrv &DaysToSave &SQLDBName






  • 7.  Is there a way to hide a variable value on a job report? .

    Posted Aug 15, 2014 05:22 PM

    Just posted some examples of passing a password from a PromptSet.

    http://community.automic.com/discussion/1106/using-a-password-passed-from-promptset-uc-jobmd