Ensemble provides a tool for generating HTML or PDF documentation for a production. This documentation includes all interfaces and any directories they read from or ports they listen on or ip addresses/ports they connect to, all together in a convenient list.
To get to this documentation, on the production configuration page, click the "Production Settings" link which should be just above the Operations column, and then select the actions tab on the right side and there should be a "Document" button.
You mentioned you're also looking for the information seen on the production monitor, such as message counts, but in a simpler view. There isn't really a more simple view of this, but if you want to try to use SQL to get the data, I would start with the Ens.MessageHeader table. There is a single Ens.MessageHeader row generated for every message sent from one component to another within a production.