I'm trying to export a list of all SMTP's assigned to my Ex2003 mail enabled Public Folders using the Get-QADObject cmdlet against the 'microsoft exchange system objects' container, but I am having a few problems.
I am using the code below, but when I run it, all I get is "System.Object"" as the output next to the Folder name.
I've tried using the '-width' setting, and this does work (ish), but the problem is that some of my PF's have 100 Fax addresses and only one smtp, and even at a very wide width (which leads to a huge output file) I am not 100% sure it is exporting every smtp, and anyway, I only want the SMTP's, not the Fax addresses.
I planned to use this export and manipulate in Excel, but what I would ideally like, is a list of folders, and their SMTPs only next to them, and if I can do that directly from within PS, then great, ie -
folder1, smtp1, smtp2
folder2, smtp1, smtp2, smtp3
folder3, smtp1, smtp2
I am sure I doing something daft, or doing it cmpletely the wrong way, but help would be appreciated!
Get-QADObject -SearchRoot 'my.domain.com/microsoft exchange system objects' -IncludedProperties proxyaddresses | select name,proxyaddresses | Out-File c:\pfsmtpexport.txt