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

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Create a report showing what roles/groups/tasks are assigned a specific user

Create a report showing what roles/groups/tasks are assigned a specific user

Right now there is no easy way (only by customization) to identify where the user is currently located.  This way, we know what teams need to be updated with a replaced user.

Example:

     - User A is located in Product "Bicycle", creator of Part "Wheel", and Review member task on CN "New Tire Specs".

16 Comments
ptc-4494955
1-Newbie

I have a suggestion for another requirement for this product idea:

  • The report manager will have a report that lists all groups, let's call it 'Groups Report'
  • 'Groups Report' will list all members of each group. Example:
Group NameSite Level? (Yes/ No)Org Level? (Yes/No)User
XYZ TeamYesNoMario Speedwagon
XYZ TeamYesNoPetey Cruiser
XYZ TeamYesNoAnna Sthesia
XYZ TeamYesNoPaul Molive
XYZ TeamYesNoAnna Mull
XYZ TeamYesNoGail Forcewind
XYZ TeamYesNoPaige Turner
XYZ TeamYesNoBob Frapples
Team 1NoYesShonda Leer
Team 1NoYesBrock Lee
Team 1NoYesMaya Didas
Team 1NoYesRick O'Shea
Team 1NoYesPete Sariya
Team 1NoYesMonty Carlo
Skunk WorksYesNoHal Appeno
Skunk WorksYesNoOtto Matic
Skunk WorksYesNoMoe Fugga
Skunk WorksYesNoGraham Cracker
Skunk WorksYesNoTom Foolery
Skunk WorksYesNoAl Dente
Skunk WorksYesNoBud Wiser
Skunk WorksYesNoPolly Tech
Skunk WorksYesNoHolly Graham
Skunk WorksYesNoFrank N. Stein
  • The report manager will have a report that lists Contexts, Roles, groups, and users in the following manner:
ContextRoleGroupUsers
Product ACIBProgram 1 CIB TeamCharlie Brown
Product ACIBProgram 1 CIB TeamBob Smith
Product ACIBProgram 1 CIB TeamSuzan Wright
Product ACIBProgram 1 CIB Teametc.. All users in this group
Product ACRBProgram 1 CRB TeamFrank Review
Product ACRBProgram 1 CRB TeamTom Hankel
Product ACRBProgram 1 CRB TeamRebecca Entwistle
Product ADesignerSr Team DesignersKatharine Heigel
Product ADesignerSr Team DesignersPaula Thomas
Product ADesignerSr Team DesignersJohn Henry
Product ADesignerSr Team DesignersLisa Mac
etc encompassing … all roles in Product A
Product BCIBProgram 1 CIB TeamBob Smith
Product BCIBProgram 1 CIB TeamSuzan Wright
Product BCIBProgram 1 CIB TeamLinus Blant
tswett
12-Amethyst

That sounds like a good way to look at it.  And if this report can export to CSV, we can do pivot tables and filtering.

JimTVancouverCa
1-Newbie

That looks like my post, but it's marked ptc-4494955.... weird.

PTCModerator
Emeritus
Status changed to: Acknowledged
 
siddu
3-Visitor

Any way to achieve this need in OOTB Feature

pkumar-9
3-Visitor

This will be one of the useful report, if any one develop. Please let me know.

rsutherland
4-Participant
It is really outrageous that PTC has not provided this already. This is basic information. PTC, quit dragging your feet and get-er-done.
JHall
16-Pearl

This really would be great to have as an OOTB report. 

jpadmanabhan
3-Visitor

This will be a very useful report..

shinyagrahari
5-Regular Member

so many votes yet no news on the report 😞 

josepsb
6-Contributor

I would like to have also this report in the OOTB

pmorton
3-Visitor

So what is the customization that is required? Has anyone figured it out?

MichaelTheriot
3-Visitor

If you need a Groups report you can add the following to Windchill/conf/queryBuilderMethods.xml:

<method class="wt.org.WTGroup" name="isMember"/>

 

Then create a new report:

  1. Tables: Principal and Group
  2. Select: Principal, Group, and Java Method wt.org.WTGroup->isMember [input: Group, Principal]

 

That will generate a report cross joining all principals and groups plus a boolean indicating if the principal is in the group. From there you can constrain it to what you are specifically interested in. It might not be very performant for large queries.

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<qml bypassAccessControl="false" caseInsensitive="true" addTimeToDateFields="false" mainType="Group (wt.org.WTGroup)" joinModel="false" xsi:noNamespaceSchemaLocation="qml.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <query>
        <selectOrConstrain distinct="false" group="false">
            <reportAttribute heading="Principal" reportAttributeId="Principal" userCanSelect="true" userCanConstrain="false" alwaysSelect="false" defaultValue="" constantValue="" isMacro="false">
                <object alias="Principal" propertyName=""/>
            </reportAttribute>
            <reportAttribute heading="Group (wt.org.WTGroup)" reportAttributeId="Group_wt_org_WTGroup_" userCanSelect="true" userCanConstrain="false" alwaysSelect="false" defaultValue="" constantValue="" isMacro="false">
                <object alias="Group (wt.org.WTGroup)" propertyName=""/>
            </reportAttribute>
            <reportAttribute heading="isMember" reportAttributeId="isMember" userCanSelect="true" userCanConstrain="true" alwaysSelect="false" defaultValue="" constantValue="" isMacro="false">
                <script className="wt.org.WTGroup" name="isMember" type="">
                    <object alias="Group (wt.org.WTGroup)" propertyName=""/>
                    <object alias="Principal" propertyName=""/>
                </script>
            </reportAttribute>
        </selectOrConstrain>
        <from>
            <table alias="Principal" isExternal="false" xposition="0px" yposition="40px">wt.org.WTPrincipal</table>
            <table alias="Group (wt.org.WTGroup)" isExternal="false" xposition="0" yposition="80">wt.org.WTGroup</table>
        </from>
    </query>
</qml>

 

praynaud
4-Participant

Why can't we have OOTB report like this one?

This is the only way for ITAR restriction to control that a user could or could not access to information.

buenosroas
11-Garnet

I presume that this should become more feasible now that groups no longer are stored in LDAP but in the database instead. There's still the issue of nested groups and roles in contexts, but I think that this should be a much lower hanging fruit than it was before. Have my upvote. I hope that we'll see this one sooner rather than later.

pmorton
3-Visitor

Thank you for the upvote. Our vendor was able to make some custom code to run from the Windchill shell that would ‘untangle” the relationships and provide a cvs file of the relationships. This file is then easily manipulated in excel to report the relationships. Not real time but good enough to audit the system efficiently.

Paul