This report combines file extensions in to categories. The report uses the srs.current_fs_scandata database view which limits the scope to current scans only. The scope is further limited by the sd.fullpath LIKE portion of the sql where clause. If you remove it, the report will run across all current scan_data.
This recipes comes in two versions, a Detailed version and a Summary version.
You will need to modify the path line 32 of the desired query.