Skip to main content
11-Garnet
Nov 13, 2023 5:57 PM UTC
Question

Help with Report Builder to give Windchill DS bind CN information for Windchill user accounts

I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.2.1

i need to run a report showing the list of windchill users and the Windchil DS Bind CN information for each account. I am preparing a list of users so that I can use the Disconnected Participant tool for my WindchillDS users prior to upgrade to HTTPS.Is this possible using the report builder function in Windchill PDM link and if so how?

6 replies

avillanueva
23-Emerald II
Nov 13, 2023 6:23 PM UTC

Yes, you want to include the RemoteObjectID and RemoteObjectInfo table to your query and join with WTUser. This shows the path in the LDAP for that user.

Translate
10-Marble
Nov 13, 2023 9:12 PM UTC

Hi Antonio,

Didn't know this - very helpful.

 

Differences for openDJ vs. Windchill DS?

What is the join type for the query?

Translate
avillanueva
23-Emerald II
Nov 13, 2023 9:26 PM UTC

Windchill DS is OpenDJ with some PTC tailoring. I am using OpenDJ currently after hopping through Windchill DS temporarily during upgrade from 11.1. No difference from this perspective. 

Do you have a SQL table viewer? Its very easy to see the columns and see how they related.  You would want an outer join in case there is a user who did not have a mapping in the LDAP.

Translate
18-Opal
Nov 15, 2023 9:59 AM UTC

Hello tjerome,
Thanks for reaching out, this is Charles from PTC Technical Support in Europe.
Was the information provided helpful somehow?
KR,

Charles.

Translate