Modified History

[Amirtharaj_K]

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

[Fadel]

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.

• 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

[Amirtharaj_K]

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 · Accepted solution]

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 :

Attached a video how to import and run it  

BR,

Fadel

[Marco_Tosin]

Hello Fadel,

it is possible for you to link this discussion to article How to get a details of Move History table from database for WTPart?

Thanks

[Fadel]

Hello Marco,

I can only link an enhancement community post to an article.

Now the post has the article link and windchillers may refer to the article for documentation

BR,

Fadel

[HelesicPetr]

Hi @Fadel 

Can you just add a link to the article (resolution) that points to this discussion? 

PetrH

[Fadel]

@HelesicPetr  let me check internally with the EU Knowledge Manager and let you know .

[Fadel]

@HelesicPetr  & @Marco_Tosin  done , the article has now a link to this thread .

[Amirtharaj_K]

thank you for the video & qml file, Mr. Fadel it's really helped me to how we can use report management & as well as how we find the history of Data.

[BenLoosli]

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.

[Amirtharaj_K]

thank you for this solution.