List deletions of the last 24 hours:
mysql -u oc_admin -p -D nextcloud -e "select from_unixtime(timestamp), type, user, SUBSTR(SUBSTRING_INDEX(oc_ldap_user_mapping.ldap_dn,',',1),4), app, file, object_type from oc_activity LEFT join oc_ldap_user_mapping ON (oc_activity.user=oc_ldap_user_mapping.owncloud_name) WHERE type = 'file_deleted' AND timestamp > UNIX_TIMESTAMP() - 86400"
Verwandte Artikel