Skip to main content
R
RME_DH13-Aquamarine
13-Aquamarine
July 16, 2021
Question

Windchill Visualisation Job Queue Visability

  • July 16, 2021
  • 4 replies
  • 5574 views

Hi All,

We would love to be able to have a visual on the status and qty of jobs in the WVS queue, and wondering if anyone has ideas on how we could solve our requirement.

Can the queue/job monitor information be queried or output in anyway?   Is it possible to push this to thingworx dashboard or mashup somehow?  any 3rd party tools out there that does this?

 

Any ideas that can give us some leads to pursue would be appreciated.

    4 replies

    D
    18-Opal
    d_graham18-Opal
    18-Opal
    July 16, 2021

    Did you try using the Query Builder?

    The image below is a query I built to show the status of all publishing jobs.

    Can certainly add more info.  I included the log that you'd see in the WVS Job Monitor for each job.  Probably over kill but interesting to know it's doable.

    d_graham_0-1626455488304.png

     

    David

    D
    18-Opal
    d_graham18-Opal
    18-Opal
    July 16, 2021

    I made this with the Query Builder and also added an action under the Quick Links drop-down menu to the report easy to access.

    Not sure which status you are referring to but I've included both of them.

    I also included the WVS log just to see what that would look like.  Might be over kill but good to know it's doable.

    d_graham_0-1626530236359.png

     

    If you are looking for a count of Job Failed and Job Successful that too should be doable.

    I'm not exactly sure what you are looking for but anything should be doable in Query Builder.

     

    David

    R
    RME_DH13-AquamarineAuthor
    13-Aquamarine
    July 19, 2021

    Thanks David,  that certainly looks like it has promise.  Unfortunately my experience with reports is somewhat lacking.  I searched through the list of tables but couldn't find anything that stood out for me related to visualisation/wvs/job etc.   Can you give a clue to what tables are to do with the information above.

     

    Ideally, we would like to have the user see where their jobs falls within the entire queue,   i.e.  if there is a currently, 300 jobs, and I submit a rep job, I am now at position 301.  But if the user looks up their job monitor, they have 1 job at position 1.  it sets the expectation that the visual will be available soon, but in reality, it could be several hours away.

     

    Of course at site level, we can see the entire queue, but the users cannot.

    D
    18-Opal
    d_graham18-Opal
    18-Opal
    July 19, 2021

    I see.

    So, the real problem is how to get the users to see where there waiting jobs are in the line. AKA "Position" in the WVS Job Monitor. Correct?

     

    David

     

     

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    July 19, 2021

    You can vote for this idea https://community.ptc.com/t5/Windchill-Ideas/Gather-a-report-from-WVS-job-monitor/idi-p/457493 and take a look at the comment written by other users with some suggestions on how to get information from WVS queue

     

    Marco
    R
    RME_DH13-AquamarineAuthor
    13-Aquamarine
    July 19, 2021

    Thankyou for the heads up Marco,   I have voted and looking through the information posted there.  That combined with David's information above gives me some better insight to how it all works.

     

    Regards

    Daniel

    D
    18-Opal
    d_graham18-Opal
    18-Opal
    July 20, 2021

    Daniel,

     

    Now that I know exactly what you're looking for I was able to add some code to calculate the "Position".

    FYI, "Position" is not stored in the dB.  It's calculated from data in the dB.

    Seems to work well.  See the image below.

    d_graham_1-1626790942003.png

     

    David

      S
      21-Topaz I
      STEVEG21-Topaz I
      21-Topaz I
      July 22, 2021

      @d_graham  What table(s) are you using in your report?  I tried a few years ago but never could get that info.  Then I saw that article from PTC stating it can't be retrieved so I stopped looking.

      D
      18-Opal
      d_graham18-Opal
      18-Opal
      July 23, 2021

      @STEVEG,

       

      I'm using just one table, QUEUEENTRY.

       

      David

       

      Terms & ConditionsCookie settingsAccessibility statement