File count and file size by location request

Hi, Can I please ask how its possible to get a summarised view of files and their sizes from a report?  

I need to create a list showing by shared drive and last accessed date how many unique files and how large they are. for example:

 
Shared drive Location                Number of Files             Size (GB)                  Year last accessed
UK                                                          156326                 500                                       2012
UK                                                          456895                 650                                       2013 etc etc

At the moment all I am able to pull is a full huge list of all files and their size by last accessed dates which is becoming very cumbersome.  I just need the summarised view as above if that is possible?

Thanks Mark

Parents Reply Children
No Data