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

    Ah.  I am on 12.0.1.2 so it probably won't work.

     

    We just upgrade at the end of Aug and we still have our 11.0 servers running.  Actually, they are being turned off tonight.  I will export them and upload them.

      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.

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

      I have used that option in the past. But what if you don't know if user XYZ even has a workspace. At one point the original system admin put everyone into Windchill, over 300 users. We are not licensed for that many, so with Windchill 11.1, we removed or marked as no longer here over 200 users from Windchill. It is that list of workspaces to users that I need to be sure I get them all for the upgrade.

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

        This is a very good point.

          Terms & ConditionsCookie settingsAccessibility statement