Skip to main content
Level 3
Nov 9, 2020 8:59 PM UTC
Solved

Delivery Logs Query Time

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.
bisswangAccepted solution
Adobe Employee
Nov 12, 2020 9:32 PM UTC

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?

4 replies

bisswangAdobe EmployeeAccepted solution
Adobe Employee
Nov 12, 2020 9:32 PM UTC

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?

Translate
shelly-goel
Adobe Employee
Adobe Employee
Nov 22, 2020 1:08 AM UTC

@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?

Translate
Sukrity_Wadhwa
Level 4
Dec 1, 2020 11:11 AM UTC

hi @johnnybravo,

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

Thanks!

Translate
Sukrity Wadhwa
Level 3
Jan 13, 2021 8:02 PM UTC
Yes, I got it resolved. Thanks very much for the follow-up.
Translate