Attempting to create query/report that would output the following in CSV format:
Folder Path | Number of Folders | Number of Files |
\\RootFolder\Folder1\SubFolder1 | 5 | 13 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder1 | 0 | 27 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder2 | 0 | 40 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder3 | 0 | 47 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder4 | 0 | 35 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder5 | 2 | 96 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder5\Sub-Sub-SubFolder1 | 0 | 23 |
\\RootFolder\Folder1\SubFolder1\Sub-SubFolder5\Sub-Sub-SubFolder2 | 0 | 20 |
So at each level we report the folder path and the # of Folders and files just at that level.
QER Version: 3.1.0
Discoveries: AD, Computer, NTFS