Powershell: Parse AD DistinguishedName - Revision history

Rabbi Bob at 13:12, 20 April 2019

2019-04-20T13:12:54Z

← Older revision		Revision as of 13:12, 20 April 2019
Line 72:		Line 72:

	[[Category:Powershell]]		[[Category:Powershell]]
			[[Category:Weblog-2019-04]]

Rabbi Bob: /* Code */

2019-04-18T14:28:23Z

Code

← Older revision		Revision as of 14:28, 18 April 2019
Line 9:		Line 9:
	=Code=		=Code=
	<pre>		<pre>


	########################################################################################		########################################################################################
	# User Variables		# User Variables
	########################################################################################		########################################################################################
	$DN_ARRAY_FLIP=1; #Set to 1 to flip $DN_ARRAY before parsing		$DN_ARRAY_FLIP=1; #Set to 1 to flip $DN_ARRAY before parsing
			$AD_distinguishedName = 'CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com'
			########################################################################################
			# System Variables
			$DN_ARRAY=@()
			$DN_Counter=0
	########################################################################################		########################################################################################

	~~$AD_distinguishedName = 'CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com'~~
	write-host $AD_distinguishedName		write-host $AD_distinguishedName
	~~$DN_array=@()~~

			## Split $AD_distinguishedName into $DN_ARRAY ##########################################
	$AD_distinguishedName \| Foreach{		$AD_distinguishedName \| Foreach{
	$~~DN_array~~=$_.split(",")		$DN_ARRAY=$_.split(",")
	}		}

	~~$DN_Counter=0~~		write-host "Size of Array:" $DN_ARRAY.Length "Flip Bit: $DN_ARRAY_FLIP"
	write-host "Size of Array:" $~~DN_array~~.Length "Flip Bit: $DN_ARRAY_FLIP"

	########################################################################################		########################################################################################
Line 32:		Line 32:
	########################################################################################		########################################################################################
	if ($DN_ARRAY_FLIP -eq 1){		if ($DN_ARRAY_FLIP -eq 1){
	[array]::Reverse($~~DN_array~~)		[array]::Reverse($DN_ARRAY)
	#Flipping the Array (for report from a heirarchy perspective)		#Flipping the Array (for report from a heirarchy perspective)
	}		}

	foreach($~~DN_array_value~~ in $~~DN_array~~)		########################################################################################
	{		# Run through $DN_ARRAY and match elements
	$~~DN_Counter~~++		########################################################################################
			foreach($DN_ARRAY_VALUE in $DN_ARRAY)
			{
			$DN_COUNTER++

	if ($~~DN_array_value~~ -match '(CN=)(.*)') {		if ($DN_ARRAY_VALUE -match '(CN=)(.*)') {
	write-host "Matched CN at Position" $~~DN_Counter~~":" $Matches[2] }		write-host "Matched CN at Position" $DN_COUNTER":" $Matches[2] }
	elseif ($~~DN_array_value~~ -match '(DC=)(.*)') {		elseif ($DN_ARRAY_VALUE -match '(DC=)(.*)') {
	write-host "Matched DC at Position" $~~DN_Counter~~":" $Matches[2] }		write-host "Matched DC at Position" $DN_COUNTER":" $Matches[2] }
	elseif ($~~DN_array_value~~ -match '(OU=)(.*)') {		elseif ($DN_ARRAY_VALUE -match '(OU=)(.*)') {
	write-host "Matched OU at Position" $~~DN_Counter~~":" $Matches[2]}		write-host "Matched OU at Position" $DN_COUNTER":" $Matches[2]}
	else {		else {
	write-host "Unmatched Item: $~~DN_array_value~~ "		write-host "Unmatched Item: $DN_ARRAY_VALUE "
	}		}

	}


			}
	</pre>		</pre>

Rabbi Bob: /* Purpose */

2019-04-18T14:21:41Z

Purpose

← Older revision		Revision as of 14:21, 18 April 2019
Line 1:		Line 1:
	=Purpose=		=Purpose=
	Using Powershell, break down the elements of the AD DistinguisedName value return. Ideally, use this has a launching point to handle CN, OU, DC, etc values from the resulting array.		Using Powershell, break down the elements of the AD DistinguisedName value return. Ideally, use this has a launching point to handle CN, OU, DC, etc values from the resulting array.

			Script will capture out the LDAP elements and allow for flipping the array (good for hierarchical output). The script can be used from this stage to then do more other things with the LDAP elements as needed.

	=Background=		=Background=

Rabbi Bob: /* Output */

2019-04-18T14:19:51Z

Output

← Older revision		Revision as of 14:19, 18 April 2019
Line 56:		Line 56:
	<pre>		<pre>
	CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com		CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com
	Size of Array: 7		Size of Array: 7 Flip Bit: 1
	~~Position 0 CN=Some B. User~~		Matched DC at Position 1: com
	Position 1 ~~OU=Accounting~~		Matched DC at Position 2: Rabbibob
	Position 2 OU~~=Part Time~~		Matched OU at Position 3: Users
	Position 3 OU=Staff		Matched OU at Position 4: Staff
	~~Position 4~~ OU~~=Users~~		Matched OU at Position 5: Part Time
	Position 5 ~~DC=Rabbibob~~		Matched OU at Position 6: Accounting
	Position 6 ~~DC=com~~		Matched CN at Position 7: Some B. User
	</pre>		</pre>

Rabbi Bob: /* Code */

2019-04-18T14:19:22Z

Code

@@ Line 7: / Line 7: @@
 =Code=
 <pre>
 $AD_distinguishedName = 'CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com'
 write-host $AD_distinguishedName
@@ Line 16: / Line 24: @@
 $DN_Counter=0
-write-host "Size of Array:" $DN_array.Length
+write-host "Size of Array:" $DN_array.Length "Flip Bit: $DN_ARRAY_FLIP"
-foreach($DN_array_value in $DN_array)
+    foreach($DN_array_value in $DN_array)
+{
      $DN_Counter++
+}
 </pre>

Rabbi Bob: Created page with "=Purpose= Using Powershell, break down the elements of the AD DistinguisedName value return. Ideally, use this has a launching point to handle CN, OU, DC, etc values from the..."

2019-04-18T13:29:56Z

Created page with "=Purpose= Using Powershell, break down the elements of the AD DistinguisedName value return. Ideally, use this has a launching point to handle CN, OU, DC, etc values from the..."

New page

=Purpose=
Using Powershell, break down the elements of the AD DistinguisedName value return. Ideally, use this has a launching point to handle CN, OU, DC, etc values from the resulting array.

=Background=
At first I wanted to do this via regex however at my level of knowledge it seemed to be a higher hurdle to break down the variable length input DN string. Luckily I realized that it's a comma separated value and it is nicely split by commas.

=Code=
<pre>
$AD_distinguishedName = 'CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com'
write-host $AD_distinguishedName
$DN_array=@()

$AD_distinguishedName | Foreach{
$DN_array=$_.split(",")
}

$DN_Counter=0
write-host "Size of Array:" $DN_array.Length

foreach($DN_array_value in $DN_array)
{
write-host "Position $DN_Counter" $DN_array_value
$DN_Counter++
}
</pre>

=Output=
<pre>
CN=Some B. User,OU=Accounting,OU=Part Time,OU=Staff,OU=Users,DC=Rabbibob,DC=com
Size of Array: 7
Position 0 CN=Some B. User
Position 1 OU=Accounting
Position 2 OU=Part Time
Position 3 OU=Staff
Position 4 OU=Users
Position 5 DC=Rabbibob
Position 6 DC=com
</pre>

[[Category:Powershell]]