Posts

Showing posts with the label Active Directory

Export Domain Users to CSV with PowerShell

Image
If you would like to create a list of all domain users in excel with a powershell script you are in luck. Quest software has created some pretty awesome tools to manage Microsoft Active Directory. Here's how to do it: 1.   You'll need to install the Quest ActiveRoles management shell v. 1.4 or later, located here:  http://www.quest.com/powershell/activeroles-server.aspx 2. Create a PowerShell file with the following script. Basically, just copy this text into a text file and rename the extension to .ps1. #This script requires Quest ActiveRoles management shell v.1.4 or later and Powershell to be installed. http://www.quest.com/powershell/activeroles-server.aspx #The script may be run on any machine that is bound to the domain and actively connected. You do not have to be a domain administrator. #Two files will be created. One CSV with results and one TXT log file. $strTimestamp =  [string](Get-Date -format "yyyy-MM-dd_hh-mm") start-transcript DomainScript...

Export Domain Admins to CSV with Powershell

It would be nice to be able to run a PowerShell script to query certain domain groups in Microsoft Active Directory, and write them to .CSV files for easy review in excel. Here's one way to do it: 1. You'll need to install the Quest ActiveRoles management shell v. 1.4 or later, located here:  http://www.quest.com/powershell/activeroles-server.aspx 2. Create a text file with .ps1 extension, and the following text. You can review the comments in the script to see what each part does, or just google the commands you don't know. Quest has some documentation last time I checked. #the AD groups that will be queried. These are groups that are considered domain admins $aGroups = @("Administrators", "Domain Admins", "Server Operators", "Enterprise Admins", "Account Operators", "Backup Operators", "Group Policy Creator Owners", "Schema Admins",  "Domain Controllers") #where the resu...

Active Directory Users and Computers and Group Policy Management

I keep forgetting where to get the tool to install these two programs: Active Directory Users and Computers  Group Policy Manageme nt They are both in the same package, but the package is different depending on what version of windows you have. It used to be called the Administration Tools Pack , but now it is called the Remote Server Administration Tools . It throws me off every time I try to search for it. Hopefully this will save someone a few minutes of searching. Links are below. Windows XP or Server 2003 Windows Server 2003 Administration Tools Pack (adminpak.exe or just adminpak) http://www.microsoft.com/downloadS/details.aspx?FamilyID=c16ae515-c8f4-47ef-a1e4-a8dcbacff8e3&displaylang=en Vista x86 Microsoft Remote Server Administration Tools for Windows Vista http://www.microsoft.com/downloads/details.aspx?FamilyId=9FF6E897-23CE-4A36-B7FC-D52065DE9960&displaylang=en Vista x64 Microsoft Remote Server Administration Tools for Windows Vista for x64-based ...