Here’s Sean…<\/p>\n
In yesterday’s episode, we encountered an Administrator who was near tears due to the time constraints of a massive project and the bad timing of it occurring during the holidays. Magically from a spark of ozone, our good friend Dr. Scripto appeared to aid him. Today, we continue as he gains some further insight into Windows PowerShell and the power of automation.<\/p>\n
<\/p>\n
And so we continue,<\/p>\n
Much deeper to the night,<\/p>\n
The Admin who never scripted,<\/p>\n
And suddenly took fright.<\/p>\n
<\/p>\n
A project that would take<\/p>\n
All of the hours<\/p>\n
Of holiday time,<\/p>\n
And also no showers.<\/p>\n
<\/p>\n
But Dr. Scripto<\/p>\n
Appeared in time,<\/p>\n
In a sparking of ozone,<\/p>\n
And badly done rhyme.<\/p>\n
<\/p>\n
With PowerShell, they made<\/p>\n
Users (so many),<\/p>\n
And did it barely<\/p>\n
In the cost of a penny.<\/p>\n
<\/p>\n
But now, an email stirred<\/p>\n
To our good Admin friend,<\/p>\n
That made him just panic,<\/p>\n
Nearly to the end.<\/p>\n
<\/p>\n
“It’s from the Boss.<\/p>\n
He insists that I quickly<\/p>\n
Update the field,<\/p>\n
With the raw Info account provided to me!”<\/p>\n
<\/p>\n
Oh, the panic in his eyes,<\/p>\n
and gasps of pure dread!<\/p>\n
To manually update over 500 staff…<\/p>\n
Fear crept to his head!<\/p>\n
<\/p>\n
But the good Doctor,<\/p>\n
With a twinkle in his eye,<\/p>\n
Smiled and said,<\/p>\n
“We can solve this without try.”<\/p>\n
<\/p>\n
“Let us take the first script,<\/p>\n
The one we used to make<\/p>\n
The staff of 500,<\/p>\n
We’ll change it easy as cake.”<\/p>\n
<\/p>\n
So he copied it out,<\/p>\n
And pasted it back,<\/p>\n
The previous script,<\/p>\n
His small coding snack:<\/p>\n
<\/p>\n
$Users=IMPORT-CSV Users.csv<\/p>\n
Foreach($User in $Users)<\/p>\n
{<\/p>\n
$First=$User.Firstname<\/p>\n
$Last=$User.Lastname<\/p>\n
$Acct=$User.UserAccount<\/p>\n
$Addr=$User.Address<\/p>\n
$City=$User.City<\/p>\n
$State=$User.St<\/p>\n
$TempPassword=(CONVERTTO-SecureString –asplaintext –force –string ‘TempPassword1’)<\/p>\n
$DomainUPN=$Acct+’@Contoso.local’<\/p>\n
NEW-ADUSER $Acct –GivenName $First –Surname $Last –StreetAddress $Addr –City $City –State $State –UserPrincipalName $DomainUPN –AccountPassword $TempPassword<\/p>\n
}<\/p>\n
<\/p>\n
“One more cmdlet<\/p>\n
For this task we’ll need,<\/p>\n
A simple cmdlet<\/p>\n
To aid in our deed.<\/p>\n
<\/p>\n
We do not need UPN<\/p>\n
Or a password this time,<\/p>\n
So we’ll comment out<\/p>\n
All of those lines:”<\/p>\n
<\/p>\n
#$TempPassword=(CONVERTTO-SecureString –asplaintext –force –string ‘TempPassword1’)<\/p>\n
#$DomainUPN=$Acct+’@Contoso.local’<\/p>\n
<\/p>\n
Our Admin blinked,<\/p>\n
And looked at the screen,<\/p>\n
Using the hash mark<\/p>\n
Would skip like a sheen.<\/p>\n
<\/p>\n
“We must now take info<\/p>\n
Provided us from file<\/p>\n
USER.CSV and<\/p>\n
Combine to a pile:”<\/p>\n
<\/p>\n
$First=$User.Firstname<\/p>\n
$Last=$User.Lastname<\/p>\n
$Acct=$User.UserAccount<\/p>\n
$Addr=$User.Address<\/p>\n
$City=$User.City<\/p>\n
$State=$User.St<\/p>\n
$info=$First+”,”+$Last+”,”+$Acct+”,”+$Addr+”,”+$City+”,”+$State<\/p>\n
<\/p>\n
Our good friend, Scripto,<\/p>\n
Did then type to the screen,<\/p>\n
The cmdlet to use<\/p>\n
To aid in their mean:<\/p>\n
<\/p>\n
SET-ADUSER $Acct –replace @{info=$info}<\/p>\n
<\/p>\n
“Ooops! I almost forgot<\/p>\n
To do one more thing!<\/p>\n
Comment out New-ADUser<\/b>,<\/p>\n
And our script, it can sing!”<\/p>\n
<\/p>\n
And so he looked at<\/p>\n
The script he would run,<\/p>\n
And saved it as the new<\/p>\n
UPDATE.PS1:<\/p>\n
<\/p>\n
$Users=IMPORT-CSV Users.csv<\/p>\n
Foreach($User in $Users)<\/p>\n
{<\/p>\n
$First=$User.Firstname<\/p>\n
$Last=$User.Lastname<\/p>\n
$Acct=$User.UserAccount<\/p>\n
$Addr=$User.Address<\/p>\n
$City=$User.City<\/p>\n
$State=$User.St<\/p>\n
#$TempPassword=(CONVERTTO-SecureString –asplaintext –force –string ‘TempPassword1’)<\/p>\n
#$DomainUPN=$Acct+’@Contoso.local’<\/p>\n
#NEW-ADUSER $Acct –GivenName $First –Surname $Last –StreetAddress $Addr –City $City –State $State –UserPrincipalName $DomainUPN –AccountPassword $TempPassword<\/p>\n
$info=$First+”,”+$Last+”,”+$Acct+”,”+$Addr+”,”+$City+”,”+$State<\/p>\n
SET-ADUSER $Acct –replace @{info=$info}<\/p>\n
}<\/p>\n
<\/p>\n
Running the script<\/p>\n
And checking AD<\/p>\n
Showed their User;<\/p>\n
They had done it correctly!<\/p>\n
<\/p>\n
Dr. Scripto looked up<\/p>\n At his friend in the chair,<\/p>\n “Amazing what you can do<\/p>\n With some PowerShell flair!”<\/p>\n <\/p>\n The strain seemed to<\/p>\n Pass from his face,<\/p>\n Perhaps he might win<\/p>\n In this mad deployment race?<\/p>\n <\/p>\n Pop in tomorrow as we watch further. Will our good Admin friend manage to find some way to complete all of his work in a reasonable time? Will he be home for the holidays? Only further reading will tell!<\/p>\n ~Sean<\/p>\n I invite you to follow the Scripting Guys on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n Sean Kearney<\/strong>, Summary: Dr. Scripto helps an Admin learn how to easily modify custom attributes in Active Directory. Microsoft Scripting Guy, Ed Wilson, here. If you missed it yesterday, see Sean’s latest video: Just Script It! Also be sure to read yesterday’s post before you start on today’s: ‘Twas the Night of Before Scripting: Part 1. Here’s […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[56,154,45],"class_list":["post-2371","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-guest-blogger","tag-sean-kearney","tag-windows-powershell"],"acf":[],"blog_post_summary":" Summary: Dr. Scripto helps an Admin learn how to easily modify custom attributes in Active Directory. Microsoft Scripting Guy, Ed Wilson, here. If you missed it yesterday, see Sean’s latest video: Just Script It! Also be sure to read yesterday’s post before you start on today’s: ‘Twas the Night of Before Scripting: Part 1. Here’s […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/2371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=2371"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/2371\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=2371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=2371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=2371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"](\"https:\/\/msdnshared.blob.core.windows.net\/media\/TNBlogsFS\/prod.evol.blogs.technet.com\/CommunityServer.Blogs.Components.WeblogFiles\/00\/00\/00\/76\/18\/Capture%201.PNG\")
<\/a><\/p>\n
Honorary Scripting Guy and Windows PowerShell MVP <\/p>\n","protected":false},"excerpt":{"rendered":"