Report to get Empty workspace in windchill

[NK_13235355]

Dear Team,

We are seeking a report that identifies all empty workspaces in Windchill.

Has anyone previously worked on a similar requirement or developed a report for this purpose?

[Marco_Tosin]

Take a look at this discussion and see if it can help you.

https://community.ptc.com/t5/Windchill/Workspaces-with-their-sizes/m-p/1036480

[d_graham]

@NK_13235355 

Once you know which workspaces are empty what do you intend to do?

I just created a Query Report that returns the name of workspaces that have no objects.

I also wrote a sql query to do the same thing.

You need only two tables to do this so it's pretty simple.

If you intend to delete these empty workspaces, I'd recommend writing a custom Java class that you can run from a Windchill shell that gets the empty workspaces and then deletes them.

[NK_13235355]

@d_graham Currently we are checking the count of empty workspaces available in system. As you mentioned, Based on count we will decide to create utility to delete those empty workspaces.

Could you please guide me or share QML to get the empty workspace report

[NK_13235355]

@d_graham @Marco_Tosin 

I am able get the report for empty workspaces.

My concern is about the local cache now where user has activated the workspace in Creo and created new objects and those are just saved (not uploaded to Windchill)

In this case, Data is not persisted in database so workspace will still reflected as empty.