Solved

Getting a script

Posted on 2015-02-10
5
46 Views
Last Modified: 2015-03-05
hi,

I am looking for a script to produce a report in csv format that shows first name, surname, display name, UPN and user logon name from a windows 2003 active directory domain server. Any help would be appreciated.
0
Comment
Question by:gmollineau
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 40601706
Do you have powershell installed on this domain controller?

See below link for Powershell cmdlets against  2003 domain controllers.
http://blogs.technet.com/b/ashleymcglone/archive/2011/03/17/step-by-step-how-to-use-active-directory-powershell-cmdlets-against-2003-domain-controllers.aspx

Will.
0
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 40601707
Install Quest PowerGui and then run the following command from PowerGui Script Editor (that is if you do not have any Win2K8 DC/AD Web Services running):

Get-QADUser | ft givenname, sn, dn, samaccountname -AutoSize | out-file c:\directory\filename.csv
0
 

Author Comment

by:gmollineau
ID: 40603167
Hi,

I installed the Quest PowerGui, however how do i do the Get-QADUser?
0
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 40603231
You need to have powershell installed on the server for this to work. PowerGUI runs on top of powershell, which is why it is not working as expected.

Will.
0
 
LVL 25

Accepted Solution

by:
Mohammed Khawaja earned 500 total points
ID: 40603289
You do not need to install PowerGUI on the server, you could just install it on a workstation which has PowerShell.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Moving SQl Server SBS 2003 to SQL Server 2014 27 154
RAID / SATA Drivers for Intel Server Board SE7525GP2 and SE7320SP2 4 132
DHCP server 6 67
need help with active directory 4 78
The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question