Spectrum Technology Platform

 View Only
  • 1.  Flow Execution History Extraction

    Posted 01-17-2020 10:30
    Hi,

    Does anybody know how it would be possible to extract the flow/process execution history to file automatically?

    There are ways to extract this manually but I would like an automated task to do the extraction when I could then load into a database for analysis on an hourly basis.

    I'm unable to locate a log file that contains this data. Can the config be altered for this information to be logged in a file? 

    Many thanks,
    Dave

    ------------------------------
    David Bell
    European Tyre Enterprise Limited
    LETCHWORTH GARDEN CITY
    ------------------------------


  • 2.  RE: Flow Execution History Extraction

    Employee
    Posted 01-19-2020 22:33
    Hi David,

    If you are after the history for a specific job you can use a Spectrum CLI command: job history list --j "My Job"

    https://support.pb.com/help/spectrum/18.2/en/webhelp/AdministrationGuide-WebUI/index.html#AdministrationGuide/source/AdministrationUtility/job_historylist.html

    ------------------------------
    Yann Chane-kive
    Sr Solutions Architect
    Pitney Bowes Australia Pty Ltd
    South Brisbane
    ------------------------------



  • 3.  RE: Flow Execution History Extraction

    Posted 04-21-2020 11:39
    Hi Yann,

    Thanks - I have been able to access the information that I require via the CLI command tool.
    However I would like to get the results into a text file.

    I don't suppose you would know if that is possible?

    Many thanks,Dave


    ------------------------------
    David Bell
    European Tyre Enterprise Limited
    LETCHWORTH GARDEN CITY
    ------------------------------



  • 4.  RE: Flow Execution History Extraction

    Posted 04-22-2020 09:06
    Hi David,

    you can execute the CDLI commands by command line and script (see https://support.pb.com/help/spectrum/18.2/en/webhelp/AdministrationGuide-WebUI/index.html#AdministrationGuide/source/AdministrationUtility/RunningScript.html ) and transfer the data into a text file e. g. "cli.cmd --cmdfile JobHistory.cli > JobHistoryResults.txt".

    Best Regards

    ------------------------------
    Thomas Spielberger
    Senior Solution Consultant
    Sales Engineering EMEA
    Syncsort GmbH
    ------------------------------



  • 5.  RE: Flow Execution History Extraction

    Posted 07-20-2020 15:39
    Edited by Michael Ariston 07-20-2020 17:21
    Hi Thomas,

    A follow up to JobHistory command, is there command to obtain the status of the job?  Our process would like to ping Spectrum every 10 minutes to get the latest status of long running job.

    Thanks,

    Michael