• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

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

Powershell / quest commandlets script that will putput a list of all workstations (only, not servers)) in a particular domain and export to .csv file
0
mjm21
Asked:
mjm21
  • 2
1 Solution
 
GovvyCommented:
Get-QADComputer -ComputerRole member -SizeLimit 0 -OSName 'Windows XP*', 'Windows 2000 Professional', 'Windows 7*', 'Windows Vista*'

0
 
LindySCommented:
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.
0
 
LindySCommented:
Additionaly, if you have more than 1000 machines, you need to include the -sizlimit 0 switch before the first pipe symbol.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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