+ Start a Discussion
Rakesh Kumar 335Rakesh Kumar 335 

How to export records in a custom object with Notes and Attachments?

Is there an easy way to find out how many records in a custom object have Notes and attachments in them?
I schedule a data export report, but that did not work. I'm working with Salesforce support.
Meanwhile, want to find out if there is a way to find out how many records have attachments.
 
Best Answer chosen by Rakesh Kumar 335
Shawn Reichner 29Shawn Reichner 29
You could try to use the developer console or workbench to run a simple SOQL query to find this out. 

You could do a query like:

SELECT COUNT FROM Attachment WHERE ParentId LIKE 'xxx%'

In the xxx above in between the two ' please place in the starting three digits of your object.  Example Case is 500  You can find this information by using workbech as well by looking at the standard object attributes or more easily, go to your object and press the new button to create a new object record.  Before hitting save, look at your URL and after the salesforce.com/ you will see the three digits needed for your object. 

Hope this helps, and if so please mark as the best answer. 

Shawn