Convert LDIF group file to CSV

-

hi!

here's ldif file. it's file listing group , theres members:

dn: dn1
ufn: ufn1
member: member1
member: member2
member: member3
cn: cn1

dn: dn2
ufn: ufn2
member: member1
member: member2
cn: cn2

dn: dn3
ufn: ufn3
member: member1
member: member2
member: member3
member: member4
cn: 

i need convert file csv file ";" separated:

"dn";"ufn";"member";"cn"
"dn1";"ufn1";"member1";"cn1"
"dn1";"ufn1";"member2";"cn1"
"dn1";"ufn1";"member3";"cn1"
"dn2";"ufn2";"member1";"cn2"
"dn2";"ufn2";"member2";"cn2"
"dn3";"ufn3";"member1";""
"dn3";"ufn3";"member2";""
"dn3";"ufn3";"member3";""
"dn3";"ufn3";"member4";""

i can catch dn, ufn , cn .split problem catch multiple member.

thx help



$lines=@' dn: dn1 ufn: ufn1 member: member1 member: member2 member: member3 cn: cn1  dn: dn2 ufn: ufn2 member: member1 member: member2 cn: cn2  dn: dn3 ufn: ufn3 member: member1 member: member2 member: member3 member: member4 cn: cn3 '@ -split "`n"  $lines|     foreach-object{               $name,$value=$_ -split ':'         switch ($name){              'dn' { 			if($cn){                    		$members|%{                              		$p=@{dn=$dn;member=$_;cn=$cn}                              		new-object psobject -property $p 								} 				$cn=$null                    		$members=@()             		}                    	$dn=$value                   }              'member' {$members+=$value}              'cn'          {$cn=$value}         }     }

¯\_(ツ)_/¯








Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Azure MFA with Azure AD and RDS

-
i have setup following lab in azure , need help. a server (domain controller) , remote desktop services. and server multi factor authentication server. i have setup following one http://www.rdsgurus.com/uncategorized/step-by-step-using-windows-server-2012-r2-rd-gateway-with-azure-multifactor-authentication/ and when im connecting got following error. the user "domain\username", on client computer "xxx.xxx.xxx.xxx", did not meet connection authorization policy requirements , therefore not authorized access rd gateway server. authentication method used was: "ntlm" , connection protocol used: "rpc-http". following error occurred: "23003". also on security log i've got following authentication details: connection request policy name: ts gateway authorization policy network policy name: - authentication provider: radius proxy authentication server: test.test.local authenticati...
Read more

WIMMount (HSM) causing cluster storage to go redirected (2012r2 DC)

-
looking options resolve error , prevent in future. thanks help. hardware: 2 node dell hv cluster running2012r2 dc 8 nic/ea in multiplex mode 4x hyper-v 4x hosts storage: 2x synology nas, accessed through iscsi hosts , cluster relevant logs: log name:      microsoft-windows-failoverclustering/diagnostic source:        microsoft-windows-failoverclustering date:          event id:      2050 task category: none level:         warning keywords:       user:          system computer:      l description: [dcm] filter wimmount found @ unsafe altitude 180700 log name:      system source:        microsoft-windows-failoverclustering ...
Read more

Failed to delete the test record dcdiag-test-record in zone test.com

-
ps c:\users\administrator.test> dcdiag /test:dns directory server diagnosis performing initial setup:    trying find home server...    home server = dc02    * identified ad forest.    done gathering initial info. doing initial required tests    testing server: default-first-site-name\dc02       starting test: connectivity          ......................... dc02 passed test connectivity doing primary tests    testing server: default-first-site-name\dc02       starting test: dns          dns tests running , not hung. please wait few minutes...          ......................... dc02 passed test dns    running partition tests on : forestdnszones    running partition tests on : domaindnszones    running partition tests on : schema ...
Read more