Create "Files" custom report source

Note: testing is easier on a brand new site, although can be tested equally on an older site, but there will likely be a lot more data being reported on

Create some files

1. Log in as admin
2. Navigate to Profile
3. Edit profile
4. Add a User picture and save
5. Create a new course
6. Add a Course image and save

Create report

1. Navigate to Reports in user menu
2. Create new report from Files report source
   • Ensure Include default setup is checked
3. Confirm presence of the following columns, with accurate data (note: as per start of testing instructions, there may be many more rows than just the files you created if using an existing site with historical data):
   • Context
   • Full name
   • Filename
   • Type
   • Size
   • Time created
4. Open Conditions in editor
5. Confirm File > Directory condition is equal to No
6. Confirm no directory entries are present in the report
7. Set File > Directory condition to Is any value and apply
8. Confirm directory entries are now present in the report
9. Set File > Directory condition value back to No and apply
10. Delete the following columns from the report:
    • User > Full name
    • File > Type
    • File > Time created
11. Set aggregation for File > Filename column to Count
12. Set aggregation for File > Size column to Sum
13. Confirm report now shows count of files, and sum of filesize for each context
14. Open Sorting in editor
15. Sort by Size descending
16. Confirm report is ordered correctly
17. Add the following columns to the report:
    • File > Plugin
    • File > Area
    • File > Item ID
18. Confirm report now shows count of files, and sum of filesize for each context/plugin/area/itemid