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

report group membership

Moonstone

report group membership

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.

9 REPLIES 9

report group membership

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

report group membership

(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

report group membership

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
------------------------------------------------------------------------

report group membership

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

RE: report group membership

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

report group membership

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.



RE: report group membership

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

report group membership

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);



Re: report group membership

Hi Swamy.

 

Could you tell more about this command line? 

Announcements
LiveWorx Call For Papers Happening Now!