Exchange Server Forums

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Using get-messagetrackinglog to track throughput

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [Microsoft Exchange 2007] >> Management >> Using get-messagetrackinglog to track throughput Page: [1]
Login
Message << Older Topic   Newer Topic >>
Limited time MSExchange.org offer! -- 1.Sep.2008 1:00:00 PM
TechGenix and SolarWinds have partnered to provide free copies of SolarWinds Exchange Monitor to all visitors who join the MSExchange.org Forums. SolarWinds Exchange Monitor is a handy desktop dashboard that continuously monitors Microsoft Exchange to deliver real-time insight into Exchange services, mail queue sizes, and host server health. Learn more about Exchange Monitor and the free offer!
Using get-messagetrackinglog to track throughput - 4.Mar.2008 10:46:17 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Hi all,

am using the following to list all mails for a particular day.
get-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID "RECEIVE" -Start "26/02/2008  00:01:00" -End "26/02/2008 23:59:00" >c:\tracking\ex04_26_rx.txt
But it does not display the message size. I've tried adding various options to be able to see the message size, but still struggle with this new interface. Can any point me in the right direction? I've looked on technet, and it doesn't explain it very wel to me.



_____________________________

Rgds
Mike
Post #: 1
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 8:49:04 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		Hiya Mike,

Give this a shot: 

get-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID "RECEIVE" -Start "02/26/2008  1:00AM" -End "02/26/2006 11:59PM" | format-table sender,recipients,totalbytes >c:\tracking\ex04_26_rx.txt


Bob

(in reply to mikeedwards)
Post #: 2
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 8:55:39 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Hi Bob, Thank you for your reply. I managed to work it out last night and got part way to the results I expected.
I used
get-messagetrackinglog -ResultSize Unlimited -server "adeex04" -EventID "RECEIVE" -Start "26/02/2008  00:01:00" -End "03/03/2008 23:59:00" |fT -Property Sender, Recipients, totalbytes >c:\tracking\1_week_RX-04.txt

I discovered that FT can be used in place of Format-Table. now the next issue is the data.
This is what is shows in the txt file
Sender                     Recipients                                TotalBytes
------                     ----------                                ----------
Administrator@rgate1.en... {Razorlogs@endsleigh.co...                     30938
MAILER-DAEMON@endsleigh... {Postmaster@endsleigh.c...                      2704
MAILER-DAEMON@endsleigh... {Postmaster@endsleigh.c...                      2704
MAILER-DAEMON@endsleigh... {Postmaster@endsleigh.c...                      2704

so it is truncating the info from the logs. Now I need to find out how to get it untruncated so I can start extracting data for Management reports. Can you assist further?

Mike



(in reply to tfd6412)
Post #: 3
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:04:33 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		How about replacing ft with fl (format-list) instead?  It'll be a different format to read but won't have any trucated columns.

Bob

(in reply to mikeedwards)
Post #: 4
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:09:23 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Hi Bob,

Format is even worse. perfect world ( we all hope for)

Sender - Recipient - Size on on one line which is easy to manipulate in Excel. This format is harder and I'd have to use a cube builder to manipulate the text.

Timestamp               : 26/02/2008 00:01:20
ClientIp                : 10.13.1.242
ClientHostname          :
ServerIp                : 10.31.2.26
ServerHostname          : xxxxxx
SourceContext           : 08CA40FC74CCEB25;2008-02-26T00:00:54.999Z;0
ConnectorId             : xxxxxx\Inbound SMTP mail
Source                  : SMTP
EventId                 : RECEIVE
InternalMessageId       : 77636
MessageId               : <20080226000054.AJS02603@rgate1.endsleigh.co.uk>
Recipients              : {Razorlogs@endsleigh.co.uk}
RecipientStatus         : {}
TotalBytes              : 30938
RecipientCount          : 1
RelatedRecipientAddress :
Reference               :
MessageSubject          : System Log for xxxxxx.endsleigh.co.uk from Feb 25, 20
                         08
Sender                  : Administrator@xxxxx.endsleigh.co.uk
ReturnPath              : Administrator@xxxxx.endsleigh.co.uk
MessageInfo             : 10I:

Mike

(in reply to tfd6412)
Post #: 5
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:15:41 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		Going back to using format-table...  right before you define which properties you want, try adding the -wrap parameter like so: 

get-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID "RECEIVE" -Start "02/26/2008  1:00AM" -End "02/26/2006 11:59PM" | format-table -wrap sender,recipients,totalbytes >c:\tracking\ex04_26_rx.txt


Outside of that, I'm not sure what else to do to get the format you want.  The -wrap parameter will allow the text to wrap to the next line without truncating it.  There might be something you can do with the export-csv command.  http://technet.microsoft.com/en-us/library/bb978597.aspx

< Message edited by tfd6412 -- 6.Mar.2008 9:26:13 AM >

(in reply to mikeedwards)
Post #: 6
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:24:55 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Bob,

that's a little closer, it now has the data, but seems to wrap it to the line below. Do I need to pre specify a format? I did a similar thing trying to get mailbox size info and built the command up a bit at a time.
Sender                     Recipients                                TotalBytes
------                     ----------                                ----------
Administrator@rgate1.endsl {Razorlogs@endsleigh.co.uk                     30938
eigh.co.uk                 }                                                  
[email=e-alert@ifig.org]e-alert@ifig.org[/email]           {Sharon.Cremin@endsleigh.c                      1560
                          o.uk}                                              

(in reply to tfd6412)
Post #: 7
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:28:06 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		Hey Mike,

I did a little ninja edit before you got this reply in.  Refresh to see my post above about export-csv

(in reply to mikeedwards)
Post #: 8
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:31:20 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Bob,

thank you for taking the time with this. I'm new to Exchange 2007, and am currently on a steep learning curve, and with folks like yourself willing to share info an help, it's making that curve feel a little less steep.

I have a peek at that link, and will let you know how I get on.

Mike

(in reply to tfd6412)
Post #: 9
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 9:47:16 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		I'm not as handy with the EMS as I'd like to be either.  Good thing for both of us, I'm a stubborn SOB . 

get-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID "RECEIVE" -Start "02/26/2008  1:00AM" -End "02/26/2006 11:59PM" | select-object sender,@{Name="Recipients";Expression={$_.recipients}},totalbytes | export-csv c:\tracking\ex04_26_rx.csv

(in reply to mikeedwards)
Post #: 10
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:07:38 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Bob,

Close, i can see what you are trying to do by building the query, but I get the this reply in red.

Get-MessageTrackingLog : Cannot bind parameter 'Start'. Cannot convert value "0
2/26/2008  1:00AM" to type "System.DateTime". Error: "String was not recognized
as a valid DateTime."
At line:1 char:89
+ get-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID "RECE
IVE" -Start  <<<< "02/26/2008  1:00AM" -End "02/26/2006 11:59PM" | select-objec
t sender,@{Name="Recipients";Expression={$_.recipients}},totalbytes | export-cs
v c:\tracking\excsv.csv

(in reply to tfd6412)
Post #: 11
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:10:08 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		This is one I have for getting mailbox size

use this script to output the mail box size on Exchange server. Get-MailboxStatistics -server "adeex06" | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(KB)";expression={$_.TotalItemSize.Value.ToKB()}},ItemCount > c:\mailboxes.txt Seems to be similar in make up to what you posted. Mike

(in reply to mikeedwards)
Post #: 12
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:11:32 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		Ooops.  Try using the format you originally used for the date and time.  Sorry 'bout that.  Day/month/year 00:00:00

(in reply to mikeedwards)
Post #: 13
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:25:51 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Bob,
tried that too.
[PS] C:\Documents and Settings\edwm1>get-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID "RECEIVE" -Start "26/02/2008 00:01:00" -End "27/02/2006 00:01:00" | select-object sender,@Name="Recipients";Expression={$_.recipie
nts}},totalbytes | export-csv c:\tracking\allitems.csv

The search time range was incorrectly specified. The End and Start parameter va
lues can't be the same. At line:1 char:1+ g <<<< et-messagetrackinglog -ResultSize Unlimited -Server "adeex04" -EventID
"RECEIVE" -Start "26/02/2008 00:01:00" -End "27/02/2006 00:01:00" | select-obj
ect sender,@{Name="Recipients";Expression={$_.recipients}},totalbytes | export-
csv c:\tracking\allitems.csv

Soooo Close
Mike

(in reply to tfd6412)
Post #: 14
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:29:49 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		Check the year on your end date. 

(in reply to mikeedwards)
Post #: 15
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:32:40 AM   
mikeedwards

 

Posts: 18
Joined: 30.Dec.2005
Status: offline 		Bob,

what can I say, "You da Man"

Thanks for your help, wish I had your eagle eyes. Worked perfectly.
Kind Regards
Mike

(in reply to tfd6412)
Post #: 16
RE: Using get-messagetrackinglog to track throughput - 6.Mar.2008 10:34:37 AM   
tfd6412

 

Posts: 88
Joined: 24.Dec.2007
From: Florida
Status: offline 		Any time, good sir.  I learned a couple things myself.  For instance, that typo was you simply copying MY typo. 

Take care!
Bob

< Message edited by tfd6412 -- 6.Mar.2008 10:37:10 AM >

(in reply to mikeedwards)
Post #: 17

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [Microsoft Exchange 2007] >> Management >> Using get-messagetrackinglog to track throughput Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts