various impossible extractions

Avatar

Avatar
Level 1
pascal76
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
pascal76
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile
pascal76
Level 1

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)

Avatar

Avatar
Level 1
pascal76
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
pascal76
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile
pascal76
Level 1

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

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

158 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

158 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
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