The undocumented function to read the log is fn_dblog. It's a table-valued function (hence used in a select statement), takes two parameters, start LSN and end LSN, both can be null.

It's completely undocumented, so good luck interpreting it.

You won't find host names in there, it's a transaction log, not an audit log