This looks to be an excellent utility. However, on my server when I run the exec for the SP I get the following error message:
Msg 8114, Level 16, State 5, Procedure RecordLargeOSFiles, Line 99
Error converting data type varchar to bigint.
The part of the SP that seems to have issues is:
select #FilePaths.FilePaths, #FilePaths.[FileName], Convert(BigInt, FileSize) FileSize, Convert(DateTime, FileDate), GetDate()
join #FileScan on Rtrim(Ltrim(#FilePaths.[FileName])) = Rtrim(Ltrim(#FileScan.[FileName]))
where Convert(BigInt, FileSize) > 10000000000