I need a script for AD

sanchezescobar3 · 2018-03-15T15:35:39.000Z

Hi everyone. in my organization we have over and estimated 2000 users or more. We just found out that some accounts have been created with same first name and last name for example :

First name : Joy

Last Name: Joy

I need to find a script that can help me to find the accounts that were created with the same first and last name is this possible or whats the best way to go by fixing this issue thank you in advance.

Neally · 2018-03-15T15:39:12.000Z

What have you tried so far?

See if you find something here:

https://community.spiceworks.com/scripts?source=navbar-footer

Or powershell…

Neally · 2018-03-15T15:47:48.000Z

I can’t think of a smart filter but this might work

Import-Module ActiveDirectory
Get-ADUser -Filter * |
where {$_.givenname -eq $_.surname} |
select name, samaccountname |
export-csv "c:\list.csv" -NoTypeInformation

sanchezescobar3 · 2018-03-15T17:13:26.000Z

That worked thanks I have been working on a script for this for last 5 hours

dancrane · 2018-03-15T17:40:24.000Z

Don’t forget to award a best answer if your problem has been resolved!

BA.jpg800×230 13.7 KB

sanchezescobar3 · 2018-04-23T18:06:42.000Z

so this worked for me before but I dont know what I am doing wrong now but I keep getting this error

export-csv : Could not find a part of the path ‘C:\list.csv’.
At line:5 char:1

export-csv “c:\list.csv\username” -NoTypeInformation
CategoryInfo : OpenError: ( [Export-Csv], DirectoryNotFoundException
FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ExportCsvCommand

Neally · 2018-04-23T18:12:42.000Z

The path does not seem right:

export-csv "c:\list.csv\username" -NoTypeInformation

it should be possibly like so?

It’s C:\folder\file.csv

export-csv "c:\username.csv" -NoTypeInformation

Neally · 2018-04-23T18:17:04.000Z

sanchezescobar3:

so this worked for me before but I dont know what I am doing wrong now but I keep getting this error

export-csv : Could not find a part of the path ‘C:\list.csv’.
At line:5 char:1
export-csv “c:\list.csv\username” -NoTypeInformation
CategoryInfo : OpenError: ( [Export-Csv], DirectoryNotFoundException

FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ExportCsvCommand

Also it would help if you post the code you run (sanitized)

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…