Get-MailboxFolderPermission of multiple Calendars from the Pipeline using CSV Import
Hi All,
We have an Exchange 2010 SP2 environment...
I was trying to figure out how query multiple Resource Room Calendars for their Access Rights.
I first got a list of the Resource Rooms I wanted based off their CustomAttribute1:
C:\>Get-Mailbox -ResultSize unlimited | Where-Object { $_.CustomAttribute1 -eq "Specific Resource" } | select-object Alias | export-csv "C:\ResourceRooms.csv"
The resultant csv file's alias contents were encapsulated in quotes...
I then tried variations of the following and I don't get an error or anything:
C:\>Import-Csv "c:\ResourceRooms.csv" | ForEach-Object { Get-MailboxFolderPermission -identity $($_ +':\Calendar') } | ft User,AccessRights
I tried this based off of many searches...one of them looked promising, but I'm posting here in the hopes someone sees what I'm doing incorrectly:
http://powershell.com/cs/forums/p/8035/13115.aspx
Any ideas - Thank you for your time!
Mr Mister
February 7th, 2012 3:23pm
Hi Mr Mister,
Change your command C:\>Import-Csv "c:\ResourceRooms.csv" | ForEach-Object { Get-MailboxFolderPermission -identity $($_ +':\Calendar') } | ft User,AccessRights to this:
Import-Csv "c:\ResourceRooms.csv" | ForEach-Object {
$uer=$_
$path=$user+:\Calendar
Get-MailboxFolderPermission identity $path |ft User, AccessRights}
Thanks,
Evan
Evan Liu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2012 5:18am
Hi Mr Mister,
Change your command C:\>Import-Csv "c:\ResourceRooms.csv" | ForEach-Object { Get-MailboxFolderPermission -identity $($_ +':\Calendar') } | ft User,AccessRights to this:
Import-Csv "c:\ResourceRooms.csv" | ForEach-Object {
$user=$_.Alias
$path=$user+:\Calendar
Get-MailboxFolderPermission identity $path |ft User, AccessRights}
Thanks,
Evan
Evan Liu
TechNet Community Support
February 9th, 2012 1:13pm