Solved

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

Posted on 2004-04-16
6
305 Views
Last Modified: 2010-04-11
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
Comment
Question by:zenportafino
  • 3
  • 3
6 Comments
 
LVL 1

Accepted Solution

by:
abobw earned 125 total points
ID: 10844588
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
 
LVL 1

Author Comment

by:zenportafino
ID: 10845023
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
 
LVL 1

Expert Comment

by:abobw
ID: 10849702
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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 1

Author Comment

by:zenportafino
ID: 10852069
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
 
LVL 1

Expert Comment

by:abobw
ID: 10859023
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
 
LVL 1

Author Comment

by:zenportafino
ID: 10866001
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let’s list some of the technologies that enable smooth teleworking. 
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question