SELECT  DB_NAME(database_id) AS 'Database' ,

        mirroring_role_desc ,

        mirroring_state_desc

FROM    sys.database_mirroring

WHERE   mirroring_guid IS NOT NULL ;