Type property (for example Document 4 files) query

The best way to perform this type of analysis is by using an external reporting database where you can export vault metadata.

When you export document metadata, the reporting database also includes a Document_Files table. This table lists every file on its own row, whether the document is single-file or multi-file. You can then run database queries or use a reporting tool like Microsoft Power BI to analyze the number of files within multi-file documents.

Example: Files in a multi-file document share the same document ID.

The best way to perform this type of analysis is by using an external reporting database where you can export vault metadata.

When you export document metadata, the reporting database also includes a Document_Files table. This table lists every file on its own row, whether the document is single-file or multi-file. You can then run database queries or use a reporting tool like Microsoft Power BI to analyze the number of files within multi-file documents.

Example: Files in a multi-file document share the same document ID.

Thank you for your quick answer.

If I think correctly, this is an separated paid solution, isn't it?

We don't have licence to Reporting and Data export function and we don't even plan to, because we only analyze it once or twice a year. Is there any way to solve it without extra fee?

Best regards

The Reporting module is included in certain subscription plans, so it's a good idea to confirm this with your M-Files representative or reseller.

You may also want to discuss alternative approaches for the analysis with them.