report group membership
‎Aug 01, 2013
03:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 01, 2013
03:11 PM
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.
Labels:
- Labels:
-
Other
9 REPLIES 9
‎Aug 01, 2013
03:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 01, 2013
03:26 PM
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
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
‎Aug 01, 2013
03:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 01, 2013
03:30 PM
(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
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
‎Aug 02, 2013
10:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 02, 2013
10:02 AM
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
------------------------------------------------------------------------
>
> 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
------------------------------------------------------------------------
‎Aug 02, 2013
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 02, 2013
12:25 PM
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
[cid:image001.gif@01CE8F62.371BAA50]
Steve Vinyard
Senior Solution Architect
‎Aug 05, 2013
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 05, 2013
07:31 AM
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
‎Aug 05, 2013
11:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 05, 2013
11:51 AM
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.
information.
2.get WTGroup from String format then trace its child members.
3.this feature might be OOTB feature,please check in preference also.
‎Aug 05, 2013
11:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 05, 2013
11:57 AM
We paid a consultant for a Windchill shell-based tool – works perfectly.
‎Aug 05, 2013
05:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 05, 2013
05:07 PM
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);
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);
‎May 06, 2019
08:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎May 06, 2019
08:38 AM
Hi Swamy.
Could you tell more about this command line?