How to get last created record date of all custom objects having total number of records greater than 1 lakh

Question

My requirement as part of org analysis is to get list of all custom objects having more than 100000 records and created date of LAST CREATED record.

My tries are as follows:-

1. Go to Setup - Storage usage - list of all objects with record count is available here.(however it is a mix of standard and custom objects moreover there is no way to get a last created date.

2. BASED on

A. How can I know number of records of All Salesforce Object? B. Salesforce Objects & record Counts

I wrote following code(but it is giving fatal error possibly because of too many objects and 'change' condition processing time) Also without change condition it continues to give me errors:-

 for ( Schema.SObjectType o : Schema.getGlobalDescribe().values() )
 {        

    Schema.DescribeSObjectResult objResult = o.getDescribe();
    system.debug( 'Sobject API Name: ' + objResult.getName() );

    String obj = objResult.getName();
    if('EmailStatus' == obj || obj == 'Name' || obj == 'Vote' || obj == 'AggregateResult'
      || obj == 'CampaignChangeEvent' || obj == 'AccountChangeEvent' || obj == 'ContractChangeEvent'
       || obj == 'LeadChangeEvent' || obj == 'OpportunityChangeEvent' || obj == 
'OpportunityContactRoleChangeEvent' 
       ||  obj == 'Product2ChangeEvent' || obj == 'AssetChangeEvent' || obj == 'CaseChangeEvent' || 
 obj.contains('Change') )
        continue;

    String q = 'SELECT Count() FROM ' + obj;

    Integer count = Database.countQuery(q);

    System.Debug(objResult.getName() + '-->' + count);

}

Answer 1

You need count only for custom objects, so it is reasonable to add: if (!objResult.isCustom()) continue;

Overall, your code should look somehow like this:

for (Schema.SObjectType objectType : Schema.getGlobalDescribe().values()) {
    Schema.DescribeSObjectResult objectDescription = objectType.getDescribe();
    if (!objectDescription.isCustom()) continue;
    String objectName = objectDescription.getName();

    String query = 'SELECT Count() FROM ' + objectName;
    Integer count = Database.countQuery(query);

    if (count > 100000) {
        query = 'SELECT CreatedDate FROM ' + objectName + ' ORDER BY CreatedDate LIMIT 1';
        List<sObject> objects = Database.query(query);
        system.debug(objectName + '-> ' + count + ' -> ' + objects[0].get('CreatedDate'));
    }
}