Skip to main content
V
Vignesh_AJ_778-Gravel
8-Gravel
August 26, 2025
Question

Taking report to know 'view' only access user's last login time

  • August 26, 2025
  • 2 replies
  • 659 views
I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.2.0

I need to take a report from windchill to see user's who has only 'view' access, their last login time to windchill. Is there way a to extract this information?

    2 replies

    joe_morton
    18-Opal
    joe_morton18-Opal
    18-Opal
    August 26, 2025

    Probably the easiest way to get some data is to go to Site -> License Management, then go to the Report tab. You can run a report on the period you specify. It gives some data that might get you close to what you're looking for.

    V
    Vignesh_AJ_778-GravelAuthor
    8-Gravel
    August 27, 2025

    Thanks. But I could not find License management option under site in windchill. I have database access. Do you know any table where I could pull this information: View access user's last login time. 

    avillanueva
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    August 27, 2025

    Combined with the reports provided by @Marco_Tosin , you can export the PTC View and Print Only License group. You can do this from the partipants administrator. Select on the group and export to CSV. The two Excel extracts can be joined by the username to give you what you want.

    avillanueva_0-1756300085543.png

    avillanueva_1-1756300131261.png

     

     

    avillanueva
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    August 26, 2025

    What is your ultimate goal? Is this a one time extract or something you need to run many times? There should be a report of active users and their last logins. If you do not have that, let me know since I can extract QML for that. Now to know if they are a View and Print iser, only have view access, you just need to extract that group. Should be able to cross merge those extracts in Excel to get what you need. Note that this does not say anything about the user's access over time. A user could have been removed from the View and Print group or recently added. All you can tell is that they are currently in that group now. Let me know if you need further help.

    V
    Vignesh_AJ_778-GravelAuthor
    8-Gravel
    August 27, 2025

    Thanks for the response. My goal is to extract the list of users who has only view access and their last login time. This is a one time report I need. I have database access. Do you know any table where I could pull this information: View access user's last login time. 

    Terms & ConditionsCookie settingsAccessibility statement