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:14pm
This is very helpful. I'm trying to redirect the output to a file. In the last line with the Get-MailboxFolderPermission I've modified it to be this:
Get-MailboxFolderPermission -identity $path |ft $path,User,AccessRights > C:\Users\me\Desktop\CalendarPermissions\IPCalPermsOutput.txt }
Only the last entry in the imported csv file is displaying, however when I run the command without the redirect > it shows everything the way I want it shown:
user:\Calendar User
AccessRights
--------------------- ----
------------
Default
{AvailabilityOnly}
User
{Reviewer}
User
{Editor}
User
{Editor}
User
{Reviewer}
EXCH-MRAdmins {Editor}
EXCH-MR-CalendarContact {Editor}
View All IP Calendars {Reviewer}
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2012 4:33pm