cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Count of all objects in all object types in Windchill

aachanta
13-Aquamarine

Count of all objects in all object types in Windchill

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

6 REPLIES 6

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

Florent ROUSSEL
www.4cad.ca

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

 
 

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

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

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

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.

Announcements
Learn more about how we are using our browser poll here