Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Create a report in exchange 2000 of email sent by a user for past week?

I've run a query in message tracking and need to print the list that it creates.  Is there a way to do this?
0
zenportafino
Asked:
zenportafino
  • 3
  • 3
1 Solution
 
abobwCommented:
Message tracking just uses the log files contained in the Program Files\ExchSrvr\ServerName.log folder; you can open those log files directly in Excel, Access, or a good text editor, and print out what you need.

Good luck.
0
 
zenportafinoAuthor Commented:
Thanks it works but it's painful. I've only got the 5 previous days in there.  Is there a setting that will change that?
0
 
abobwCommented:
No pain, no gain?

You can correct the number of days.  In system manager, drill down through the hierarchy and find the server.  Right click, and tell it how long to leave the log files sitting on the server.

Hope that helps.

Bob
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
zenportafinoAuthor Commented:
Thanks abobw.  I will do that.  Now all I have to figure out is how to automatically export these files into sql server so that I can have access to a managable DB of email traffic...
0
 
abobwCommented:
Assuming you're running Microsoft SQL server, the way to do it is to have a DTS package pull the log files in on a nightly basis - should not take you more than a few minutes to work that out.

I'd probably do something like:

a.  Figure out whenever the log file is rolled over
b.  Schedule a simple batch file script to move/copy the old log file to a processing directory and rename it
c.  Run the DTS script against the file in the processing directory - this can be scheduled as well.
d.  Run a final script to rename the file so that you don't process it again.


There's a few different ways to hammer out the details, but it's all pretty easy.

Good luck

Bob
0
 
zenportafinoAuthor Commented:
Thank you sir!  We've got a few strong DBA's at work so I'll get their help and let you know how hard they laugh at me!  - Jest kidding.  I appreciate your help and will give it a shot. Now that I think of it we could use the data to work on some more plans to blacklist and try to manage the spam issues we have perhaps a little better.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now