function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NM AdminNM Admin 

Can we get a report/excel/csv of all objects with count of the object and most recent created date?

Hello,

One quick question
Can we get a report of all objects with count of the object and most recent created date?

Share you suggestions, if any.


Thanks!
Neha AggrawalNeha Aggrawal
Hi,

You can check the storage Usage, by searching for 'Storage' in setup. It will give you a count of the records in each object and the space they are using. For the most recent created date, you will have to use reports. I don't have any other method in my knowledge.
Let me know if this helps.
Thanks.
Name ChangedName Changed
Hey,

There is no direct way to achieve this request

This might help

1. Through workbench you can get all the list of Objects
     Path - Info -> Metadata Types & Components --> CustomObject
    
2. You have to go to Setup -> Build -> Create - > Objects -> Manually copy all the objects and paste it in your excel

3. It might be worth installing the AppExchange app created by Salesforce Labs called the Object Metadata Snapshot Tool that lets you report on Objects and Field metadata.
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003Ih3aEAC


Thanks,
Jagan
NM AdminNM Admin
@Neha,

Thanks for quick reply for the mentioned use case. but I am not able to see all the objects in the Storage Usage.

I am trying with the below code to get how many objects are there in the system. I am modifying this code to get record count of it. 
Map<String, Schema.SObjectType> GlobalDescribe = Schema.getGlobalDescribe();
  system.debug('----------------No Of Objects-----'+GlobalDescribe.size() );

  for(Schema.SObjectType objTyp : GlobalDescribe .Values()){
      Schema.DescribeSObjectResult ObjDesc = objTyp.getDescribe();
      if(ObjDesc.isCustom())
         system.debug('--Custom Object or Custom setting---');
      else
         system.debug('--Standard Object---');

  }

Please share your suggestions regarding this well.

@Jagannatha Reddy 16
I am looking into this if helps would be great.
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003Ih3aEAC

Do we have any other way to achieve this.

Thanks
eminem cafeeminem cafe
I have read your excellent post. This is a great job. I have enjoyed reading your post first time.
https://surveyexpert.info/
Johny SinsJohny Sins
Hello, I am Johny Sins from Plumbers In Washington (https://en.gravatar.com/johnysins131) services, I read this and want to say that very helpful.