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

Forum|Forum|2 years ago
November 13, 2023
2 replies
1957 views

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?

Other

avillanueva

23-Emerald I

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.

M

ML_10694804

10-Marble

Hi Antonio,

Didn't know this - very helpful.

Differences for openDJ vs. Windchill DS?

What is the join type for the query?

avillanueva

23-Emerald I

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.