various impossible extractions

pascal76

20-04-2020

Hello,

I would like to export  these data in outlook ACS :
- subjects from nms:delivery
- sender email addresses  from nms:delivery
- all fields from nms: deliveryLogStats
- agregates from recipient broadlogs: ex: email_domain, failure reason, count(*)

All that seems to be impossible to do and that is a small list of the software limitations 😞
Can you confirm or give me solutions please ?

Regards,
Pascal

Accepted Solutions (0)

Answers (2)

Answers (2)

pascal76

04-05-2020

There is an other serious issue:

We can extract broadlogs but the broadlog id is no more a numerical value... it is a 64 chars string now (ex: 59515227fe2a7a8a941a24c5ab964c73dda8df4b638220853bff53e00bdbecd3)
Thus when you import that on database (where @ID has to be a unique index) it takes a very long time (1 hour for a few million lines)

=> we can't do aggregates on the same table on ACS and it is very high ressource consuming (to not say impossible) to do it with raw data.

Pascal

Sukrity_Wadhwa

Employee

29-04-2020

Hi @pascal76,

 

Please check out this documentation on Exporting Logs. This might prove helpful for your query. Do reach out if you have more questions.

 

Regards,
Sukrity