Link to home
Create AccountLog in
Avatar of Mandy_
Mandy_

asked on

Get AD User properties and write to excel cells

User generated image
hi folks,

i like to read the user properties result from AD to excel (sourceUser from Cell B18-B30)
and target User from B33-B38


Get-ADUser Z777777 -Filter * -Property * | Select-Object Name,DistinguishedName,DisplayName,City,MobilePhone,UserPrincipalName,whenCreated,whenChanged					

Open in new window


Source User Properties
Name
DisplayName
City
MobilePhone
whenCreated
whenChanged
streetadress
department
company
officephone
office
Database of the User (e.g. DB001)
Server (Server on which the Database above is mounted)

Target User Properties
Phone Number
Fax Number
Department
Company
Office
Adress (City, Street, Country)


appreciate for your help
Avatar of yo_bee
yo_bee
Flag of United States of America image

You can use csvde.exe /f  this will export user attribute to csv file that can be viewed in and saved as an excel file.  

http://technet.microsoft.com/en-us/library/cc732101(v=ws.10).aspx
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm
Avatar of Mandy_
Mandy_

ASKER

sorry thats not excactly what i need. i want write back the data to defined excel cells
Sorry. Misunderstood your question.
Avatar of Mandy_

ASKER

queryAD

Thats really cool. I'm only getting in excel2013 #value as result of the query.
I tried as modul or addin its same result

do you have an idea?
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Mandy_

ASKER

thank it's working now.  Which kind of atributes you can query?
It is standard query - any existing AD attribute can be used