Borrowed from here and tweaked slightly:

DECLARE @trace_id INT = 1,

@path NVARCHAR(260);

SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'

FROM sys.traces

-- set this id each time up above or come up with another identifier you can count on to get a specific trace id from sys.traces, e.g. path like '%something%'

WHERE id = @trace_id;

SELECT DatabaseName,

[FileName],

SPID,

Duration,

StartTime,

EndTime,

FileType = CASE EventClass

WHEN 92 THEN 'Data'

WHEN 93 THEN 'Log'

END

FROM sys.fn_trace_gettable(@path, DEFAULT)

WHERE EventClass IN ( 92, 93 )

ORDER BY StartTime DESC;