Just thought I'd post this, it's a bit rough and ready but it works.
lsof +D /path
will list all processes and all the files that they have open,
that are contained within a recursive list of everything down
the filetree from /path.

Great to tell where users are running commands from,
how many files there are open, etc.

-Ashen