Delivery Logs Query Time | Community
Skip to main content
J
JohnnyBravo
Level 3
November 9, 2020
Solved

Delivery Logs Query Time

  • November 9, 2020
  • 3 replies
  • 1694 views

Hi,

 

I'm querying the delivery logs (nms:broadLogRcp:profileBroadLog) to get a certain delivery using Label of Delivery is equal to "[label name],  and Status = "Sent", and Event date "is within today". It is taking almost a half hour for this query to execute. This seems like an obscene amount of time to search. Is there a faster way to get delivery information about particular labels? What I'm trying to accomplish is to determine recipients whom have received an email, then send a follow-up email, to those whom have not updated information we are storing locally in our onsite DBs requested in the email? Is there a faster way to determine whom has received an email sent, other than querying the delivery logs (nms:broadLogRcp:profileBroadLog)?

Thank you for any help with this,

Johnny Bravo

 

Kind regards,

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bisswang

Querying the broadlog table would be the right way to go.

Half an hour indeed seems very long.

Can you maybe post a screenshot of the query you are using?

3 replies

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
November 12, 2020

Querying the broadlog table would be the right way to go.

Half an hour indeed seems very long.

Can you maybe post a screenshot of the query you are using?

    shelly-goel
    Adobe Employee
    shelly-goelAdobe Employee
    Adobe Employee
    November 22, 2020

    @johnnybravoIs this issue resolved for you now? If not, did you try count and preview within query target to see if those results are fetched instantly or not?

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      December 1, 2020

      hi @johnnybravo,

      Were you able to resolve this query with the given solution or do you need more help? Do let us know.

      Thanks!

      Sukrity Wadhwa
      J
      JohnnyBravoAuthor
      Level 3
      January 13, 2021
      Yes, I got it resolved. Thanks very much for the follow-up.
      Terms & ConditionsAccessibility statement

      Loading footer...