Q:

How to tell the object type of an Attachment

I need to export all of the attachments of an org. I would like to break them down to be in a folder based upon the object type of their parent. In other words, I want all attachments which are in an Account to be in one single folder, and all of the ones in an Opportunity to be in another folder. 
I've been trying to determine how the Attachments are arranged by running queries on the Attachment object in Workbench. But I believe the closest I can come to determining this information is the Attachment object's ParentID field. But that's just the ID of the individual record, not the object type of the Parent. Is there any way to determine the object type of the Parent of the Attachment ? 

A:

In a query, you can pull Parent.Type in your SELECT clause, or even filter on it in your WHERE clause.
SELECT Body, Parent.Type FROM Attachment

