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


Powershell / quest commandlets script that will putput a list of all workstations in a particular domain and export to .csv file

Posted on 2011-10-13
Medium Priority
Last Modified: 2012-05-12
Powershell / quest commandlets script that will putput a list of all workstations (only, not servers)) in a particular domain and export to .csv file
Question by:mjm21
  • 2
LVL 13

Expert Comment

ID: 36963031
Get-QADComputer -ComputerRole member -SizeLimit 0 -OSName 'Windows XP*', 'Windows 2000 Professional', 'Windows 7*', 'Windows Vista*'


Accepted Solution

LindyS earned 2000 total points
ID: 36963548
Get-QADComputer -searchroot 'Domain.name' | Select Name,OSName,OSVersion,ParentContainer | Export-CSV filename.csv -notype

Once you have the export, filter out the OS's that you don't want in Excel.

Expert Comment

ID: 36963740
Additionaly, if you have more than 1000 machines, you need to include the -sizlimit 0 switch before the first pipe symbol.

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Here's a look at newsworthy articles and community happenings during the last month.
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

834 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