1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| Dim conteneur
Dim utilisateur,OU
Set WshShellObj = WScript.CreateObject("WScript.Shell")
Set WshProcessEnv = WshShellObj.Environment("Process")
codeRH=WshProcessEnv("USERNAME")
'wscript.echo "codeRH : "&codeRH
set objConnection = CreateObject("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")
objConnection.Provider = "ADsDSOObject"
objConnection.Open "Active Directory Provider"
Set objCOmmand.ActiveConnection = objConnection
objCommand.CommandText = _
"Select DistinguishedName from 'LDAP://OU=DRII,OU=Bureautique,OU=Comptes Individuels,OU=Utilisateurs,OU=MTP,DC=IC,DC=courrier,DC=intra,DC=toto,DC=fr' " _
& "Where objectClass='user' AND sAMAccountName='"&codeRH&"'"
'objCommand.commandText ="<LDAP://dcmic01/OU=DRII,OU=Bureautique,OU=Comptes Individuels,OU=Utilisateurs,OU=MTP,DC=IC,DC=courrier,DC=intra,DC=toto,DC=fr>;(&(objectClass=user)(sAMAccountName='coderh'));DistinguishedName;subTree"
Set objRecordSet = objCommand.Execute
objRecordSet.MoveFirst
Do Until objRecordSet.EOF
DNUser= objRecordSet.Fields(0).Value
objRecordSet.MoveNext
Loop
'set conteneur = GetObject("LDAP://CN=DELACHANCE Héléna,OU=DRII,OU=Bureautique,OU=Comptes Individuels,OU=Utilisateurs,OU=MTP,DC=IC,DC=courrier,DC=intra,DC=toto,DC=fr")
ChaineDeConnexion = "LDAP://"& DNUser
set conteneur = GetObject(ChaineDeConnexion )
userPN=conteneur.get("userPrincipalName")
'WScript.Echo "userPrincipalName: " & vbTab & userPN
PosArobase = Instr(UserPN, "@")
'Wscript.echo PosArobase
ChaineNomPrenom=Left(UserPN, PosArobase-1)
Wscript.echo ChaineNomPrenom |
Partager