biztalk - Query to retrieve the Datetime for ALL the messages received by the given Receive Location -

purpose: query retrieve datetime messages received given receive location.

usgage: execute sql query in biztalkdtadb database. provide receivelocation name in commented place.

select        rp.nvcname    [receiveportname]      ,rl.name    [receivelocationname]         ,mf.[event/adapter] [adapter]     ,rl.inboundtransporturl    [inboundtransporturl]     ,mf.[event/timestamp]    [messagereceiveddatetime]           biztalkmgmtdb.dbo.adm_receivelocation rl join biztalkmgmtdb.dbo.bts_receiveport rp on rp.nid = rl.receiveportid join biztalkdtadb.dbo.dtav_messagefacts mf on mf.[event/port] = rp.nvcname , mf.[event/url] = rl.inboundtransporturl  --give receivelocation name  (i replace rl location name when executing query)                                               rl.name='<<receivelocation name>>' , mf.[event/direction] = 'receive' order messagereceiveddatetime desc 

when ran query using sqlmanagementstudio i'm not getting , query create table header without data though have seen biztalk admin console message arrived , process through orchestration. please check there have problem sql query ?