How do I generate a report of members in a product container?

Forum|Forum|6 years ago
January 23, 2020
3 replies
2424 views

Greetings all.

I want to generate a report, in Excel format if possible, that shows all the members of a product container in Windchill 11.0. I would like the report to expand any groups that are in the container to show the members of the group also. I am wanting to avoid having to copy and paste and then manually update the list.

I would ideally like the report to look something like this:

Member Role Email

Joe Shmoe Observer Joe.Shmoe@xyzcompany.com

CAD Designers Group

Jim Shmoe Observer Jim.Shmoe@xyzcompany.com

I hope that this is understandable. If you know of a way to accomplish this, please let me know. Any assistance that can be offered, would be greatly appreciated.

Other

Best answer by Marco Tosin

There is an old article that comes from the ptcuser migration that I'm using to get groups-->users relation.

You must use a Java method in your query builder to get this relation.

Please take a look at this article https://community.ptc.com/t5/Windchill/Reporting-Groups-and-Users/m-p/220306

Here you can read a PTC article on Using Java Methods in Query Builder in Windchill

Both articles are collected in this document Resource for reporting

M

MikeLockwood

22-Sapphire I

Site, Utilities, Report Management, New Report

Type: Container Team

select various reportable items (e.g. Name (of the Context), Roles, Members Map)

joe_morton

18-Opal

I have a report for group members, but I don't think it can get information on Groups. My understanding is that Group data comes from the LDAP server, and the queries you an develop in Windchill can't access data in the other server.