report group membership

[MikeLockwood]

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.

[bellj]

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

[bellj]

(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

[RandyJones]

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

[SteveVinyard]

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

[Sriram_Rammohan]

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

[gnatesan]

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.

[MikeLockwood]

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

[ssenthil]

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

[lnunes]

Hi Swamy.

Could you tell more about this command line?