Thank you guys for all valuable feedback :-)...

following Query from Mansfield working gr8 in my scenario!!

SELECTec.session_id,

connect_time,

s2.[text] as Last_Executed_SQL,

auth_scheme as Auth_Type,

client_net_address,

client_tcp_port,

es.host_name,

es.program_name,

es.login_time,

es.login_name,

ob.name as Stored_Procedure_Name

FROM sys.dm_exec_connections ec

OUTER APPLY sys.dm_exec_sql_text (ec.most_recent_sql_handle) as s2

LEFT JOIN sys.dm_exec_sessions es on (ec.session_id = es.session_id)

JOIN sys.sql_modules sm on sm.definition = s2.text

JOIN sys.objects ob on ob.object_id = sm.object_id

ORDER BY connect_time desc