Final Cut Server is a fine asset management system. Its real promise, though, lurks within its system for watching for arbitrary events and triggering actions. At WWDC this June, Apple wowed a few hundred people with a demonstration of this capability. Apple has now released the code and documentation of this demo.
Download the documentation and code in the "Web-Based Review & Approval" section of the Final Cut Server Resources page.
Here's the demo, in short. Using the FCS Client, click an asset's "Send to Web for Review" checkbox. This triggers FCS to compress and export a version of the movie, then add a record to an external database. A Ruby-on-Rails app reads the database and displays the movie in a web page for approval. Once approved, the Rails app sends XML to a drop folder, which is read by FCS, recording approval and completing the round trip.
It is a bit of work to get it working, but the demo touches all facets of FCS. It's a great eduction.