AppWorx, Dollar Universe and Sysload Community

 View Only
  • 1.  Output Report

    Posted Jan 26, 2020 08:52 PM
    Hi All,

    Can i know how to hide Password for the Windows jobs in the out put Report.below is the output report.

    Thanks in Advance.

    D:\MSTRbatchfiles>call MSTR.bat Cube-CallInsights-FCR_AgentPerformanceDashboard

    D:\MSTRbatchfiles>MASysMgr.exe -w "D:\MSTRbatchfiles\SystemManagerWorkflows\Cube-CallInsights-FCR_AgentPerformanceDashboard.smw" -showoutput "ProjectSource=P270 Dev" "UserName=BI_Analytics_Admin" "Password=test@2019"
    Warning:The execution log file will be:
    D:\webapps\Log\MASysMgr.log
    Workflow 'D:\MSTRbatchfiles\SystemManagerWorkflows\Cube-CallInsights-PerformanceDashboard.smw' execution started: January 01, 2020 10:02:55 AM CST
    PREPARING process 'Cube Refresh' on 'January 01, 2020 10:02:55 AM CST'
    RUNNING process:Cube Refresh
    process data:{Suppress hidden object(s) in the results=FALSE, Split output into three specified files=FALSE, Log output to specified file=TRUE, Break log file=FALSE, Login=, Script File (.scp)=TRUE, Log output to default file=FALSE, Include instructions in the log file(s)=FALSE, Script File (.scp)=D:\MSTRBATCHFILES\CMD SCRIPTS\PUBLISH CUBE - CALL INSIGHTS - FCR.SCP, Password=*******, Failure File=, Include error codes in the log file(s)=TRUE, Project Source=P270 DEV}


  • 2.  RE: Output Report
    Best Answer

    Posted Jan 27, 2020 03:35 AM
    Good morning,

    1. Read the password from a LOGIN into a script variable
    2. Put the script variable into an OS variable using SET
    3. Use the OS variable in the command line

    Since the variable is filled during the runtime it vanish after the script execution. The only thing you sould not to is to echo the whole command for debugging reasons. ;-)

    Regards,
    Jürgen

    ------------------------------
    Juergen Lechner
    Senior Consultant
    setis GmbH
    Germany
    ------------------------------



  • 3.  RE: Output Report

    Posted Jan 27, 2020 09:53 AM
    thanks Jurergen,

    Is there any Documentation for this particular one where it will be helpful to make the changes


  • 4.  RE: Output Report

    Posted Jan 27, 2020 10:34 AM
    It appears that the password is inside the MSTR.bat script, not a command line argument. 

    In that case the simplest way to suppress the password being shown is to suppress the entire line that includes the password.  This can be done by starting that line with "@" or using echo off/echo on before/after that line.

    Regards,
    Ray


  • 5.  RE: Output Report

    Posted Jan 27, 2020 05:11 PM
    Thanks Ray for the Solution to it.


  • 6.  RE: Output Report

    Posted Jan 27, 2020 05:13 PM
    Hi Ray,

    Can you please correct me i am using it Correctly ?

    call MSTR.bat &SMW_NAME --this is the Command line we use
    @echo on