Group by - massive number of CIs records

kris29
Tera Contributor

‎06-14-2022 12:30 AM

HI community,

How can I use Group by option for the Created by column in cmdb_ci. CMDB has about 4000000 records.

I get the error message "Your transaction has been canceled. Reason: maximum execution time exceeded"

 

Labels:
0 Helpfuls
  • 549 Views
2 REPLIES 2

Akash4
Kilo Sage
Kilo Sage

‎06-14-2022 12:47 AM

Hello Kris, I suggest using the Reports Application for GroupBy option with extensive records.

Looks something like this (works for large records) - Reports > Create New > As you proceed further you would see Configure tab containing Group by option as follows:

find_real_file.png

Regards, Akash

Regards, Akash
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.
Preview file
104 KB
0 Helpfuls

Maik Skoddow
Tera Patron
Tera Patron

‎06-14-2022 07:02 AM

Hi kris

4 million records is not that much. I have grouped tables with more records. But you have to make sure that the field you want to group has an index. I just checked the cmdb table (base table for all CMDB tables) and the column "created_by" has no index. Just create one for that column at table cmdb (really use that table and none else!!!!) and you should see the performance increase.

For more information: https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/table-admi...

Kind regards
Maik

0 Helpfuls