Count of all objects in all object types in Windchill

[aachanta]

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

[Florent]

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

[aachanta]

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

[aachanta]

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]

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

[MikeLockwood]

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

[aachanta]

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]

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.