Check open files and folders on a Windows server

I have a couple of networked apps where it can be useful to check which user has a certain file open (often because the app didn't close cleanly) on a given server. This is found in the Computer Managment console under System Tools -> Shared Folders -> Open Files.