topic Re: 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? in Windchill Customization

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 — Fri, 15 Mar 2024 15:02:53 GMT

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

Re: 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?

TomU — Tue, 12 Jul 2016 14:56:56 GMT

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.

Re: 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?

TomU — Tue, 12 Jul 2016 15:16:15 GMT

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

Re: 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?

KD — Fri, 29 Jul 2016 09:37:41 GMT

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