Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

various impossible extractions

Avatar

Level 1

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

9 Replies

Avatar

Administrator

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 

Avatar

Level 1
Thank you. Let us say it is better than asking me to check on Google .........

Avatar

Administrator
@pascal76 If this documentation was not helpful, kindly let us know and we will look into this further.

Avatar

Level 1

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

Avatar

Community Advisor

Hi @pascal76,

 

I understand broadlogs is resource sensitive table on ACS to pull the data from ACS. Are you extracting this information on recurring basis maybe daily once? And I see all you're trying to export the information. But still i couldn't understand what is not achievable here in ACS? If you could share more information i will see if i can help you anything.

 

Thanks!

SK

Avatar

Level 1

Hello @SatheeskannaK

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