4
report for alias traffic
Idea shared by Sabatino - 5/22/2023 at 2:55 AM
Proposed
I have a number of domain aliases.
I wish I had the stats on them. They generate outgoing messages and I'm interested in knowing their volume.

The stats do not currently appear to include aliases
Sabatino Traini
      Chief Information Officer
Genial s.r.l. 
Martinsicuro - Italy

6 Replies

Reply to Thread
0
I think that's a great idea. I would also like to know how many emails are still coming in via which alias in a given time.
0
I have SQL Server stored procedures to parse the SMTP log and Delivery log into (Microsoft) SQL Server tables, creating one record per message.   It uses the "OPENROWSET BULK ()" command to parse the text, which has surprisingly good performance when parsing text files.  

Send me a private message with your email address if you want a copy of the code.   I use the full version of SQL, but SQL Express should work as well.
0
Thanks Douglas. I'm very interested in your solution I had started developing a console program in dot.net but then I didn't have time to finish it.



Sabatino Traini Chief Information Officer Genial s.r.l. Martinsicuro - Italy
0
This problem does not appear to have been resolved with the 8657
Sabatino Traini Chief Information Officer Genial s.r.l. Martinsicuro - Italy
0
This problem does not appear to have been resolved with the 8657
Sabatino Traini Chief Information Officer Genial s.r.l. Martinsicuro - Italy
0
Andrea Free Replied
Employee Post
Hi Sabatino,

I'll change this from a question to an idea so we can track the agreement with this request. 
Andrea Free SmarterTools Inc. 877-357-6278 www.smartertools.com

Reply to Thread