CSV export from “Assets → Global” truncated to ~300 rows while “Computers” export returns full 18,000 rows

[elidjah]

Code of Conduct

• I agree to follow this project's Code of Conduct

Disable plugins

• I reproduce the issue with all plugins disabled

Is there an existing issue for this?

• I have searched the existing issues

Version

11.0.4

Bug description

Hello,

On GLPI 11.0.4, the CSV export from the Assets → Global view does not contain all items.
With the same instance and PHP configuration, the Computers view exports the full dataset correctly, so this seems to be a bug specific to the “Global” view export.

Relevant log output

Environment

GLPI version: 11.0.4

OS: Rocky Linux (x86_64)

Web server: (Apache 2.4)

PHP SAPI: PHP-FPM

PHP version: 8.2.30

Database: MariaDB

Browser(s) tested: Chrome / Edge / Firefox

Reverse proxy: no

PHP configuration (as seen in phpinfo() on the GLPI vhost):

memory_limit: 512M

max_execution_time: 300

max_input_time: 60

post_max_size: 8M

upload_max_filesize: 2M

All services (PHP-FPM and web server) have been restarted after changing the configuration.

Page URL

http://x.x.x.x/front/allassets.php

Steps To reproduce

1. Have an instance with about 18,000 computers in the inventory.

2. Go to Assets → Computers.

3. Set the list to show all items (then use Export → CSV → All pages).

4. Observe that the resulting CSV contains ~18,000 rows (all expected items).

5. Now go to Assets → Global.

6. Use Export → CSV → All pages.

7. Open the downloaded CSV and count the lines (or use wc -l on the server).

Your GLPI setup information

GLPI information

GLPI: 11.0.4 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language: fr_FR
Source Integrity: 2 files changed
  A: front/phpinfo.php
  A: public/phpinfo.php

Server

Operating system: Linux SRV-GLPI11 5.14.0-611.30.1.el9_7.x86_64 #​1 SMP PREEMPT_DYNAMIC Fri Feb 13 17:04:55 UTC 2026 x86_64
PHP: 8.2.30 fpm-fcgi
PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard,

cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, intl, ldap, exif, mysqlnd, PDO,

Phar, posix, shmop, SimpleXML, sockets, sodium, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlwriter, xsl, mysqli,

pdo_mysql, pdo_sqlite, xmlreader, zip, apcu, igbinary, msgpack, redis, Zend OPcache
Setup: disable_functions="" max_execution_time="300" max_input_vars="10000" memory_limit="512M" post_max_size="8M"

session.cookie_secure="0" session.cookie_httponly="1" session.cookie_samesite="" session.save_handler="files"

upload_max_filesize="2M"
Web server: Apache/2.4.62 (Rocky Linux) ()
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36
Database:
Server Software: MariaDB Server
Server Version: 10.11.15-MariaDB
Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: glpi_user@localhost/glpi_new
Host info: Localhost via UNIX socket
Requirements:

PHP version (8.2.30) is supported.

OS and PHP are relying on 64 bits integers.

Sessions configuration is OK.

Allocated memory is sufficient.

Following extensions are installed: dom, fileinfo, filter, libxml, simplexml, tokenizer, xmlreader,

xmlwriter.

mysqli extension is installed

curl extension is installed

gd extension is installed

intl extension is installed

mbstring extension is installed

zlib extension is installed

bcmath extension is installed

The constant

SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.

openssl extension is installed

Database engine version (10.11.15) is

supported.

The log file has been created successfully.

Write access to /var/www/html/glpi/files/_cache has been validated.

Write access to /var/www/html/glpi/files/_cron has been validated.

Write access to /var/www/html/glpi/files has been validated.

Write access to /var/www/html/glpi/files/_graphs has been validated.

Write access to /var/www/html/glpi/files/_lock has been validated.

Write access to /var/www/html/glpi/files/_pictures has been validated.

Write access to /var/www/html/glpi/files/_plugins has been validated.

Write access to /var/www/html/glpi/files/_rss has been validated.

Write access to /var/www/html/glpi/files/_sessions has been validated.

Write access to /var/www/html/glpi/files/_tmp has been validated.

Write access to /var/www/html/glpi/files/_uploads has been validated.

For security reasons, SELinux

mode should be Enforcing.
Sessions configuration is secured.

exif extension is installed

ldap extension is installed

Following extensions are installed: bz2,

Phar, zip.

Zend OPcache extension is installed

Following extensions are installed:

ctype, iconv, sodium.

Write access to

/var/www/html/glpi/marketplace has been validated.

Timezones seems loaded in database.

GLPI constants

GLPI_ROOT: "/var/www/html/glpi"

GLPI_VERSION: "11.0.4"

GLPI_SCHEMA_VERSION: "11.0.4@9065df1ff6b8ff1d77b519d1c4856507d18258b0"

GLPI_FILES_VERSION: "11.0.4-1d4fbe9a"

GLPI_MIN_PHP: "8.2"

GLPI_MAX_PHP: "8.5"

GLPI_YEAR: "2025"

GLPI_I18N_DIR: "/var/www/html/glpi/locales"

GLPI_ENVIRONMENT_TYPE: "production"

GLPI_CONFIG_DIR: "/var/www/html/glpi/config"

GLPI_VAR_DIR: "/var/www/html/glpi/files"

GLPI_MARKETPLACE_DIR: "/var/www/html/glpi/marketplace"

GLPI_ALLOW_IFRAME_IN_RICH_TEXT: false

GLPI_SERVERSIDE_URL_ALLOWLIST: ["^\n                        (http|https|feed)://

# protocol\n                        (\n                            (?:\n

(?:xn--[a-z0-9-]++\.)*+xn--[a-z0-9-]++                      # a domain name using punycode\n

|\n                                (?:[\pL\pN\pS\pM\-\]++\.)+[\pL\pN\pM]++                    # a multi-level domain

name\n                                    |\n                                [a-z0-9\-\]++

# a single-level domain name\n                            )\.?\n                                |

# or\n                            \d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}

# an IP address\n                                |                                                           #

or\n                            \[\n

(?:(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){6})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:::(?:(?:(?:[0-9a-f]{1,4})):){5})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){4})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,1}(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){3})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,2}(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){2})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,3}(?:(?:[0-9a-f]{1,4})))?::(?:(?:[0-9a-f]{1,4})):)(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,4}(?:(?:[0-9a-f]{1,4})))?::)(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,5}(?:(?:[0-9a-f]{1,4})))?::)(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,6}(?:(?:[0-9a-f]{1,4})))?::))))\n

\]                                                              # an IPv6 address\n

)\n                        (?:/ (?:[\pL\pN\pS\pM\-._\!$&'()+,;=:@]|%[0-9A-Fa-f]{2}) )*     # a path\n

(?:\? (?:[\pL\pN\-._\~!$&'\\+,;=:@/?]|%[0-9A-Fa-f]{2}) )?    # a query (optional)\n

$~ixuD"]

GLPI_DISALLOWED_UPLOADS_PATTERN: "/\.(php\d*|phar)$/i"

GLPI_TELEMETRY_URI: "https://telemetry.glpi-project.org"

GLPI_INSTALL_MODE: "TARBALL"

GLPI_NETWORK_MAIL: "glpi@teclib.com"

GLPI_NETWORK_SERVICES: "https://services.glpi-network.com"

GLPI_MARKETPLACE_ENABLE: 3

GLPI_MARKETPLACE_PRERELEASES: false

GLPI_MARKETPLACE_ALLOW_OVERRIDE: true

GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true

GLPI_USER_AGENT_EXTRA_COMMENTS: ""

GLPI_DOCUMENTATION_ROOT_URL: "https://links.glpi-project.org"

GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: "1"

GLPI_LOG_LVL: "warning"

GLPI_SKIP_UPDATES: false

GLPI_STRICT_ENV: false

GLPI_AJAX_DASHBOARD: "1"

GLPI_CALDAV_IMPORT_STATE: 0

GLPI_CENTRAL_WARNINGS: "1"

GLPI_SYSTEM_CRON: false

GLPI_TEXT_MAXSIZE: "4000"

GLPI_WEBHOOK_ALLOW_RESPONSE_SAVING: "0"

GLPI_WEBHOOK_CRA_MANDATORY: false

GLPI_ALTCHA_MODE: "interactive"

GLPI_ALTCHA_MAX_NUMBER: 50000

GLPI_ALTCHA_EXPIRATION_INTERVAL: "PT20M"

GLPI_DOC_DIR: "/var/www/html/glpi/files"

GLPI_CACHE_DIR: "/var/www/html/glpi/files/_cache"

GLPI_CRON_DIR: "/var/www/html/glpi/files/_cron"

GLPI_GRAPH_DIR: "/var/www/html/glpi/files/_graphs"

GLPI_LOCAL_I18N_DIR: "/var/www/html/glpi/files/_locales"

GLPI_LOCK_DIR: "/var/www/html/glpi/files/_lock"

GLPI_LOG_DIR: "/var/www/html/glpi/files/_log"

GLPI_PICTURE_DIR: "/var/www/html/glpi/files/_pictures"

GLPI_PLUGIN_DOC_DIR: "/var/www/html/glpi/files/_plugins"

GLPI_RSS_DIR: "/var/www/html/glpi/files/_rss"

GLPI_SESSION_DIR: "/var/www/html/glpi/files/_sessions"

GLPI_TMP_DIR: "/var/www/html/glpi/files/_tmp"

GLPI_UPLOAD_DIR: "/var/www/html/glpi/files/_uploads"

GLPI_INVENTORY_DIR: "/var/www/html/glpi/files/_inventories"

GLPI_THEMES_DIR: "/var/www/html/glpi/files/_themes"

GLPI_PLUGINS_DIRECTORIES: ["/var/www/html/glpi/marketplace","/var/www/html/glpi/plugins"]

GLPI_NETWORK_API_URL: "https://services.glpi-network.com/api"

GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"

GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"

Annuaires LDAP

Server: 'srv-adds01.gueudet.fr',

Port: '389',

BaseDN: 'DC=GUEUDET,DC=FR',

Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',

RootDN: 'CN=glpi-ad,CN=Users,DC=GUEUDET,DC=FR',

Use TLS: none

Réplicats SQL

Not active

Notifications

Way of sending emails: PHP

Name: 'Gmail Support'

Active: Yes

Server: '{imap.gmail.com:993/imap/ssl}INBOX'

Login: 'glpi.testgl@gmail.com'

Password: Yes

Plugins list

glpiinventory        Name: GLPI Inventory                 Version: 1.6.7      State: Activé

Install Method: Marketplace

datainjection        Name: Injection de fichiers          Version: 2.15.3     State: Non installé

Install Method: Marketplace

pdf                  Name: PDF                            Version: 4.1.2      State: Non installé

Install Method: Marketplace

reports              Name: reports                        Version: 2.0.2      State: Non installé

Install Method: Marketplace

Anything else?

Thanks in advance for your help, and tell me if you need more debug info or a test query to run on the database.

[trasher]

Please try with a up to date GLPI version - or a nightly build, and also without any plugin.

[cconard96]

I confirm. The all pages exports for Global Assets are limited to N items per type where N is the results per page limit.
The LIMIT is removed for the union request, but for the individual queries it is forced to the page limit. Apparently this was for performance reasons, but maybe it should be bypassed for export_all cases.

This issue should affect any union searches.

glpi/src/Glpi/Search/Provider/SQLProvider.php

Lines 4727 to 4739 in 8ba8d08

	// Performance optimization: limit each subqueries returned rows to the max number of items we need
	// to display.
	// This help a lot on MariaDB as it seems less smart than MySQL when dealing with these kind of
	// UNION requests
	// This can however only by done on the first page of a result set as it would break pagination on
	// other pages.
	// Sorted request also can't benefit from this optimization
	if (
	empty($ORDER) // No sort clause is defined
	&& $data['search']['start'] == 0 // First page of results
	) {
	$tmpquery .= " LIMIT " . (int) $data['search']['list_limit'];
	}