Solved

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

Posted on 2004-04-16
6
318 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
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…

761 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