Migration day wise SELECT date(ae.createDate) as date, count(*) as files, substring(dlfe.externalReferenceCode, 1, 4) as source FROM AssetEntry ae INNER JOIN DLFileEntry dlfe ON ae.classPK = dlfe.fileEntryId where dlfe.externalReferenceCode like "HHSA%" OR dlfe.externalReferenceCode like "PASS%" group by date, source order by date desc limit 100; Total: SELECT count(*) as Total FROM AssetEntry ae INNER JOIN DLFileEntry dlfe ON ae.classPK = dlfe.fileEntryId where dlfe.externalReferenceCode like "HHSA%" OR dlfe.externalReferenceCode like "PASS%" limit 100; All details of file entry: SELECT ORG.externalReferenceCode as orgaCode, ORG.name, ORG.type_, DLFE.fileEntryId, DLFE.externalReferenceCode, DLFE.userName, DLFE.createDate, DLFE.modifiedDate, DLFE.folderId, DLFE.treePath, DLFE.fileName, DLFE.title, DLFE.mimeType, DLFE.size_, DLFE.fileEntryTypeId, DLFEAF.childId, DLFEAF.isSealedDocumentOpen, DLFEAF.isSigned, DLFEAF.parentId, DLFEAF.statusCode, DLFEAF.parentId, LNK.* FROM DLFileEntry DLFE LEFT JOIN DLFileEntryAdditionalFields DLFEAF ON DLFE.fileEntryId = DLFEAF.fileEntryId LEFT JOIN Linkage LNK ON DLFE.fileEntryId = LNK.documentId JOIN Group_ GRP ON DLFE.groupId = GRP.groupId JOIN Organization_ ORG ON GRP.classPk = ORG.organizationId LIMIT 100;