Daily Archives: January 17, 2014

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