Core: Users disk usage

[hoerup]

When viewing the user list (settings/users.php) it would be nice to see each users current disk consumption / usage preferably both as a MB/GB number and as a percentage of quota (if set)

[kiranos]

I'd like this feature implemented, from a company standpoint looking at employees it would be nice to know.

[marlboromoo]

Agree @kiranos !

[nickvergessen]

Should be fixed with #7151 (duplicating)

[jospoortvliet]

I don't think this ever made it in, it isn't in 8.2 at least... Am I wrong @blizzz ?

[madmas]

@jospoortvliet I see it the same way, but it's also not checked in the checklist section "Additional Features" in #7151 (which has not been updated for a while now)

[blizzz]

No, it's not in and there are no plans to get it into 9.0 either.

[jospoortvliet]

Ok so this should be kept open, unless we never want to do it and wouldn't accept patches (but I assume that that isn't the case and anybody can send a patch which takes care of this if they want).

[ghost]

What about https://apps.owncloud.com/content/show.php/Storage+Usage+%2B+Activity+Charts?content=166746 for now?

[PVince81]

Removing junior job tag, this is tricky and I remember @icewind1991 saying that the APIs aren't quite ready to make this work efficiently.

[PVince81]

This slightly twisted Mysql query can return the used space for all users:

MariaDB [owncloud]> select m.user_id, fc.size from oc_mounts m, oc_filecache fc, oc_storages s where m.mount_point=concat('/', m.user_id, '/') and s.numeric_id=m.storage_id and fc.storage=m.storage_id and fc.name='files';
+---------+---------+
| user_id | size    |
+---------+---------+
| admin   |     163 |
| user1   | 4774179 |
| user2   | 1571107 |
+---------+---------+
3 rows in set (0.00 sec)

I still wish there was a way to directly retrieve home storages and user ids from oc_storages...

[PVince81]

(which obviously wouldn't work for custom storage/cache implementations if someone decided to not use oc_filecache)

[lustyffh]

are there any plans to include this functionality in the upcoming versions?

[PVince81]

Not for 9.2.

But if anyone volunteers to work on it and submit a PR, we can include it.
The way I see it, the minimum required work is as follows:

• add an optional field in the users page to display the disk usage
• the field must be disable-able using the settings on the bottom left
• if the setting is disabled, the SQL query must not run as it can be expensive
• if the setting is enabled, querying the user list would run the query from https://github.com/owncloud/core/issues/1344#issuecomment-245526902 and include its result for each returned user

[PVince81]

• [ ] requires API: https://github.com/owncloud/core/issues/26829

[PVince81]

Looks like the provisioning API already returns the usage quota.
However the web UI uses a different API. It should be possible to reuse whatever the provisioning API is using to get the usage and display it in the users page.

[PVince81]

Acceptance criteria from the closed duplicate ticket:

As an admin, I want to be able to easily and quickly see the current quota usage of all of the users on the system.

Acceptance Criteria:
This should be integrated in the user management panel. This displays the % of used quota next to the quota drop down for each user in the table. The option is set in the settings panel on the bottom left (the gear). When the option is selected, a new column appears with this info displayed

[PVince81]

The query has a small mistake. It must be "fc.path", not "fc.name".

Here:

select m.user_id, fc.size from oc_mounts m, oc_filecache fc, oc_storages s where m.mount_point=concat('/', m.user_id, '/') and s.numeric_id=m.storage_id and fc.storage=m.storage_id and fc.path='files';

[JackSlateur]

And with sorted human-size:

select m.user_id, concat(convert(fc.size / 1024 / 1024, integer), 'MB') as size from oc_mounts m, oc_filecache fc, oc_storages s where m.mount_point=concat('/', m.user_id, '/') and s.numeric_id=m.storage_id and fc.storage=m.storage_id and fc.path='files' order by fc.size desc;

[geekonthepc]

Hi, is there any chance of this being followed up as it would be very useful to be able to see user quota usage?

[PVince81]

@pmaier1

[matfiz]

@ownclouders if community proposes PR with this, would it be accepted, or there is some (personal info?) reason why it should not be added?

[pmaier1]

if community proposes PR with this, would it be accepted, or there is some (personal info?) reason why it should not be added?

Yes, you're more than welcome to go for a PR, absolutely. The solution needs to work performant in installations with several thousands of users. That's the main pain point, I guess.
If you want to contribute, you're welcome join our public chat on talk.owncloud.com to get in touch.