The fileproperty function needs to be used in the context of the database.  I plan to call this from an MS Access database (I will convert it to .Net later) looping through each database on the server.  I will also be using this on multiple servers.

My plan is to use this to determine file growth, space issues, and to help project future disk space needs.