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]

owncloud/core#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: owncloud/core#26829 (comment)
owncloud/core#1344

And a better screenshot:

Also a SQL query to get the used space for all users:
owncloud/core#1344 (comment) & owncloud/core#1344 (comment)

[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: #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.