This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a way to search all custom record types to see how many there are?  It would be the equivalent of going to each record and pressing LIST at the top to get a count but that is very time-consuming when there are hundreds of custom records.  I was thinking about using SuiteQL from Tim Dietrich but that is a bit over my head.

<@UJ0137EMV> Yeah, I think the only solutions are going to be a backend-type things, like SuiteQL or ODBC connector. What's the use case for this?

<@UAC8528QK> Thanks!  We acquired a company that runs Netsuite with many customizations and some of the records exceed 1.5million.  So we're trying to scope all the different records, record types and how many are in each.  Since we are already have Netsuite, we need to migrate this data to our current Netsuite instance.  Paying for 2 netsuite instances is really expensive and I haven't seen the buy one get one free deal yet.

I'd be tempted to see if you can get a short term StrongPoint license for that purpose

<https://www.strongpoint.io/netsuite-configuration-management>

```Understanding how your account is configured is one of the main challenges NetSuite admins face when they're working in a heavily customized instance, starting in a new role or taking over from a team of consultants.

Strongpoint starts by scanning your account and documenting all custom fields, records, account settings and more, so you can instantly see how you're set up and how things are connected. Best of all, this record is constantly updated, so it's always accurate. ```

Should note - you might not start the "spidering" process in the middle of the work day if you have time sensitive scheduled scripts that run.

<@UER9Q3SGM> We actually own Strongpoint for both of the instances...I can reach out to their support to see if getting a count of rows per record type is possible.  We've been running it for a year, but I don't think that is part of the metadata.

Ah. Didn't realize you meant the actual record count and not data about the records

I spent a minute trying to figure out "how" to ask the question. I guess i should have asked how many rows are in each record type...but I'm not that smart to figure it out until after the fact.