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;