?
Solved

Exchange Shell

Posted on 2015-02-05
1
Medium Priority
?
67 Views
Last Modified: 2015-02-05
I have a spread sheet of about 100 users, and on the spread sheet I have the email addresses of the user which corresponds to their principle name. I would like to run a script in exchange shell to import these users into a variable and get their samAccountname, from the email address. I would like this exported to a csv file. Anyone has any idea on how to get this accomplished. Thanks in advance
0
Comment
Question by:timgreen7077
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
timgreen7077 earned 0 total points
ID: 40592820
Disregard question, I manage to get this script to work:

$userlist = Import-Csv c:\excel\test.csv
foreach ($user in $userlist) {
$perms += @(get-mailbox -Identity $user.emailaddress)
}
$perms | select displayname, samaccountname | export-csv c:\excel\respond.csv
0

Featured Post

Ransomware Attacks Keeping You Up at Night?

Will your organization be ransomware's next victim?  The good news is that these attacks are predicable and therefore preventable. Learn more about how you can  stop a ransomware attacks before encryption takes place with our Ransomware Prevention Kit!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question