Skip to main content
M
MikeLockwood22-Sapphire I
22-Sapphire I
August 1, 2013
Question

report group membership

  • August 1, 2013
  • 8 replies
  • 3172 views

ref: CS22167


From Org, Groups UI, one can see all members of each Group. There is no way to output this to a file. Cannot get info using any Windchill report.



Has anyone solved this problem (found a way to export Group membership to Excel)? We're required to periodically audit membership and this would be very helpful.

8 replies

B
bellj1-Visitor
1-Visitor
August 1, 2013
It is NEARLY impossible.
We managed it by:
- Creating a custom Oracle function that,
- populates a materialized view which is then,
- pulled into Excel via ODBC

That is the roadmap. Sorry, I can't provide any source code.

joe bell

B
bellj1-Visitor
1-Visitor
August 1, 2013
(edit)

It is NEARLY impossible.
We managed it by:
- Creating a custom Oracle function that,
- queries your LDAP,
- populates a materialized view which is then,
- pulled into Excel via ODBC

That is the roadmap. Sorry, I can't provide any source code.

joe bell
R
RandyJones20-Turquoise
20-Turquoise
August 2, 2013
On 08/01/13 14:11, Mike Lockwood wrote:
>
> ref: CS22167
>
> From Org, Groups UI, one can see all members of each Group. There is no way to output this to a
> file. Cannot get info using any Windchill report.
>
> Has anyone solved this problem (found a way to export Group membership to Excel)?
>

One possible solution is using the WindchillDS/server/bin/control-panel. You can copy an paste from
there into something or export as an ldif file.

> We're required to periodically audit membership and this would be very helpful.
>
>
> -----End Original Message-----


--
------------------------------------------------------------------------
Randy Jones
Systems Administrator
Great Plains Mfg., Inc.
1525 E North St
PO Box 5060
Salina, KS USA 67401
email: -
Phone: 785-823-3276
Fax: 785-667-2695
------------------------------------------------------------------------

S
SteveVinyard1-Visitor
1-Visitor
August 2, 2013
I've been told that you can create a Custom Report via InfoEngine that will pull the information from Windchill and the Group Membership information from WindchillDS.


[cid:image001.gif@01CE8F62.371BAA50]

Steve Vinyard
Senior Solution Architect
S
Sriram_Rammohan1-Visitor
1-Visitor
August 5, 2013

Hi Guys ,



I believe it is possible , I would suggest to create a Document Link in Library and pull a report hitting the WTGroups (DB) and pcking up users from the Groups with WC APIs.



It should work.



regads.



Sriram Rammohan

G
gnatesan4-Participant
4-Participant
August 5, 2013
1.Authenticate WindchillDS directly from java API and get the group
information.
2.get WTGroup from String format then trace its child members.
3.this feature might be OOTB feature,please check in preference also.



M
MikeLockwood22-Sapphire IAuthor
22-Sapphire I
August 5, 2013

We paid a consultant for a Windchill shell-based tool – works perfectly.

S
ssenthil1-Visitor
1-Visitor
August 5, 2013
Put together a Windchill command line tool for generating the groups and
members information.

The tool uses Windchill APIs for retrieving the groups and members. Please
shoot me a line for more information.



Thank you and have a great time.

Best Regards

Swamy Senthil

Principal Solutions Architect, Swasen Inc

swamy.senthil@swasen.com(Email); 909 800 8423(M); 973 324 2729(W); 866
908 6561(F);



L
lnunes10-Marble
10-Marble
May 6, 2019

Hi Swamy.

 

Could you tell more about this command line? 

Terms & ConditionsAccessibility statement