cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Best practice for getting a list of Windchill users?

SOLVED
Highlighted
Opal

Best practice for getting a list of Windchill users?

So evidently, it is not out of the box functionality to be able to see a list of all the Windchill users? I am not sure how you can manage users without seeing who has an account on your system....

So what is the best practice to get a list or report or ??? to see all the users of a Windchill system?

Ideally, I would like to have first and last name, userid, email, etc...

-marc

CAD / PLM Systems Manager

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Best practice for getting a list of Windchill users?

In that case then I'd recommend using Query Builder. Pretty straight forward.

Site --> Utilities --> Report Management. From the top right, pick "New".

On the From tab choose "Add", then select "User"

qb1.png

On the Select tab use "Add", then use the selection box next to the attribute to choose the information you want to view.

qb2.png

Chosse "save", then "choose" generate.

Select all of your chosen criteria, then click "Generate".

View solution in original post

19 REPLIES 19
Highlighted

Re: Best practice for getting a list of Windchill users?

Are you willing/able to look directly at the database or do you want to do this from Windchill?

Highlighted

Re: Best practice for getting a list of Windchill users?

Hey Tom,

Either one at this point. I am a little leery of messing with the database, so my preference would be to do this from Windchill.

-marc

Highlighted

Re: Best practice for getting a list of Windchill users?

Highlighted

Re: Best practice for getting a list of Windchill users?

Yogesh,

Thanks for the link, and it looks like that would work quite well. I just wasn't able to figure out how to load the report into Windchill. I followed the link on how to load the qml file using the command line but had my syntax or something wrong....

Highlighted

Re: Best practice for getting a list of Windchill users?

You can use Org - Utitlities - Report Management utility to import qml.

Highlighted

Re: Best practice for getting a list of Windchill users?

Dang! Are you sure it is okay to do that? It is ALMOST too easy, I can't believe they did that on purpose. Don't tell anyone, or they will take it away....

Highlighted

Re: Best practice for getting a list of Windchill users?

In that case then I'd recommend using Query Builder. Pretty straight forward.

Site --> Utilities --> Report Management. From the top right, pick "New".

On the From tab choose "Add", then select "User"

qb1.png

On the Select tab use "Add", then use the selection box next to the attribute to choose the information you want to view.

qb2.png

Chosse "save", then "choose" generate.

Select all of your chosen criteria, then click "Generate".

View solution in original post

Highlighted

Re: Best practice for getting a list of Windchill users?

By the way, "Disabled" users are those who have been deleted from Windchill. This is seen by the addition of {wt.org.WTUser:<uid>} to the front of their username. (This allows the same username to be created again in the future without affecting the last user with this same username.)

"Repair Needed" users are those who are currently disconnected. These are users who DO have accounts in Windchill but are no longer visible in the LDAP (Windchill DS, Active Directory, etc.)

Highlighted

Re: Best practice for getting a list of Windchill users?

Hey Tom, I have a quick question about the user list; how would I get a list of users who belonged to a certain group? In my case I have a group setup called "Engineering". Thanks in advance!

Buddy Hudson

Highlighted

Re: Best practice for getting a list of Windchill users?

You can view the group membership in Site --> Utilities --> Participant Administration.  Simply select the group and then view it's properties.

Highlighted

Re: Best practice for getting a list of Windchill users?

Hey Tom,

Got that, but how to export those names from Windchill into something I can present to someone?

Thanks,

Buddy

Highlighted

Re: Best practice for getting a list of Windchill users?

Highlighted

Re: Best practice for getting a list of Windchill users?

If you have just 1 group then as Tom said that is the approach, if you have many groups and get a report on that, you have to write a custom utility which would list out all the groups and members of those groups.

Thanks

Binesh

Highlighted

Re: Best practice for getting a list of Windchill users?

When I click on the Report Management link, the Report Management window opens but is blank.

I have admin rights. We are on Windchill PDMLink 10.2 M020-CPS05

 

Highlighted

Re: Best practice for getting a list of Windchill users?

Have to understand a few key things about how users and groups are managed.

1. User accounts are created in Windchill Directory Server; this may or may not have been set up to tie into your network in a variety of ways.

2. Group membership is held only in Windchill Directory Server and Windchill query builder reports cannot reach into this info and report on it.

3. When a user logs on, a record for that user is created in the database and remains there regardless of what is done in Windchill Directory Server.  User accounts can be reported on using query builder.  The table is wtuser.

So - Easy to get reports about user accounts.  Major hassle to get reports on groups.

Also - Groups may be defined at Site, via Participant admin, or at Org, via either Org/Groups or Org/Participant admin.  From Site, you cannot see Org-level Groups.

An alternative to get Group info is to go to the Windchill desktop, launch Windchill Directory Server, select Manage entries, get a group to show in the listing, then simply click in that window and select all, copy, bring out to Excel.

Highlighted

Re: Best practice for getting a list of Windchill users?

Thanks. But I found a workaround for getting a list of users. I added the Groups to the participant Admin table. Once in the table, I clicked on the View Info icon for each group and the list of members within that group is listed.

Highlighted

Re: Best practice for getting a list of Windchill users?

Cliff,

 

Can you explain how you did this? I think it will be a great help for all admins.

Highlighted

Re: Best practice for getting a list of Windchill users?

See attached....

Highlighted

Re: Best practice for getting a list of Windchill users?

Thanks Cliff!

Announcements