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

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Count of all objects in all object types in Windchill

aachanta
15-Moonstone

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
Florent
15-Moonstone
(To:aachanta)

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
aachanta
15-Moonstone
(To:Florent)

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
22-Sapphire II
(To:aachanta)

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

MikeLockwood
22-Sapphire I
(To:aachanta)

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

MikeLockwood
22-Sapphire I
(To:aachanta)

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

Top Tags