https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586702#M7689 <P>We have deleted 5 lack email log records from the instance. Now we need to determine if there are any orphan attachments related to those deleted email logs.</P><P>&nbsp;</P><P>Do we have any approach ?</P> Thu, 13 Aug 2026 08:47:23 GMT nagarjunadI 2026-08-13T08:47:23Z https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586702#M7689 <P>We have deleted 5 lack email log records from the instance. Now we need to determine if there are any orphan attachments related to those deleted email logs.</P><P>&nbsp;</P><P>Do we have any approach ?</P> Thu, 13 Aug 2026 08:47:23 GMT https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586702#M7689 nagarjunadI 2026-08-13T08:47:23Z https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586704#M7690 <P><FONT face="tahoma,arial,helvetica,sans-serif">ahoy&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/1168398">@nagarjunadI</a>,</FONT></P><P>&nbsp;</P><P><FONT face="tahoma,arial,helvetica,sans-serif">if it was by mistake, you can try to restore it from <STRONG>Deleted records</STRONG> module:</FONT></P><P><FONT face="tahoma,arial,helvetica,sans-serif"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="glideFather_0-1786610926743.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/526299i2F321F7D85A735E8/image-size/medium?v=v2&amp;px=400" alt="glideFather_0-1786610926743.png" title="glideFather_0-1786610926743.png" /></span></FONT></P><P>&nbsp;</P> Thu, 13 Aug 2026 08:49:01 GMT https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586704#M7690 glideFather 2026-08-13T08:49:01Z https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586708#M7691 <P>Hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/1168398">@nagarjunadI</a>&nbsp;,</P><P>&nbsp;</P><P>you can run the background script and find out&nbsp;</P><LI-CODE lang="javascript">(function() { var batchSize = 5000; // Limits processing chunk size to avoid memory overloads var totalOrphans = 0; var orphanIDs = []; var attachmentGR = new GlideRecord('sys_attachment'); attachmentGR.addQuery('table_name', 'sys_email'); attachmentGR.chooseWindow(0, batchSize); attachmentGR.query(); while (attachmentGR.next()) { var parentEmailID = attachmentGR.getValue('table_sys_id'); // Check if the parent sys_email record still exists var emailGR = new GlideRecord('sys_email'); if (!emailGR.get(parentEmailID)) { totalOrphans++; orphanIDs.push(attachmentGR.getUniqueValue()); // Optional: Print details to logs for verification gs.info("Orphan Found: Attachment ID " + attachmentGR.getUniqueValue() + " for deleted Email ID: " + parentEmailID); } } gs.info("Execution complete. Total orphaned email attachments found in this batch: " + totalOrphans); // To delete them, you can loop through orphanIDs and run attachmentGR.deleteRecord() })();</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>Regards,<BR />Chaitanya</P><P>&nbsp;</P> Thu, 13 Aug 2026 08:57:18 GMT https://www.servicenow.com/community/community-central-forum/how-to-find-orphan-records-for-the-email-logs/m-p/3586708#M7691 Chaitanya ILCR 2026-08-13T08:57:18Z