Windchill Visualisation Job Queue Visability

[RME_DH]

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.

[d_graham]

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.

David

[d_graham]

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.

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

[RME_DH]

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_graham]

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

[RME_DH]

Hi David,   Apologies, I was not clear.   You are 100% correct, it is 'position' that we are after, from the site level overall position

[Marco_Tosin]

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

[RME_DH]

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_graham]

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.

David

[STEVEG]

@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_graham]

@STEVEG,

I'm using just one table, QUEUEENTRY.

David

[STEVEG]

Nothing comes up for any of those entries.

[Marco_Tosin]

Steve,

I've tried to build a report using QUEUEENTRY table and get some result.

Are you working on a test system?

Maybe there are no entry for above reason.

Try to change the time span in which the search is performed.

[STEVEG]

Hi @Marco_Tosin 

It looks like there needs to be some java programming involved and I don't know java.

At this point it is only for my use.  Nobody has asked for that info.

[Marco_Tosin]

Hi Steve,

I don't program in Java either.

What you see is done with basic query builder options.

[STEVEG]

I am on my production server.  Not test.  So there should be something that comes back.

[HJ1]

Ok,

so how EXACTLY do you pull that e.g. "Representable" column data showing the EPMDocument number as well as other data looking like in Job Monitor from QUEUEENTRY using just Query Builder?

Query Builder for Dummies needed  😳