Hello. I have a CMS with thousand of users and I am thinking in owncloud to give to each user a directory to upload files. My question here is, how can I get a report of files of all users?. Thanks in advance.
Hi cigotete,
You may need to retrieve this information from your DB and specifically from the oc_filecache
table. Note that this table also includes the different versions (if any) of the files and files in trashbin as well. So if you want to filter out this information something like this would probably help:
SELECT * FROM oc_filecache WHERE path LIKE 'files/%'
;
If you want to retrieve the files for a specific user you may need first to retrieve the storage id for this specific user from the oc_storages
table (column numeric_id
) and then expand the query above like this (where $id
comes from the oc_storages
table):
SELECT * FROM oc_filecache WHERE path LIKE 'files/%' AND storage=$id
;
Hope this helps.