Active Directory and CSV files

Here’s a new quick tip from Darin on AD exports and imports from within PowerGUI:

As usual, short and to the point.

Using CSV and text files in PowerGUI when managing AD is quite common. For example, I have seen people adding script node like:

Get-Content '\\server\share\users.txt' | Get-QADUser

If users.txt has a bunch of usernames (one per line) this outputs actual user accounts to the PowerGUI grid, which you can then manage with all the actions (disable, reset passwords, and so on.)

Alternatively, some customers are just using

Import-Csv

in a node and then define some actions to perform various activities based on the fields in the grid.

Also, although Darin did not show that, you can create your own export to CSV and use something like

Select Name, samAccountName | Export-Csv

to pick specific columns to be exported.

And there’s whole update from CSV scenario… Man, I could go on and on with these! :)

Tags: , , , , , ,

0 Responses to “Active Directory and CSV files”



  1. No Comments Yet

Leave a Reply




View Dmitry Sotnikov's profile on LinkedIn

Follow Dmitry Sotnikov at Twitter

My Recent Tweets

Archives

See you at:

Legal

The posts on this blog are provided “as is” with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer Quest Software or anyone else for that matter. All trademarks acknowledged.

© 2007 Dmitry Sotnikov

Pages

 

August 2009
M T W T F S S
« Jul   Sep »
 12
3456789
10111213141516
17181920212223
24252627282930
31