Need some scripting help

spiceuser-icda7 · 2023-07-31T16:54:55.000Z

Hello everyone, I have been tasked with the following and struggle with scripting still.

Goal: Create a script that will take the contents from the “office” field in AD and apply them to first name / last name. The first name is always going to be “store” for this particular script. The lase name will be the store #. The goal is to have it universally the same naming convention.

Ex. Office field displays Store 32.

I am needing to have Store in the first name field and the store # in last name field. There are about 300 entries so I was hoping to be able to copy the first word in the office field to first name and the second one being the number to the last name field.

Neally · 2023-07-31T16:58:49.000Z

spiceuser-icda7:

I have been tasked with the following and struggle with scripting

Welcome,

that’s no problem, we’re happy to help, but not a script writing service.

What have you tried? where are you stuck? post the code you have tried and we’ll try to help from there.

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…

spiceuser-icda7 · 2023-07-31T17:17:04.000Z

get-aduser -searchbase “OU=Users,OU=HQ,DC=Contoso,DC=com” -FILTER * -office Description | foreach-object {set-ADUser -identity $_.DistinguishedName -title $_.FirstName}.

I’m terrible at writing scripts.

Rod-IT · 2023-07-31T17:18:28.000Z

As above, please use the post code option, </> and specify PowerShell in the drop down.

spiceuser-icda7 · 2023-07-31T17:21:45.000Z

I’m pretty sure I did. Let me check again

Neally · 2023-07-31T17:23:01.000Z

spiceuser-icda7:

get-aduser -searchbase “OU=Users,OU=HQ,DC=Contoso,DC=com” -FILTER * -office Description | foreach-object {set-ADUser -identity $_.DistinguishedName -title $_.FirstName}.

I’m terrible at writing scripts.

Ok , let talk about your code, where exactly are you stuck?

You select everyone ( -filter * ) in a specific OU ( -searchbase “OU=Users,OU=HQ,DC=Contoso,DC=com”) and pull the office property ( should be -properties office)
But then on the set, you are trying to set the title?

Neally · 2023-07-31T17:31:02.000Z

something like this is the theory (assuming your office attribute is literally just the store and the ID “Store 123”

$ADUsers= 
Get-aduser -Filter * -searchbase "OU=Users,OU=HQ,DC=Contoso,DC=com" -Properties office

foreach($userObject in $ADUsers){
    $store,$storeNumber = $userObject.office -split "\s"

    Set-ADUser $userObject -GivenName $store -Surname $storeNumber
}

bb236399-c0ef-4ca5-8875-b71f3f890f3f-2023-07-31_12-28-44.png This is literally just updating the First and GivenName, if you need Displayname, Name, etc there is more to do, but gives you the idea.

This is code from the internet, always TEST THE CODE THOUROUGHLY and DO NOT run it in PRODUCTION.
Run it against a single test user first and see what it does

spiceuser-icda7 · 2023-07-31T17:53:09.000Z

That’s my fault. I put in the wrong code there. Still learning.

spiceuser-icda7 · 2023-07-31T17:55:54.000Z

Thank You, Office field is just “store #”

Your code makes a lot of sense. I try to figure it out before asking. That really helps. I’ll try it on a non prod account.

spiceuser-icda7 · 2023-07-31T18:38:49.000Z

Can you recommend a book for idiots on scripting? I can do pen tests, vulnerability management, stand up and configure office 365, Defender, Intune etc but cant write a script.

randomdrake11 · 2023-07-31T18:43:23.000Z

Personally I’d recommend any number of youtube videos out there, that’s more or less how I started learning to script. This is the series that I started on, it definitely helped a lot . Easiest way to learn is to just repeat what you see until it makes sense!

Neally · 2023-07-31T18:45:17.000Z

spiceuser-icda7:

Can you recommend a book for idiots on scripting? I can do pen tests, vulnerability management, stand up and configure office 365, Defender, Intune etc but cant write a script.

Honestly, IMO the fastest way to learn it is to do it.

https://community.spiceworks.com/windows/articles/3088-how-do-i-learn-powershell

Powershell in a month of Lunches is the most common recommended way to get started.

Do you know any other languages? That might help as well to derive things.

I’d say PowerShell and Python are two essential scripting skills that really good to have ( I can’t python myself though lol)

jessevas · 2023-07-31T19:00:54.000Z

Don’t forget to mark best answer. Neally needs his spice!

spiceuser-icda7 · 2023-08-01T14:24:34.000Z

Last question, I’m sorry. Is there a way to have it prompt for what store account we want the info changed?

Neally · 2023-08-01T14:37:57.000Z

spiceuser-icda7:

Last question, I’m sorry. Is there a way to have it prompt for what store account we want the info changed?

Have you tried anything…?
e.g.

Get-aduser -Identity (read-host "enter stuff") -Properties office

spiceuser-icda7 · 2023-08-01T14:45:49.000Z

Got it to work. I figured it out. Thank You.