I would query master.dbo.sysprocesses(nolock) get a count of all (sp_id) processes runing per DB, pass @spid parameter to dbcc inputbuffer(@spid), and built a report with per DB, processes running, login...