Skip to main content
17-Peridot
June 27, 2023
Solved

Modified History

  • June 27, 2023
  • 2 replies
  • 4325 views

Hi Everyone,

I recently faced one issue, how we can find who have been move the one file into a different context or domain?

 

For Example, I maintain the standard format like .frm, and .prt(template) in the library, and someone moves into the product to use in some model. How we can find history who is done that? Please share the doc or video to understand the way to find out.

 

Regard

Amir

 

 

 

 

 

 

 

 

 

Best answer by Fadel

Hello Amir,

 

I don't think SQL is the best way to solve this request , we have more elegant ways to achieve this like query builder ,

you may import the attached qml to your system ans run the report :

Fadel_0-1687855183386.png

Attached a video how to import and run it  

 

 

 

 

BR,

Fadel

2 replies

Fadel
23-Emerald I
June 27, 2023

Hi,

  • If an object has been moved from one folder to another, Move History table (LOCATIONCHANGERECORD) provides information such as the original location of the object, the user who moved the object, and the date on which the move occurred.

Fadel_0-1687850107315.png

 

  • The Original Location column in Move history table shows the previous location of the object
  • User column shows the user name who has moved the object
  • Modified and Version column shows the information about the date and time when object is moved and the version of the object

BR,

Fadel

Buiꓘa
17-Peridot
June 27, 2023

Thanks for the replay Mr.Fadel,

 

Can you provide the step on how we can find in SQL database for this?

 

Thanks & Regards,

Amir

Fadel
Fadel23-Emerald IAnswer
23-Emerald I
June 27, 2023

Hello Amir,

 

I don't think SQL is the best way to solve this request , we have more elegant ways to achieve this like query builder ,

you may import the attached qml to your system ans run the report :

Fadel_0-1687855183386.png

Attached a video how to import and run it  

 

 

 

 

BR,

Fadel

Buiꓘa
23-Emerald III
June 27, 2023

If you only need to find the move history on a few objects, it is available on the Timeline History under the History tab directly in Windchill.

BenLoosli_0-1687873961188.png

 

17-Peridot
July 3, 2023

thank you for this solution.