I need to find whether records of a object type have any attachment on them or not. I see that below query doesn't work.
SELECT Id, ParentId FROM Attachment WHERE ParentId like '001%' .
Is there a way to find this? It is even better if there is way to get this in report or any standard fields.