Skip to main content
A
aachanta15-Moonstone
15-Moonstone
August 20, 2018
Question

Count of all objects in all object types in Windchill

  • August 20, 2018
  • 4 replies
  • 5142 views

Hi All,

 

If I want to get the count of all the objects in all object types how would I be getting the same ?

 

Is there any nested query or program for the same. Please let me know about it

 

Best Regards,

Aditya

4 replies

F
Florent_2743661-Visitor
1-Visitor
August 20, 2018

Hi,

 

You should take a look on the QueryBuilder  / Reports.

Depending on whether you want the count per sub type, you may have to  join the table per typedefinition.

 

Florent

A
aachanta15-MoonstoneAuthor
15-Moonstone
August 22, 2018

Hi

 

How would I get the results if I want to get all the document, part objects, folder count, change request and other objects which can be versionable or non versionable in one single query ?

 

is it possible for us to have one script for that ?

 

If yes can you please let me know like how can that be done.

 

Best Regards,

Aditya

 
 
avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
August 20, 2018

Do you have access to the database? Toad can should you table counts very easily.

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
August 20, 2018

Run simple queries against the database for each object type.

 

For CAD:

select count(*) from epmdocumentmaster to get all unique (e.g. 123.prt, 455.prt).

select count(*) from epmdocument to get all versions (e.g. 123.prt A.1, 123.prt A.2, 123.prt B.1 etc.).

 

For WTDocuments:

select count(*) from wtdocumentmaster to get all unique

select count(*) from wtdocument to get all versions

 

For WTParts if used:

select count(*) from wtpartmaster to get all unique

select count(*) from wtpart to get all versions

A
aachanta15-MoonstoneAuthor
15-Moonstone
August 22, 2018

Hi Mike,

 

How would I get the results if I want to get all the document, part objects, folder count, change request and other objects which can be versionable or non versionable in one single query ?

 

is it possible for us to have one script for that ?

 

If yes can you please let me know like how can that be done.

 

Best Regards,

Aditya

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
August 22, 2018

For this, I'd suggest to query (in Windchill, not directly to the database) as count(*) against wtObject, and then apply Group By to the Object Type.  Runs into a bit more but can be done.

May lead to a small consulting gig.

Terms & ConditionsAccessibility statement