SQL mirroring partners

select db_name(database_id),mirroring_partner_instance, mirroring_witness_name from sys.database_mirroring where mirroring_guid is not null