Skip to main content
V
vuchekar1-Visitor
1-Visitor
April 10, 2014
Question

Extract all Groups, user and its profile related information by java code

  • April 10, 2014
  • 2 replies
  • 10614 views

Hi All,

i need to extarct all Groups, Group Member and user related information in tabular manner by using java code.

Please any one give me some idea how i can achive this requirement.

Thanks,

Vivek

    2 replies

    M
    22-Sapphire I
    MikeLockwood22-Sapphire I
    22-Sapphire I
    April 10, 2014

    Every Windchill system admin needs this. This exact question has been posted to the world at least 1,000,000,000 times that I'm aware of. It's pretty incredible that at release 10.x PTC has not provided any way to extract this info. We paid a consultant to create a report. Others export from Windchill DS and parse in innovative ways in Excel.

    The needed info is at Org, Groups (or possibly Site, Util, Participant admin). There is just no way to output the results currently.

      P
      ptc-51975531-Visitor
      1-Visitor
      April 11, 2014

      Vivek, if you are familiar with customization, you can use the Windchill APIs (refer to Windchill javadoc) to write a java class that extracts this information in a required format. You can look for helper and service apis related to WTUser, WTPrincipal, WTGroup classes along with the QuerySpec.

      Another option is to create a custom report using Query Build (Report Manager), but that is way too complex. You might want to consider it only as last resort.

      M
      22-Sapphire I
      MikeLockwood22-Sapphire I
      22-Sapphire I
      April 11, 2014

      Query Builder can't reach into LDAP.

      P
      ptc-51975531-Visitor
      1-Visitor
      April 11, 2014

      True, Mike. But every LDAP user who once logs into Windchill would have an entry in the windchill database table, from where you can query the record, using either query builder or java code.

      Terms & ConditionsCookie settingsAccessibility statement