This will give you the log and data file paths

:

select * from (select filename, (case status & 0x40 when 0x40 then 'log only' else 'data only' end) as usage from...