As admin, how to list all directory shared by users?

Is there a way for the ownCloud (9.1.5) admin to see (with occ CLI or in admin web pages or with SQL in database) the list of all directory shared by all users ?
With occ ldap:show-remnants i can see deleted users that have shared files/folders but is there a way to see this (with more details like name of shared folders) for active users ?


Have you tried:

  • login to mysql

use owncloud;

select * from oc_share;

This command shows me the user and the filename that is shared.

Perfect, thanks voroyam !