Skip to main content
B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
November 29, 2021
Solved

Workspace names and users

  • November 29, 2021
  • 2 replies
  • 4347 views

As I prepare to upgrade another Windchill system next week (2 of 3), This system has some users who are no longer here. I can get their username and set the password to allow me to log into their accounts. Once in, I can delete all files (and empty workspaces) that have been checked in. New files I will work with managers on getting them checked in.

My concern is for those infrequent users who may have created a workspace, downloaded files and then did nothing. Is there a way to obtain the names of all workspaces and the users they are assigned to from an SQL query that someone can share with me? If not SQL, is there a report that can be run for listing what I need?

Best answer by STEVEG

Try using the attached report.  I developed this report many years ago and it has continued to work through a few versions of PDMLink.  I use it every time we upgrade in the weeks before the upgrade weekend to get everyone to clear their files and workspaces.

 

The column "Status" is pretty vague.  I don't really know what it is truly for.

 

If you are an admin the the View Information icon for the workspace will take you directly to the users workspace.

 

I would love to know if this worked for you.

2 replies

S
21-Topaz I
STEVEG21-Topaz IAnswer
21-Topaz I
November 29, 2021

Try using the attached report.  I developed this report many years ago and it has continued to work through a few versions of PDMLink.  I use it every time we upgrade in the weeks before the upgrade weekend to get everyone to clear their files and workspaces.

 

The column "Status" is pretty vague.  I don't really know what it is truly for.

 

If you are an admin the the View Information icon for the workspace will take you directly to the users workspace.

 

I would love to know if this worked for you.

    B
    23-Emerald III
    BenLoosli23-Emerald IIIAuthor
    23-Emerald III
    November 30, 2021

    Steve,

    It is giving me an error when I try to import the file into Windchill 11.1 M020 CPS20. It says only files exported from Windchill can be imported. I looked at the XML file and the structure seems to be very close to a report I exported from Windchill today for comparison.

     

     

    S
    21-Topaz I
    STEVEG21-Topaz I
    21-Topaz I
    November 30, 2021

    Here you go.  This is for version 11.0 M030.

      R
      rhart16-Pearl
      16-Pearl
      November 29, 2021

      Other users workspaces can be viewed, cleared or deleted from Site admin’s homepage, so you won’t need to log them in.

      S
      21-Topaz I
      STEVEG21-Topaz I
      21-Topaz I
      November 30, 2021

      I forget about that because I've been using the report for a long time and I believe that option is relatively new?  But I don't know if it has all the same functionality as if the user is logged in.

      Terms & ConditionsCookie settingsAccessibility statement