select
    file_id,
    --file_guid,
    --type,
    type_desc,
    --data_space_id,
    name,
    --physical_name,
    --state,
    state_desc,
    cast(size as bigint) * 8 as size_KB
    --max_size,
    --growth,
    --is_media_read_only,
    --is_read_only,
    --is_sparse,
    --is_percent_growth,
    --is_name_reserved,
    --create_lsn,
    --drop_lsn,
    --read_only_lsn,
    --read_write_lsn,
    --differential_base_lsn,
    --differential_base_guid,
    --differential_base_time,
    --redo_start_lsn,
    --redo_start_fork_guid,
    --redo_target_lsn,
    --redo_target_fork_guid,
    --backup_lsn
from 
    sys.database_files