Skip to main content
J
jw_CS14-Alexandrite
14-Alexandrite
August 20, 2025
Solved

Workspaces with their sizes

  • August 20, 2025
  • 2 replies
  • 1190 views

Version: Windchill 12.1

 

Use Case: List All workspaces with its size (and User / Context)


Description:

I want to have a list (per user) of all workspaces together with their sizes.

Over here there are some topics about it, but i followed this Support Article: https://www.ptc.com/en/support/article/CS412883

The initial part workout. I got now al list of all workspaces with their corresponding user and workspace. But i am unable to figure out how i can add the size per workspace to it. I have tried to add `EPMSupporting data` (`EPMSupporting data.Data`)and that looks more like the blobname or so.

 

Any ideas how to do this? If not plain "reportable item" workflow a little explenation help I'm not that deep in sql or java

 

Best answer by LewisLawrence

Attached a couple of QML files, one that returns all the workspaces and sums the filesizes in them, so one row per workspace. The other that just lists all the EPMDocuments and their filesizes, one row per Document per workspace.

2 replies

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

I created this Query Builder report with this Table joins:

avillanueva_0-1755777020065.png

I modified it to include a count of workspace members but it has the effect of not displaying empty workspaces. I tried fiddling with the outer joins but it still shows only ones with content. Perhaps its the constraint. To match what you see on screen, you have to filter out baseline members that are EPMSepFamilyTable objects. See zip of QML below.

 

J
jw_CS14-AlexandriteAuthor
14-Alexandrite
August 22, 2025

I have to check it out how this give me the size / storage space of an workspace. somehow i don't see the link in your solution and what i need...

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

You should see a zip for download of a QML file which you can import to your server. That should add the report. It will not give you storage size as I assumed you wanted object count. Not sure how storage size would help you any. On the server size, the workspaces are just like baselines of objects. Locally, yes, workspaces do have local copies of downloaded and modified sizes. Are you having space issues locally with user's workspaces? Here is information how you can managed that:

https://www.ptc.com/en/support/article/CS37763?source=search

But the local cache size is combined for all workspaces since that is how its managed. All files exist in a single folder whether downloaded (sid) or modified (lid). If you still need to get an estimate of filesize, you would need to add in joins to the baselinemember to EPMDocument then to Application Data which is where you can total up filesize for the objects in the workspace. Still confused how this report would be of any use.

L
LewisLawrence13-AquamarineAnswer
13-Aquamarine
October 1, 2025

Attached a couple of QML files, one that returns all the workspaces and sums the filesizes in them, so one row per workspace. The other that just lists all the EPMDocuments and their filesizes, one row per Document per workspace.

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    February 11, 2026

    Thank you very much, Lewis.

     

    Since the report extracts the size in bytes, I added a modification to your function that calculates the space occupied by the workspaces.

     

    Basically, the sum is then divided by a number that converts the bytes into MB, and the value is then rounded to the third decimal place.

     

    Marco_Tosin_0-1770816999319.png

     

     

    Marco
    Terms & ConditionsCookie settingsAccessibility statement