{"id":5501,"date":"2015-06-17T00:01:00","date_gmt":"2015-06-17T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2015\/06\/17\/powershell-and-the-active-directory-schema-part-2\/"},"modified":"2019-02-18T09:47:24","modified_gmt":"2019-02-18T16:47:24","slug":"powershell-and-the-active-directory-schema-part-2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/powershell-and-the-active-directory-schema-part-2\/","title":{"rendered":"PowerShell and the Active Directory Schema: Part 2"},"content":{"rendered":"

Summary<\/b>: Guest blogger, Andy Schneider, continues his discussion about extending the Active Directory schema.<\/span><\/p>\n

Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Andy Schneider<\/a>, for Part 2 of his series. If you missed yesterday's post, see PowerShell and the Active Directory Schema: Part 1<\/a>.<\/p>\n

Yesterday, we looked at what the Active Directory schema is and how to access details of the schema by using Windows PowerShell. In this post, we are going to look at how we can look at the schema, and also update the schema. If you didn’t get a chance to read Extending the Active Directory Schema<\/a> by Brian Desmond, I highly suggest you read through it to gain an understanding of the ramifications of schema extensions and how to properly plan for them.<\/p>\n

Yesterday, I left you with the following lines of code which would give us all kinds of information about the schema objects we have in Active Directory:<\/p>\n

$schemaPath = (Get-ADRootDSE).schemaNamingContext<\/p>\n

Get-ADObject -filter * -SearchBase $schemaPath -Properties * | where Name -like "user"<\/p>\n

\"Image<\/a><\/p>\n

The question now is, “Which ones do we care about if we want to add our own schema extensions to the user class?”<\/p>\n

The way I went about this was to start looking at how schema extensions are typically done. More often than not, extensions are implemented using the LDAP Data Interchange Format<\/a>, also known as LDIF. There is a tool in Windows called LDIFDE.exe that you can use to import and export data. LDIFDE.exe can also be used to add attributes and classes to the Active Directory schema.<\/p>\n

In addition to examining LDIF files, I also went through the manual process of using the schema management tools to see what kinds of input go into the GUI. Following is a screenshot of that menu.<\/p>\n

   Note<\/b> You have to register a DLL to be able to get the Schema Management MMC. You can do this with the
   command regsvr32 schmmgmt.dll<\/b>.<\/p>\n

\"Image<\/a><\/p>\n

By looking through a variety of LDIF file examples and the GUI tool, we can figure out what we need to supply when we create new attributes. Here is a short list:<\/p>\n\n\n\n\n\n\n\n\n\n
\n

Attribute<\/b><\/p>\n<\/td>\n

\n

Description<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Name<\/p>\n<\/td>\n

\n

Name of the attribute<\/p>\n<\/td>\n<\/tr>\n

\n

lDAPDisplayName<\/p>\n<\/td>\n

\n

LDAP display name<\/p>\n<\/td>\n<\/tr>\n

\n

attributeID<\/p>\n<\/td>\n

\n

Unique Object Identifier<\/a>, known as an OID<\/p>\n<\/td>\n<\/tr>\n

\n

oMSyntax<\/p>\n<\/td>\n

\n

Determines type of data stored in the attribute (int, string, bool). 
For reference, see Syntaxes<\/a>.<\/p>\n<\/td>\n<\/tr>\n

\n

isSingleValued<\/p>\n<\/td>\n

\n

True or False. Attribute may have more than one value
(for example, proxyAddresses)<\/p>\n<\/td>\n<\/tr>\n

\n

adminDescription<\/p>\n<\/td>\n

\n

Description of the attribute<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The one slightly tricky attribute that we need to worry about is attributeID<\/b>. This needs to be a unique OID. For production, you really should register for a Private Enterprise Number with IANA. You can do this here<\/a>.<\/p>\n

However, for development purposes, we can use the following code to generate an OID:<\/p>\n

Function New-AttributeID {<\/p>\n

    $Prefix="1.2.840.113556.1.8000.2554"<\/p>\n

    $GUID=[System.Guid]::NewGuid().ToString()<\/p>\n

    $Parts=@()<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(0,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(4,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(9,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(14,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(19,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(24,6),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(30,6),"AllowHexSpecifier")<\/p>\n

    $oid=[String]::Format("{0}.{1}.{2}.{3}.{4}.{5}.{6}.{7}",$prefix,$Parts[0],<\/p>\n

                 $Parts[1],$Parts[2],$Parts[3],$Parts[4],$Parts[5],$Parts[6])<\/p>\n

        $oid<\/p>\n

}<\/p>\n

\"Image<\/a><\/p>\n

For this demonstration, we are going to add a new attribute to the user class called asFavoriteColor<\/b>. I am using the “as” prefix simply to identify this attribute. You can use your company’s initials or some other way to distinguish your custom extensions from other attributes. To create a new attribute, we are going to use the New-ADObject<\/b> cmdlet.<\/p>\n

The path is going to be in the schemaNamingContext<\/b> container, which we already have. We have also seen that schema attribute objects are of the type attributeSchema<\/b>. New schema class objects are of the type classSchema<\/b>.<\/p>\n

The only thing that remains are some of these properties that are unique to schema objects. We will need to store these in a hash table and pass them in via the –OtherAttributes<\/b> parameter:<\/p>\n

$schemaPath = (Get-ADRootDSE).schemaNamingContext<\/p>\n

$oid = New-AttributeID<\/p>\n

$attributes = @{<\/p>\n

      lDAPDisplayName = 'asFavoriteColor';<\/p>\n

      attributeId = $oid;<\/p>\n

      oMSyntax = 20;<\/p>\n

      attributeSyntax = "2.5.5.4";<\/p>\n

      isSingleValued = $true;<\/p>\n

      adminDescription = 'favorite colors are really important';<\/p>\n

      searchflags = 1<\/p>\n

      }<\/p>\n

New-ADObject -Name asFavoriteColor -Type attributeSchema -Path $schemapath -OtherAttributes $attributes<\/p>\n

When we create that new object, we can see our new attribute!<\/p>\n

get-adobject -SearchBase $schemaPath -Filter 'name -eq "asFavoriteColor"'<\/p>\n

\"Image<\/a><\/p>\n

However, we aren’t quite done. We have an attribute, but it hasn’t been attached to the user class yet. To attach an attribute to an existing class, we have to update the class to include the attribute. This was not the easiest thing to figure out.<\/p>\n

After looking at a few LDIF files, I finally realized that there was a property on the schemaClass<\/b> objects called mayContain<\/b>. This is a list of all the attributes associated with a particular class. From here, we can get the user schema object and add the new attribute to its mayContain<\/b> property.<\/p>\n

$userSchema = get-adobject -SearchBase $schemapath -Filter 'name -eq "user"'<\/p>\n

$userSchema | Set-ADObject -Add @{mayContain = 'asFavoriteColor'} <\/p>\n

Now we can finally set and get the asFavoriteColor<\/b> property on a user object.<\/p>\n

\"Image<\/a><\/p>\n

We can wrap up all this in a nice function. I set this up so I can take data from the pipeline by property names, so I can easily import a bunch of attributes from a CSV file. I also added support for ShouldProcess<\/b> and set the ConfirmImpact<\/b> value to High. Here is my code:<\/p>\n

Function New-AttributeID {<\/p>\n

    $Prefix="1.2.840.113556.1.8000.2554"<\/p>\n

    $GUID=[System.Guid]::NewGuid().ToString()<\/p>\n

    $Parts=@()<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(0,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(4,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(9,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(14,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(19,4),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(24,6),"AllowHexSpecifier")<\/p>\n

    $Parts+=[UInt64]::Parse($guid.SubString(30,6),"AllowHexSpecifier")<\/p>\n

    $AttributeID=[String]::Format("{0}.{1}.{2}.{3}.{4}.{5}.{6}.{7}",$prefix,$Parts[0],<\/p>\n

                                    $Parts[1],$Parts[2],$Parts[3],$Parts[4],$Parts[5],$Parts[6])<\/p>\n

    $oid<\/p>\n

}<\/p>\n

Function Update-Schema {<\/p>\n

[CmdletBinding(SupportsShouldProcess,ConfirmImpact='High')]<\/p>\n

param(<\/p>\n

[Parameter(Mandatory,ValueFromPipelinebyPropertyName)]<\/p>\n

$Name,<\/p>\n

[Parameter(Mandatory,ValueFromPipelinebyPropertyName)]<\/p>\n

[Alias('DisplayName')]<\/p>\n

$LDAPDisplayName,<\/p>\n

[Parameter(Mandatory,ValueFromPipelinebyPropertyName)]<\/p>\n

[Alias('Description')]<\/p>\n

$AdminDescription,<\/p>\n

[Parameter(Mandatory,ValueFromPipelinebyPropertyName)]<\/p>\n

[Alias('SingleValued')]<\/p>\n

$IsSingleValued,<\/p>\n

[Parameter(ValueFromPipelinebyPropertyName)]<\/p>\n

[Alias('OID')]<\/p>\n

$AttributeID = (New-OID)<\/p>\n

)<\/p>\n

BEGIN {}<\/p>\n

PROCESS {<\/p>\n

  $schemaPath = (Get-ADRootDSE).schemaNamingContext      <\/p>\n

  $type = 'attributeSchema'<\/p>\n

  switch ($isSingleValued)<\/p>\n

  {<\/p>\n

   'True'  {$IsSingleValued = $true}<\/p>\n

   'False' {$IsSingleValued = $false}<\/p>\n

   default {$IsSingleValued = $true}<\/p>\n

  }<\/p>\n

  $attributes = @{<\/p>\n

      lDAPDisplayName = $Name;<\/p>\n

      attributeId = $AttributeID;<\/p>\n

      oMSyntax = 20;<\/p>\n

      attributeSyntax = "2.5.5.4";<\/p>\n

      isSingleValued = $IsSingleValued;<\/p>\n

      adminDescription = $AdminDescription;<\/p>\n

      searchflags = 1<\/p>\n

      }<\/p>\n

    $ConfirmationMessage = "$schemaPath. This cannot be undone"<\/p>\n

    $Caption = 'Updating Active Directory Schema' <\/p>\n

    if ($PSCmdlet.ShouldProcess($ConfirmationMessage,$Caption))<\/p>\n

    {<\/p>\n

      New-ADObject -Name $Name -Type $type -Path $schemapath -OtherAttributes $attributes<\/p>\n

      $userSchema = get-adobject -SearchBase $schemapath -Filter 'name -eq "user"'<\/p>\n

      $userSchema | Set-ADObject -Add @{mayContain = $Name}<\/p>\n

    }<\/p>\n

}<\/p>\n

END {}<\/p>\n

}<\/p>\n

You can download this code from GitHub: PowerShell to Udpate Active Directory Schema<\/a>.<\/p>\n

This purpose of this series and code is to show you the basics of how to use native Windows PowerShell to extend the Active Directory schema. I would like to reiterate that any schema modifications should be well thought out and planned for. There are many more attributes that can be used and that could be useful. You can use this code as a basic framework for updating the schema with your company’s requirements and standards.<\/p>\n

~Andy<\/p>\n

Thank you Andy. This is some awesome material.<\/p>\n

I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/b> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Guest blogger, Andy Schneider, continues his discussion about extending the Active Directory schema. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Andy Schneider, for Part 2 of his series. If you missed yesterday's post, see PowerShell and the Active Directory Schema: Part 1. Yesterday, we looked at what the Active Directory […]<\/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":[7,156,56,3,549,45],"class_list":["post-5501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-active-directory","tag-andy-schneider","tag-guest-blogger","tag-scripting-guy","tag-series","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Guest blogger, Andy Schneider, continues his discussion about extending the Active Directory schema. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Andy Schneider, for Part 2 of his series. If you missed yesterday's post, see PowerShell and the Active Directory Schema: Part 1. Yesterday, we looked at what the Active Directory […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/5501","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=5501"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/5501\/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=5501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=5501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=5501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}