Report of used quota

Therion7777 · May 21, 2019, 10:44am

Hello.

There is 3k users working with my Nextcloud instance.
Listing all users at GUI is very, very slow.

Is there any possibilty to get some kind of raport of used quota by all users?

Regards.

gas85 · May 22, 2019, 9:48am

Check this app out: https://apps.nextcloud.com/apps/user_usage_report

sudo -u www-data php occ usage-report:generate admin
"admin","2017-09-18T09:00:01+00:00",5368709120,786432000,12,1,1,2

The CSV data is the following:

User identifier
Date and time (default in ISO 8601 format, but any format can be specified)
Assigned home storage size in bytes (-3 is unlimited, -2 is unknown/not set)
Disk space consumed by home storage in bytes (-2 is unknown)
Number of files in home storage
Number of shares created
Number of files created (new files only)
Number of files read (download/view)

This script will generate report in a “cacti” format:

github.com

GAS85/nextcloud_scripts/blob/master/nextcloud-usage-report.sh

#!/bin/bash

# By Georgiy Sitnikov.
#
# This script works with https://apps.nextcloud.com/apps/user_usage_report
#
# Will generate report and output it in cacti format
# Supports Argument as "user" if you need to check statistic for one user only
# run ./nextcloud-usage_report.sh user to get specific user information
# AS-IS without any warranty
#
# output felds are: storage_all, storage_used, shares_new, files_all, files_new, files_read

COMMAND=/var/www/nextcloud/occ
OPTIONS="usage-report:generate"
LOCKFILE=/tmp/nextcloud_usagereport
TMPFILE=/tmp/nextcloud_usagereport_tmp
PHP=/usr/bin/php

. nextcloud-scripts-config.conf

This file has been truncated. show original