Powershell experts critique this command please

[Relentless81]

Hi,

I'm not the best with PS and I've pieced this together by googling, I need to know I've done it right as the result is unexpected. If you ran this command what would you expect it to do please?

get-mailbox -resultsize unlimited | Search-Mailbox -SearchQuery "to:***@***.com AND from:***@***.com" -EstimateResultOnly | select displayname,resultitemscount | Export-Csv c:\scripts\Results.csv

Thanks

 

[Webster]

What are you trying to achieve?

 

[smogsy]

Hi,

I'm not the best with PS and I've pieced this together by googling, I need to know I've done it right as the result is unexpected. If you ran this command what would you expect it to do please?

get-mailbox -resultsize unlimited | Search-Mailbox -SearchQuery "to:***@***.com AND from:***@***.com" -EstimateResultOnly | select displayname,resultitemscount | Export-Csv c:\scripts\Results.csv

Thanks

Get All results from mail server that have emails to: [email protected] [email protected], showing the displayname & count them into into a CSV

So CSV would look like

Email Count
[email protected] 40
[email protected] 50
so on..

 

[Relentless81]

Get All results from mail server that have emails to: [email protected] [email protected], showing the displayname & count them into into a CSV

So CSV would look like

Email Count
[email protected] 40
[email protected] 50
so on..

Yes correct thanks for confirming, you missed that it should be To and From the mail address and I figured out why it wasn't working without throwing an error, it should be "Or" not "And" its working fine now and have the results I need

Cheers

 

[smogsy]

Yes correct thanks for confirming, you missed that it should be To and From the mail address and I figured out why it wasn't working without throwing an error, it should be "Or" not "And" its working fine now and have the results I need

Cheers

no problem, PS can be fun & also horrid at the same time.

 

[teaboy5]

Are you using O365? Just run a message trace?

 

[Relentless81]

Are you using O365? Just run a message trace?

Yes but mailboxes still in on Prem, not migrated yet due to an issue with voicemail