In which table are the Windchill user credentials are stored in Database ?

[aachanta]

Hi All,

In which table are the Windchill user credentials stored in Database ? Is it WTUser or any other table ?

And within Windchill DS as well we can see the user name, password email etc. So in which other table it does store ?

Can you please let me know.

Thanks and Regards,

Aditya Achanta

[BineshKumar1]

Windchill does not store password in database. It is stored in Windchill Directory Server. WTUser table store almost all the user details except password like full name, username, email, status and so on. Remoteobjectid table stores the dn of each user and it is used to locate the user in ldap. Remoteobjectinfo is where associated adapter info is stored.

Regards

Binesh Kumar

Medtronic - MITG

[aachanta]

Hi Binesh,

Thank you.

Where can we see the version, revisions or iterations in DB for a particular object like WTPart etc. ?

Thanks and Regards,

Aditya Achanta

[BineshKumar1 · Accepted solution]

All versioned objectshave a child table and a master table. So WTPart, there is a WTPart and WTPartMaster. Query the WTPart table for version and so on and WTPartMaster for name, number etc.

[aachanta]

Hi Binesh,

Thanks a lot for the information.

As you say it is Versioned objects ? Can you list few Non Versioned Object names in Windchill ?

And apart from Versioned, Non Versioned is there any other object type like Iterated etc ? Can you please let me know about it.

Thanks and Regards,

Aditya Achanta

[BineshKumar1]

Version objects are like - docs, parts, changes and so on . eg of Non versioned object - promotion