script to extract info out of AD users and create folders with it

Reply

Carpe_Diem Posted: 05-02-2012 10:00 AM

rated by 0 users

I am trying to create a script which will:

Create a folder structure on a network drive using each user name (First last and middle initial if exist and Employee ID ) pulling information out of existing AD Users

Within each folder it should create 4 subfolders ( all the same)

So as example: by gathering user information from AD the folder should look like this

USERS

---------- Meyers  Tim J 4578744  

------------------------folder one

------------------------folder two

------------------------folder three

------------------------folder four

 ---------- Kruger Paul S 457489  

------------------------folder one

------------------------folder two

------------------------folder three

------------------------folder four

Still a newbie to PS 

Thank you all for looking at this

Reply

Felipe replied on 05-02-2012 7:12 PM

rated by 0 users

I haven't tested it but this should do it:

$dom = [System.DirectoryServices.ActiveDirectory.Domain]::GetCurrentDomain()
$root = $dom.GetDirectoryEntry()
$search = [System.DirectoryServices.DirectorySearcher]$root
$search.Filter = "(objectCategory=User)"
$result = $search.FindAll()

foreach($user in $result){

$givenname = $user.properties.givenname

if($givenname.properties.displayname[0].split(" ").count -eq 2)
{$givenname = $givenname.properties.displayname[0].split(" ")[0] + " " + $givenname.properties.displayname[0].split(" ")[1][0]}

$surname = $user.properties.sn
$employeeID = $user.properties.employeeno
$folder = $givenname + " " + $surname + " " + $employeeID

New-Item -ItemType Directory -Path \\server\$folder
New-Item -ItemType Directory -Path \\server\$folder\folder1
New-Item -ItemType Directory -Path \\server\$folder\folder2
New-Item -ItemType Directory -Path \\server\$folder\folder3
New-Item -ItemType Directory -Path \\server\$folder\folder4
}

Replace the -Path with your own.

Reply

Carpe_Diem replied on 05-02-2012 9:28 PM

rated by 0 users

I try that in the morning and let you know

Thank you so much

Carpe Diem

Reply

Carpe_Diem replied on 05-07-2012 1:31 PM

rated by 0 users

Here is what I tried

$dom = [System.DirectoryServices.ActiveDirectory.Domain]::GetCurrentDomain()

$root = $dom.GetDirectoryEntry()$search = [System.DirectoryServices.DirectorySearcher]$root

$search.Filter = "(objectCategory=User)"

$result = $search.FindAll()

foreach($user in $result){

$givenname = $user.properties.givenname

if($givenname.properties.displayname[0].split(" ").count -eq 2)

{$givenname = $givenname.properties.displayname[0].split(" ")[0] + " " + $givenname.properties.displayname[0].split(" ")[1][0]}

$surname = $user.properties.sn

$employeeID = $user.properties.employeeno

$folder = $surname + " " + $givenname + " " + $employeeID

# replace excess whitespace

$folder -replace "\s{2,}", " "

New-Item -ItemType Directory -Path C:\test\$folder

New-Item -ItemType Directory -Path C:\test\$folder\folder1

New-Item -ItemType Directory -Path C:\test\$folder\folder2

New-Item -ItemType Directory -Path C:\test\$folder\folder3

New-Item -ItemType Directory -Path C:\test\$folder\folder4

}

I get

Directory: C:\test

Mode LastWriteTime Length Name

---- ------------- ------ ----

d---- 5/7/2012 1:12 PM Test User

Directory: C:\test\Test User

Mode LastWriteTime Length Name

---- ------------- ------ ----

d---- 5/7/2012 1:12 PM folder1

d---- 5/7/2012 1:12 PM folder2

d---- 5/7/2012 1:12 PM folder3

d---- 5/7/2012 1:12 PM folder4

Cannot index into a null array.

At line:11 char:4

+ if($givenname.properties.displayname[0].split(" ").count -eq 2)

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidOperation: (:) [], RuntimeException

+ FullyQualifiedErrorId : NullArray

So it does work partially

It creates a folder with each users Last and first name (leaves all the white spaces in place,

No middle initials and no employee ID at the end)

Reply

Felipe replied on 05-07-2012 7:39 PM

rated by 0 users

I know what's wrong, but I don't know why it's not displaying the employee ID.. Perhaps the property is empty.

$dom = [System.DirectoryServices.ActiveDirectory.Domain]::GetCurrentDomain()
$root = $dom.GetDirectoryEntry()
$search = [System.DirectoryServices.DirectorySearcher]$root
$search.Filter = "(objectCategory=User)"
$result = $search.FindAll()

foreach($user in $result){

$givenname = $user.properties.givenname

if($user.properties.displayname[0].split(" ").count -eq 2)
{$givenname = $user.properties.displayname[0].split(" ")[0] + " " + $user.properties.displayname[0].split(" ")[1][0]}

$surname = $user.properties.sn
$employeeID = $user.properties.employeeno
$folder = $givenname + " " + $surname + " " + $employeeID

New-Item -ItemType Directory -Path \\server\$folder
New-Item -ItemType Directory -Path \\server\$folder\folder1
New-Item -ItemType Directory -Path \\server\$folder\folder2
New-Item -ItemType Directory -Path \\server\$folder\folder3
New-Item -ItemType Directory -Path \\server\$folder\folder4
}

Reply

Carpe_Diem replied on 05-07-2012 9:22 PM

rated by 0 users

the Employee ID is populated

I verified

 let me try this again in the morning

Reply

Carpe_Diem replied on 05-07-2012 9:43 PM

rated by 0 users

if I run a script against its properties  it shows , so it is populated

EmployeeID : 1458341541*   made up

Reply

Felipe replied on 05-08-2012 1:08 AM

rated by 0 users

Try to replace:

$employeeID = $user.properties.employeeno

with

$employeeID = $user.properties.employeenumber

or

$employeeID = $user.properties.employeeid