various impossible extractions | Community
Skip to main content
April 20, 2020
Question

various impossible extractions

  • April 20, 2020
  • 2 replies
  • 11963 views

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

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

2 replies

Sukrity_Wadhwa
Community Manager
Community Manager
April 29, 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 

Sukrity Wadhwa
pascal76Author
April 29, 2020
Thank you. Let us say it is better than asking me to check on Google .........
pascal76Author
May 4, 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 @1716897 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

_Pascal_1
May 10, 2020

Hello @satheeskannak

Please take a look at my first post
=> agregates from recipient broadlogs: ex: email_domain, failure reason, count(*)