How to Analyse publishing job logs for long running job

[khimani_mohiki]

Version: Windchill 12.1

Use Case: We have some CAD Documents which take a very long time to load in the CADworker, I can see that in the job logs. What I want to do is make a query to a data dump of the job start and end times and the number iof the EPM document, so I can identify objects which take along time to load.

Description:

We have some CAD Documents which take a very long time to load in the CADworker, I can see that in the job logs. What I want to do is make a query to a data dump of the job start and end times and the number iof the EPM document, so I can identify objects which take along time to load. I can see there is a db table for publishing stats, but its only got the job start and end date, not the time, so where are the job logs stored?

[Hari_Vara]

Hi,

Windchill Performance Advisor can bake that data for you and provide XML file. This is your OOTB starting point. 

I think you can easily process the XML to get the further data quality you are looking for.

Cheers

Hari

[Hari_Vara]

Here is some guide on that.

https://support.ptc.com/help/windchill/r12.1.2.0/en/index.html#page/Windchill_Help_Center/WCSysAdminQualityAgent/WCSysAdminQualityAgentReportContent.html#