Description
Steps to Reproduce
-
Log in to the instance.
-
Enable Debug SQL (detailed).
-
Type cmdb_ci.list in the search box.
-
Group the list retrieved on Manufacturer.
-
Make a note of the number of items.
-
Search for "Group By" in the logs and locate the following statement:
SELECT ... FROM (cmdb_ci cmdb_ci0 LEFT JOIN core_company core_company1 ON cmdb_ci0.`manufacturer` = core_company1.`sys_id` ) GROUP BY cmdb_ci0.`manufacturer`,core_company1.`name` ORDER BY core_company1.`name` 7)
-
Execute the following statement in Scripts-Background (note the change in number at the end):
SELECT count(*) FROM (cmdb_ci cmdb_ci0 LEFT JOIN core_company core_company1 ON cmdb_ci0.`manufacturer` = core_company1.`sys_id` ) GROUP BY cmdb_ci0.`manufacturer`,core_company1.`name` ORDER BY core_company1.`name` 8).
-
Paste the result retrieved into an Excel spreadsheet.
Observe the number of records in the spreadsheet.
Workaround
No workaround is available at this time.
Related Problem: PRB623525