This seems to be working:
Get-publicfolder -recurse -resultsize unlimited | Select Name,
@{Name=’replicas’;Expression={[string]::join(";", ($_.replicas))}} |
Export-CSV c:\temp\PFReplicas.csv
Stole it from here:
http://exchangeshare.wordpress.com/2008/12/10/powershell-export-multivalued-properties/
Now I just have to parse it out and figure out what it's doing.
Kurt
On Thu, Apr 24, 2014 at 4:30 PM, Sean Martin <[email protected]> wrote:
> Try this:
>
> $results = get-PublicFolder -recurse -resultsize unlimited |ft
> name,replicas
>
> $results | export-csv c:\temp\pf.txt -encoding ascii
>
> - Sean
>
>> On Apr 24, 2014, at 2:39 PM, Kurt Buff <[email protected]> wrote:
>>
>> All,
>>
>> Definitely wasn't expecting this difference. I've got over 8700 PFs
>> and I want to see what's what before a start replicating PFs and
>> moving them. I'd like to get it all nice and neat in a spreadsheet for
>> review, and it's not working.
>>
>> This line:
>> [PS] C:\temp>get-PublicFolder -recurse -resultsize unlimited |ft
>> name,replicas | out-file c:\temp\pf.txt -width 400 -encoding ascii
>>
>> Gets me this output (edited to remove extraneous spaces):
>> Name Replicas
>> ---- --------
>> IPM_SUBTREE {}
>> Admin {USXCH\First Storage
>> Group\Public Folder Store (USXCH), USPublic}
>> VacationCalendar {USXCH\First Storage
>> Group\Public Folder Store (USXCH)}
>>
>>
>> This line:
>> [PS] C:\temp>get-PublicFolder -recurse -resultsize unlimited |ft
>> name,replicas | export-csv c:\temp\pf.txt -encoding ascii
>>
>> Gets me this output:
>> #TYPE Microsoft.PowerShell.Commands.Internal.Format.FormatStartData
>> "ClassId2e4f51ef21dd47e99d3c952918aff9cd","pageHeaderEntry","pageFooterEntry","autosizeInfo","shapeInfo","groupingEntry"
>> "033ecb2bc07a4d43b5ef94ed5a35d280",,,,"Microsoft.PowerShell.Commands.Internal.Format.TableHeaderInfo",
>> "9e210fe47d09416682b841769c78b8a3",,,,,
>> "27c87ef9bbda4f709f6b4002fa4af63c",,,,,
>> "27c87ef9bbda4f709f6b4002fa4af63c",,,,,
>> "27c87ef9bbda4f709f6b4002fa4af63c",,,,,
>>
>>
>
>
