EPDM Report all files

Hi,

I would like to write a report file (.crp) what can list all of the file in the vault, but I stucked with path and users.

This simple report runs fine, but I can not figure out how can I add the folder name and the User name user who was checked in (or added to vault).

I tried to find information (google, Report Examples 1.crp) but I'm beginner in SQL.

@[ListAllDoc]
§Name [List all documents]
§Company [Econ]
§Description [This query lists all documents]
§Version [1.0]
§Arguments [ ]
§Sql
[
SELECT D.Filename as 'File Name'
FROM Documents D
WHERE D.Filename LIKE '%'
]

Thank you

SolidworksSolidworks Pdm/enterprise Pdm