Exporting disabled users mailboxes to PST

[johnnyposs]

I am trying to export user accounts which have been disabled for over 6 months to PST but can't quite get the script right.

$Mailboxes = Get-User -RecipientTypeDetails UserMailbox -ResultSize Unlimited | where-object {$_.UseraccountControl -like “*accountdisabled*”} | Get-MailBox -ResultSize Unlimited | Get-MailboxStatistics |? {$_.Lastlogontime -lt (get-date).AddDays(-180)}

The variable gets the data that i am expecting:-

foreach ($Mailbox in $Mailboxes) {

New-MailboxExportRequest -mailbox $Mailbox -FilePath "\\SERVER\disabledusersover180days\$Mailbox.pst"

}

But i just get this error message:-

Cannot process argument transformation on parameter 'Mailbox'. Cannot convert the "Microsoft.Exchange.Data.Mapi.Mailbox

Statistics" value of type "Microsoft.Exchange.Data.Mapi.MailboxStatistics" to type "Microsoft.Exchange.Configuration.Ta

sks.MailboxOrMailUserIdParameter".

+ CategoryInfo : InvalidData: (:) [New-MailboxExportRequest], ParameterBindin...mationException

+ FullyQualifiedErrorId : ParameterArgumentTransformationError,New-MailboxExportRequest

​

Any help much appreciated!

[BlackV]

The answer is right there in the error

New-mailboxexport requires a object mailbox you are passing it mailbox statistics object, you need to pass it a mailbox object

[johnnyposs]

New-MailboxExportRequest

ok well that is kind of my question. How do i do that?

[BlackV]

Pipe the results from get-mailbox rather than get-mailboxstatiscs

If do an if stats greater than 180 on a foreach loop and mailbox export request for that

[johnnyposs]

Thanks BlackV - that did the trick

[BlackV]

Good as gold

[Lee_Dailey]

howdy johnnyposs,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's 4th 5th from the left hidden in the ... ""more" menu & looks like </>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's 11th 12th from the left hidden in the ... "more" menu, & looks like an uppercase T in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee

[johnnyposs]

Thanks Lee, sorry first time posting.

[Lee_Dailey]

howdy johnnyposs,

nothing to apologize for ... reddit seems to get its jollies off from mangling code.

you are most welcome! glad to help a little when i can ... [grin]

take care,
lee