How to find all list of failed jobs details like worker name with objects number in bulk for date

[NB_13663423]

How to find all list of failed jobs details like worker name with objects number in bulk for date wise.
Example :

If we select start date - 27-06-2025 and end date 27-06-2025 all the failed jobs between this time period.

expected result 

   Object Number   Type of worker       Date                         error 

1. Obj1                          office                  27-06-2025         failed with error details

2. Obj2                         Nx                       27-06-2025         failed with error details

2. Obj2                         Creo                   27-06-2025         failed with error details

[avillanueva]

Jobs in the WVS Job Monitor get cleared on a regular basis via a queue task. The logs are stored in the <windchill>/logs/cadagent folder and you can find the gory details there. Folders are separated by CAD worker name. If you are looking for just stats, the WVS Job Monitor has an action for that.

Here you can select a date range to get counts but not details. For that you will need to grep the logs looking for some key words of failures.

[NB_13663423]

Example :

If we select start date - 27-06-2025 and end date 27-06-2025 all the failed jobs between this time period .

expected result 

   Object Number   Type of worker       Date                         error 

1. Obj1                          office                  27-06-2025         failed with error details

2. Obj2                         office                  27-06-2025         failed with error details

2. Obj2                         Creo                   27-06-2025         failed with error details

.........                                .........                    .........                        ......... 

[avillanueva]

The table you might be looking for is PUBLISHINGSUMMARY. From what I can tell it has Authoring app, context, queue, object, user, workername, start/end time, success/failure flag. It would not have the error details since those are captured in the logs.