list all host names

[Mogamboo_Khush_Hua]

select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses Above query lists all hosts currently logged in using which login name. But i want which hostname have logged in past using which login name . where do i found this information ? Is there any log is maintained for that.

[Lost User]

Member 6392036 wrote:

i want which hostname have logged in past

AFAIK, the information isn't stored historically. If you want to know who was online when, then you'll need to add some kind of logging.

I are Troll :suss: