How much space are my Attachments using, part deux
In the first article we discussed using SQL to determine the size of the Attachments in the database. My friend Aron Fischman shared with me similar queries using FetchXml: <!–Email Attachment File Size Analysis–> <fetch distinct=’false’ mapping=’logical’ aggregate=’true’> <entity name=’activitymimeattachment’> <attribute name=’activitymimeattachmentid’ alias=’EmailAttachmentCount’ aggregate=’count’/> <attribute name=’filesize’ alias=’FileSizeSum’ aggregate=’sum’/> <attribute name=’filesize’ alias=’FileSizeAvg’ aggregate=’avg’/> <attribute name=’filesize’ […]
Continue reading