Delivery Logs Query Time

[#1]

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,

[#2 · Accepted solution]

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]

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

[JohnnyBravo]

hi @JohnnyBravo,

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

Thanks!

[JohnnyBravo]

Yes, I got it resolved. Thanks very much for the follow-up.