Skip to main content
C
cmhaka9-Granite
9-Granite
March 29, 2024
Question

Audit Trail Journal

  • March 29, 2024
  • 1 reply
  • 1256 views

I would like to find the source of the Audit Trail Journal information that shows in the Windchill interface when clicking the Audit Trail Journal icon in the History section of the Timeline tab of the CAPA quality objects.. I would like to find the source either in Query Builder or the database in order to incorporate the information into another report. But I have been unable to to locate the information either in Query Builder or in the database. Does anyone know how to grab this information to include in custom reports? I am using Windchill  version 11.1 M020-CPS17. 

1 reply

Fadel
Fadel23-Emerald I
23-Emerald I
March 29, 2024

I'm not quite familiar with CAPA and QMS , the best reflex in such use case is to enable wt.pom.sql logger , you can then access information from UI , in the logs you will see trace of all DB tables and Queries 

Buiꓘa
C
cmhaka9-GraniteAuthor
9-Granite
March 29, 2024

Hello @Fadel ,

Thank you for your response. How do I enable the wt.pom.sql logger? And once that is enabled are the results viewed in the Method Server log?

 

Fadel
Fadel23-Emerald I
23-Emerald I
March 31, 2024

Hello ,

 

check steps  below 

(view in My Videos)

 

BR,

Fadel

Buiꓘa
Terms & ConditionsCookie settingsAccessibility statement