Project Name for the queue job RRS feed

  • Question

  • Hi,

    I am using MSP_QUEUE_PROJECT_GROUP_FULL_VIEW for retrieving Project queue job details. I am not able to retrieve Project name associated with the Queue Job. MSP_QUEUE_PROJECT_GROUP_FULL_VIEW has PSCONTEXT_INFO field in image format. 

    Please help to read PSCONTEXT_INFO field in order to get project details.

    I tried using QueueSystem PSI as well but not able to get project details of the job.

    Please help.

    Wednesday, January 13, 2016 7:25 AM


  • Hi,

    This issue is resolved.

    I used MSP_PROJECTS table from draft database and used join with PROJ_CHECKOUTBY column to get the project details.


    Vedika Sawant

    • Marked as answer by Vedika S Wednesday, January 20, 2016 8:26 AM
    Wednesday, January 20, 2016 8:26 AM