On Tue, Mar 5, 2013 at 11:05 AM, Michael B. Smith <[email protected]> wrote: > How many users do you have? How many users are in the CSV file? > > Approximate, in both cases, is fine.
CSV users = 1300. AD users = <1100. What I am most interested in: AD users NOT in CSV file. There will always be users in CSV file not in AD; that is fine. What I need to know is - who is in AD that isn't accounted for, in the CSV file. > > -----Original Message----- > From: Michael Leone [mailto:[email protected]] > Sent: Tuesday, March 5, 2013 10:54 AM > To: NT System Admin Issues > Subject: Powershell advice - matching an AD user to a value in an array > > So I have this CSV file of names (LastName, FirstName). What I need to > do: find every AD user that is in that CSV file. If they are not there, > report that, too. > > So I imported the whole CSV into an array, and use Quest to get all active > user objects: > > $AllCSVUsers = @(Import-CSV $InputFileName) $TotCntCSVUsers = > $AllCSVUsers.count > > $AllUsers = Get-QADUser -SizeLimit 0 | Select LastName,givenName,DisplayName > > But I am unclear on how to (easily) search each AD user against the CSV array. > > ForEach ($AD_User in $AllUsers) > { > $LastName=$AD_User.LastName > $FirstName=$AD_User.FirstName > > - then what? Do loop thru the CSVUsers array, looking for both $LastName and > $FirstName? Can Compare-Object help me here? > > I foresee problems, especially if the names don't match exactly, or I have > multiple John Does. But all I have is that CSV file. > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
