[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

EXCEL AD-QUERY FROM DISPLAYNAME (A1) to SAMACCOUNTNAME (B1)

Hi experts,

i need a VB-Code for an AD-query with should resolve the displayname in a1 to samaccountname in B1.

Thanks in advance
mandy_
0
Mandy_
Asked:
Mandy_
  • 2
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
here is an addin for you that query's AD

Complete instructions and functions/vba are @ http://bit.ly/1rhe60k
0
 
Mandy_Author Commented:
Hello

Thank you for this, But for me it's not working from displayname to samaccountname
e.g. Jones, Mike to alias G123456

Thanks in advance for any ideas
0
 
Mandy_Author Commented:
Dear colleagues,

attached you can  find an example
adquery.xls
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now