Spectrum Technology Platform

Expand all | Collapse all

Flow Execution History Extraction

  • 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
    ------------------------------