Server: Show color bar in quota column of % used space

[gusta70]

in settings/users new feature:
show color bar of % user used space of quota
http://i.imgur.com/ayvNt6L.png

[MariusBluem]

https://github.com/owncloud/core/issues/12602

cc @MorrisJobke @LukasReschke

[MorrisJobke]

The problem here was that it wasn't easy to fetch all the quota without mounting all the home directories of each user. I think we have done a lot there. Maybe worth to look into this again.

[Spacefish]

Maybe it´s possible to compute the Quota of each user in a background cronjob? Just add a "last_quota_calc" column to the users table. If last_quota_calc < last_action in activity, the quota is recalculated.

[MorrisJobke]

@icewind1991 Is it nowadays easier to get the quota?

[johanehnberg]

For those looking for a way to at least detect when someone hits their limit, here is a one-liner that you can put in cron.daily or similar:

grep InsufficientStorage nextcloud.log | grep `date '+%Y-%m-%d' -d yesterday` | jq -r .time,.user | paste - - | uniq

It checks for any user who maxed out during the previous day. It requires jq to be installed beyond what is usually included in distros.

[johanehnberg]

The color bar could have two levels: one for active storage (equivalent of du -sh username/files) and another for total storage which includes versions, trashbin and any other app that makes use of remaining quota (somewhat similar to du -sh username).

[enoch85]

It's possible at least in ownCloud to get user quota via an API call: https://github.com/owncloud/core/issues/26829#issuecomment-268304473
https://github.com/owncloud/core/issues/1344

And a better screenshot:

Also a SQL query to get the used space for all users:
https://github.com/owncloud/core/issues/1344#issuecomment-245526902 & https://github.com/owncloud/core/issues/1344#issuecomment-280664886

[soamz]

is it implemented yet ?

How do we see users usage ?

[MorrisJobke]

is it implemented yet ?

As this ticket is still open: no.

How do we see users usage ?

Currently not possible.

[icewind1991]

PR is here: https://github.com/nextcloud/server/pull/5342

[linucksrox]

Thanks @icewind1991! This is totally awesome, and I really like how you can hover to get a more accurate idea of the used space. One small thing I noticed is that the last login column starts to overlap at about 1390px width or less in Chrome, but I bet some CSS magic could fix that.