Sorry, that last line in the script should have been" $totalmsgs += $stats.msgcount
________________________________ From: Campbell, Rob [mailto:rob_campb...@centraltechnology.net] Sent: Wednesday, May 06, 2009 11:45 AM To: MS-Exchange Admin Issues Subject: RE: Total messages handled by Exchange I've only got 3 HT servers, all within one state, and well connected. I'm running it on one server and having it pull the logs from the other servers. Running it locally on each one should be easily do-able. You'll just have to add some code at the end to copy out the resulting file to a central location. The totaling is scripted, and it's a relatively simple process in PS as long if you're using .csv files. You just do an import-csv and reference the columns by the column heading names like they were properties. If I've got 30 .csv files named mailstats<date>.csv and they all have a column named "msgcount" then $statfiles = gci mailstats*.csv Foreach ($statfile in $statfiles){ $stats = import-csv $statfile $totalmsgs += $stats.msg } If all you're accumulating is a single value for message count, the I'd just use a simple text file and use get-content to read that value, but I think you'll find that once you start gathering stats from those logs you'll want to get more than just one piece of information while you're at it. I'm getting ready to add some code that will look at the DL expansion events, and start keeping track of the last time a DL was used so we can start cleaning up the list of distribution groups and mail-enabled security groups that never actually get used. ________________________________ From: Barsodi.John [mailto:john.bars...@igt.com] Sent: Wednesday, May 06, 2009 11:25 AM To: MS-Exchange Admin Issues Subject: RE: Total messages handled by Exchange Interesting... are you running this on each Hub Transport server? I have HT servers all over the world, so I'd have to run this locally and then copy to a central location then do more data massaging. How are you handling the totaling? Are you doing this manually or by script? How many HT servers are you running against? - John Barsodi From: Campbell, Rob [mailto:rob_campb...@centraltechnology.net] Sent: Wednesday, May 06, 2009 9:13 AM To: MS-Exchange Admin Issues Subject: RE: Total messages handled by Exchange I run a PS script that does this. It runs as a scheduled task in the early am, pulls the message tracking logs for the previous day, and reads through the log entries and accumulates the message counts into a csv. At the end of the month, it pulls all the daily csv's back in and creates a monthly total report. I'm doing it per user, and splitting it out between internal and external for both sent and received, as both message counts and total bytes, so what you're after should be considerably easier if all you're after is just message counts. ________________________________ From: Barsodi.John [mailto:john.bars...@igt.com] Sent: Wednesday, May 06, 2009 11:03 AM To: MS-Exchange Admin Issues Subject: Total messages handled by Exchange So I have a request from my management to start tracking total Messages handled by Exchange on a monthly basis. I know there are software packages like Quest MessageStats that will easily produce this for me, however we have $0 in the budget for this. Wondering if anyone has had to produce this type of data and how they went about it? I'm running Exchange 2007 SP1 and have 10 Hub Transport servers across our Enterprise and I have journaling enabled for our Archive system. Our Archive System reports unique/deduplicated messages, not total messages that would see transport in Exchange. Any ideas would be helpful. TIA. - John Barsodi ************************************************************************************************** Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ************************************************************************************************** ************************************************************************************************** Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ************************************************************************************************** ************************************************************************************************** Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ************************************************************************************************** ~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~ ~ http://www.sunbeltsoftware.com/Ninja ~