Workspace names and users

[BenLoosli]

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?

[STEVEG · Accepted solution]

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.

[BenLoosli]

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.

[STEVEG]

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.

[STEVEG]

Here you go.  This is for version 11.0 M030.

[BenLoosli]

That report works great. THANKS

Gives more information than I need, but that can be filtered down.

Even if I don't select the file names and paths, the report lists all 18K+ lines of the workspaces that each file is in.

[STEVEG]

I'm glad it helped.

You can modify the report.  Just remove the columns you don't need or want.

[rhart]

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

[STEVEG]

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.

[BenLoosli]

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.

[STEVEG]

This is a very good point.