How can I get a report out of Windchill 10.2 with number and sizes and/or total size of a specific file type(s) .dwg .asm .gp4 in the vault?

[troberts]

Need to pull a few reports containing the number of files of each type .dwg .asm .gp4 for example... and the amount of space these files/total of each type currently consume. 

Trying to plan for integration of other data from acquisitions and future expansion and need these numbers and info to calculate this...running under Windchill 10.2 M040.

Thanks!

Tim

[TomU]

The file type and size is stored in the database.  It's easy enough to query for the number of files.  I imagine you could simply read the stored files sizes and sum them.   It might be even easier to simply use the built in OS search tools on the vault....

Start here:  https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS148890

Edit:  Actually the OS tools won't help since the file names are obscured.  Need to go at this from the DB.

[TomU]

Here is a previous discussion covering a similar question:  Re: How to determine the number of unique part numbers site wide in Windchill?

[KD]

Hi,

This case contains a SQL query which will give you the information about the file name , number, location and size.

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS238721

BR,

Kaushik