Skip to main content
JH_107358521-Visitor
1-Visitor
July 12, 2023
Solved

How do I export windchill usernames?

Hello,

I am looking for a way to export all the usernames in the windchill system. Ultimately the goal probably will be to import those names into an excel spreadsheet. Any suggestions? 

HelesicPetr
HelesicPetrAnswer
22-Sapphire II
July 12, 2023

Hi @JH_10735852 

Use the query builder (Report Manager)

Create new report with wt.org.WTUser type and select what you need.

 

HelesicPetr_0-1689145674172.png

HelesicPetr_1-1689145747260.png

HelesicPetr_3-1689145828275.png

PS> the results can be exported to a excel 

 

PetrH

View in thread

5 replies

HelesicPetr
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
July 12, 2023

Hi @JH_10735852 

Use the query builder (Report Manager)

Create new report with wt.org.WTUser type and select what you need.

 

HelesicPetr_0-1689145674172.png

HelesicPetr_1-1689145747260.png

HelesicPetr_3-1689145828275.png

PS> the results can be exported to a excel 

 

PetrH

Translate
    MarcoTosin
    MarcoTosin21-Topaz II
    21-Topaz II
    July 12, 2023

    These are good point to start working on reporting

     

    https://www.ptc.com/en/support/wnc-reporting-landing/wnc-reporting-landing-main/

     

    [Knowledge Hub] Windchill PLM - Business Reporting(WBR)

     

    Below some report already available on users

     

    Report which lists the user with its associated profile

     

    Report to list all the Users in Organization

     

     

    Translate
    Marco
      jbailey
      jbailey18-Opal
      18-Opal
      July 12, 2023

      If you are on WC 12 .0 or newer, you can export directly from the members table of a group (if you have a group with everyone in it)

       

      jbailey_0-1689166740041.png

       

      Translate
        ScottMorris
        ScottMorris17-Peridot
        17-Peridot
        July 12, 2023

        Take a look at this CS Article, maybe you can add the button where you want it?

        https://www.ptc.com/en/support/article/CS172939

        Translate
        JH_107358521-VisitorAuthor
        1-Visitor
        July 13, 2023
        @JH_10735852 wrote: 

        Hello,

        I am looking for a way to export all the usernames in the windchill system. Ultimately the goal probably will be to import those names into an excel spreadsheet. Any suggestions? 

        @HelesicPetr  Thanks for the response. This is really worked well for me. 

        Translate
        Terms & ConditionsAccessibility statement