SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc , mirroring_failover_lsn FROM sys.database_mirroring WHERE mirroring_guid IS NOT NULL; Also you could take help of another catalog view for the Witness server information by returing relevant descriptive session information about the witness...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/08/19/get-basic-database-mirroring-information-principal-or-mirror.aspx