Get-Mailbox from imported list of last names - PowerShellCommunity.org - Windows PowerShell Discussion Forums - Using PowerShell

Get-Mailbox from imported list of last names

Last Post 16 Dec 2011 02:01 PM by james_intune. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

Jason Eisel User is Offline

New Member
Posts:1
Avatar

16 Dec 2011 10:08 AM
I'm trying to pull mailbox info from an imported list of last names...I'm trying to do something similar to the following: $IMPORTED = Import-Csv "XXXXXXX.csv" \| select LastName Get-Mailbox \| where {$_.DisplayName -like $IMPORTED} This script obviously doesn't work, but that's the direction I want to go...any ideas?

Karl Mitschke User is Offline

Basic Member
Posts:457
Avatar

16 Dec 2011 11:47 AM
I'd do it like this: foreach ($Person in Import-Csv "XXXXXXX.csv") { $LastName = "$($Person.LastName)" Get-Mailbox -Filter "DisplayName -like '$LastName'" } Karl

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

james_intune User is Offline

New Member
Posts:2
Avatar

16 Dec 2011 01:50 PM
please see next post - code editor here is near impossible to correct

james_intune User is Offline

New Member
Posts:2
Avatar

16 Dec 2011 02:01 PM
If I want to set calendar permissions for a list of users, and using the above script by Karl, could I do foreach ($Person in Import-Csv "XXXXXXX.csv") { $username = "$($Person.username)" add-mailboxfolderpermission -identity $username:\calendar -user execassistant -accessrights reviewer } Also, where would i add a -whatif to the above in order to view the changes made before making the actual changes? After the add-mailboxfolderpermission line or after the foreach loop? Thanks

You are not authorized to post a reply.

Active Forums 4.3