Mandy_
asked on
Get AD User properties and write to excel cells
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
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
ASKER
sorry thats not excactly what i need. i want write back the data to defined excel cells
Sorry. Misunderstood your question.
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?
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thank it's working now. Which kind of atributes you can query?
It is standard query - any existing AD attribute can be used
http://technet.microsoft.com/en-us/library/cc732101(v=ws.10).aspx
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm