header1   header
header
header Register : : Login header
header
connector   connector
menuleft menuright
submenu   submenu
left
Combine Public Folder commandlets to one .csv
Last Post 15 Nov 2011 04:56 AM by LRoszel. 2 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
LRoszelUser is Offline
New Member
New Member
Posts:4
Avatar

--
14 Nov 2011 01:45 PM
    I need to get one .csv file that has the outputs of these two commandlets in one .csv.  I have tried foreach loops, piping commandlets and just cannot find the answer.  Any help you can provide would be greatly appreciated.

    Get-PublicFolder -Identity \ -Recurse | Get-PublicFolderClientPermission | ? {$_.AccessRights -eq "Owner"} | Select-Object identity,user | Export-csv c:\xxx\xxx

    &

    Get-PublicFolderStatistics -server XXXXXXXX | Select-Object  FolderPath, ItemCount, LastAccessTime, LastModificationTime, AdminDisplayName, AssociatedItemCount, totalitemsize, servername, ownercount | Export-csv c:\xxx\xxxx
    Karl MitschkeUser is Offline
    Basic Member
    Basic Member
    Posts:457
    Avatar

    --
    14 Nov 2011 02:06 PM
    Are you meaning that the csv file should have the following?
    PF_Identity,OwnerName,FolderPath, ItemCount, LastAccessTime, LastModificationTime, AdminDisplayName, AssociatedItemCount, totalitemsize, servername, ownercount ?

    Karl
    http://unlockpowershell.wordpress.com
    Co-Author, Windows PowerShell 2.0 Bible
    -join("6B61726C6D69747363686B65406D742E6E6574"-split"(?<=\G.{2})",19|%{[char][int]"0x$_"})
    LRoszelUser is Offline
    New Member
    New Member
    Posts:4
    Avatar

    --
    15 Nov 2011 04:56 AM
    Yes.  PF_Ident and OwnerName are not valid objects when using the Get-PublicFolderStatistics action.  Can only get owner information using the Get-PublicFolderClientPermission action.
    You are not authorized to post a reply.


    Active Forums 4.3
    right
    footer   footer
    footer Sponsored by Quest Software • SAPIEN Technologies • Compellent • Microsoft Windows Server 2008 R2 footer
    footer   footer