Send Port and Host instance Mapping in BizTalk

Here below code will give list of send ports available  with BizTalk without mapping details . best way to query against the Management DB tables to find out the mapping between send Port and the host instance

select sndport.nvcName as 'HostInstaceSendPort',

hostInstace.Name as 'HostInstanceName' ,hostInstace.LastUsedLogon as 'loginUser' ,

hostInstace.DateModified as 'DateofCreation'from
dbo.bts_SendPort sndport inner join
dbo.bts_sendport_transport SndPorttransport
on ((sndport.nID = SndPorttransport.nSendPortID) and (SndPorttransport.nSendHandlerID is not null))
inner join
dbo.adm_SendHandler SndHandler
on SndPorttransport.nSendHandlerID = SndHandler.Id
inner join
dbo.adm_Host hostInstace
on SndHandler.HostId = hostInstace.Id