<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Sending logs extraction in Adobe Campaign Standard Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/442783#M14706</link>
    <description>&lt;P&gt;If I see the sql query code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;INSERT INTO wkf113649313_88_1 (biCusClientCode,biId)&lt;BR /&gt;SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; N1.biCusClientCode,&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; N0.biBroadLogId&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FROM NmsBroadLogRcp N0&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;JOIN NmsRecipient N1&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ON (N1.iRecipientId = N0.iProfileId)&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;JOIN NmsDelivery N2&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ON (N2.iDeliveryId = N0.iDeliveryId)&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE&amp;nbsp; (((N0.biBroadLogId &amp;gt; 0 OR N0.biBroadLogId &amp;lt; 0) AND (IsBitSet(N0.iFlags , 4) &amp;lt;&amp;gt; 4)))&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It seems that it is in the following step where the records are lost, but If that the case, I can't undestand the reason&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;JOIN NmsRecipient N1&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ON (N1.iRecipientId = N0.iProfileId)&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 02 Mar 2022 18:04:40 GMT</pubDate>
    <dc:creator>LAR1985</dc:creator>
    <dc:date>2022-03-02T18:04:40Z</dc:date>
    <item>
      <title>Sending logs extraction</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/442746#M14705</link>
      <description>&lt;P&gt;Hello all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We are trying to do a extraction of the sending logs to create a file to send to another application. We have used a query node and choose as resource "Delivery logs" and selected the fields that we need. We execute and we get the number of records expected. The problem is when we add in "Additional data" fields which are from "Profile" resource. When we do that, the number of records fall. Can someone help me?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;</description>
      <pubDate>Wed, 02 Mar 2022 14:14:42 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/442746#M14705</guid>
      <dc:creator>LAR1985</dc:creator>
      <dc:date>2022-03-02T14:14:42Z</dc:date>
    </item>
    <item>
      <title>Re: Sending logs extraction</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/442783#M14706</link>
      <description>&lt;P&gt;If I see the sql query code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;INSERT INTO wkf113649313_88_1 (biCusClientCode,biId)&lt;BR /&gt;SELECT&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; N1.biCusClientCode,&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; N0.biBroadLogId&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;FROM NmsBroadLogRcp N0&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;JOIN NmsRecipient N1&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ON (N1.iRecipientId = N0.iProfileId)&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;JOIN NmsDelivery N2&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ON (N2.iDeliveryId = N0.iDeliveryId)&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; WHERE&amp;nbsp; (((N0.biBroadLogId &amp;gt; 0 OR N0.biBroadLogId &amp;lt; 0) AND (IsBitSet(N0.iFlags , 4) &amp;lt;&amp;gt; 4)))&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It seems that it is in the following step where the records are lost, but If that the case, I can't undestand the reason&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;JOIN NmsRecipient N1&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ON (N1.iRecipientId = N0.iProfileId)&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 02 Mar 2022 18:04:40 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/442783#M14706</guid>
      <dc:creator>LAR1985</dc:creator>
      <dc:date>2022-03-02T18:04:40Z</dc:date>
    </item>
    <item>
      <title>Re: Sending logs extraction</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/444877#M14754</link>
      <description>&lt;P&gt;Hello,&lt;BR /&gt;You might try to create a link with the "reconciliation box" (the one with a little key displayed)&lt;BR /&gt;It will create a left join instead of a join&amp;nbsp;&lt;BR /&gt;it might help you to retrieve all you records, without removing records from delivery logs if the recipient does not exist any more&lt;/P&gt;</description>
      <pubDate>Thu, 17 Mar 2022 14:49:30 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/sending-logs-extraction/m-p/444877#M14754</guid>
      <dc:creator>HugoThomas</dc:creator>
      <dc:date>2022-03-17T14:49:30Z</dc:date>
    </item>
  </channel>
</rss>

