How to extract filename/date upload/user

[m2m]

version: 21.0.9
PHP: Version: 7.4.19
database: mysql 10.3.28

hi,
maybe you can help with advice.
How to export from DB information about uploaded/stored files with upload date and uploading user.
Basically I need to see what file were available in which day.
Is there also information related to deleted files - e.g. file name/date deleted/user deleting

Is that accessible only by SQL queries (what table?) or there is an application I could use?

[m2m]

there is an app “activity” which shows most information needed, but instead of exact date it shows e.g “6 months ago”.
After hovering mouse on “6 months ago” it displays exact date. Unfortunately - the only option is to print to PDF with what is seen on the screen - this “6 months ago”…
Any ideas?

But still - this app is not comfortable to use, requres scrolling to force to show additional data.

[wwe]

take a look at this SQL queries:

Desktop client 3.4.0 destroys local time stamp and keeps uploading data to server

I tryed hard to find a universal solution to link the file damaged by the sync with valid versions and allow subsequent recovery… at the moment my sql skills only allow this summary of intermediate steps which hopefully helps others. for some really strange reason there is no clear relation (in terms of unique ID) between the files and their versions… both are listed in the oc_filecache table… the only difference is real files have prefix files/ while versions have files_versions/ prefix and …

Desktop client 3.4.0 destroys local time stamp and keeps uploading data to server

I spend more time on this and created a SQL query collecting all files with invalid (1970-01-01) file mtime from the DB and checking for files_versions of this files in the DB with their change time and original mtime. one can use the output to correct the mtime easily (if your DB still has file versions entries). Warning: At the moment I don’t know if it work when multiple versions of the damaged file exist (don’t have in my playground), simple sort/limit should choose good version but need…

it gives you good idea about the DB structure and how files and their previous version belong together. Should be not hard to adopt for deleted files…

[devnull]

@m2m

Basically I need to see what file were available in which day.
Is there also information related to deleted files - e.g. file name/date deleted/user deleting

I do not know the beginning of your analysis. But any of your users could have intentionally or unintentionally shared the data through other means.