Welcome to Powergui.org - an open source community for Windows Powershell

PowerGUI.org PowerGUI.org and blogs

Forums » Request a Script

Thread: Get

This question is answered.


Permlink Replies: 3 - Pages: 1 - Last Post: Apr 8, 2012 11:19 PM by: Abid
Albertwt


Posts: 161
Registered: 10/7/08
Get
Posted: Oct 14, 2008 4:18 PM
 
  Click to reply to this thread Reply

Hi All,

I'd like to get the total message that was sent during a particular time from a specific address, then i tried to execute the script below but it failed :-|

can anyone help me to point out the issue please ?

get-messagetrackinglog -Sender "webmaster@illcom.com.au" -Start "7/09/2008" -End "8/09/2008" | fl| ft -wrap | Export-Csv c:\Test.csv

Error Message:

WARNING: There are more results available than are currently displayed. To view them, increase the value of the ResultSize parameter.


thanks.



KirkAMunro


Posts: 1,049
Registered: 3/20/07
Re: Get
Posted: Oct 14, 2008 4:58 PM   in response to: Albertwt
Answered
  Click to reply to this thread Reply

Remove the 'fl | ft -wrap |' section and you should be just fine.

fl and ft are for formatting output within the PowerShell host.  You are exporting the data to a csv so you don't want it formatted.  Also, fl and ft cannot be used together in the same pipeline.

Regarding the warning, that is standard when dealing with a large volume of data for certain cmdlets.  The QAD cmdlets default to a maximum of 1000 objects retrieved during one call.  To override this, you set the sizelimit to 0.  This cmdlet seems to work the same way, so you need to indicate that you want all results, not just the first X results.

You should do this instead:

get-messagetrackinglog  -ResultSize Unlimited -Sender "webmaster@illcom.com.au" -Start "7/09/2008" -End "8/09/2008" | Export-Csv c:\Test.csv

Let me know if that resolves your issues for you.

--
Kirk Munro [MVP]
Poshoholic
http://poshoholic.com

Kirk Munro [MVP]
Poshoholic

My blog: http://poshoholic.com
Follow me on Twitter: http://twitter.com/poshoholic
Albertwt


Posts: 161
Registered: 10/7/08
Re: Get-Message TrackingLog
Posted: Oct 14, 2008 9:03 PM   in response to: KirkAMunro
 
  Click to reply to this thread Reply


Yes Kirk,

it worked !!!


thanks so much !!!



Abid

Posts: 1
Registered: 4/8/12
Re: Get-Message TrackingLog
Posted: Apr 8, 2012 11:19 PM   in response to: Albertwt
 
  Click to reply to this thread Reply

wha about this script, it gives same warning and no result

Get-TransportServer | Get-MessageTrackingLog -Start "04/08/2012" -End "04/09/2012" | ? {$_.RecipientStatus -match "Bcc"} | Select TimeStamp, Sender, MessageSubject, Recipients, RecipientStatus > "C:\send search.txt"

:(




Legend
MVP: 2501 + pts
Guru: 2001 - 2500 pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums