home recent topics recent posts search faq
Home » Scripting » Select AD User & Attributes to Output CSV Messages in this topic - RSS
|
1/12/2010 10:40:26 AM
darefugee
darefugee
Posts 2 		I would like to select Active Directory Users and some of their attributes to an output CSV based on their appearance on an input CSV.

Someone must have already done this, can anyone please share what they know? Thanks.
edited by darefugee on 1/12/2010
1/14/2010 12:36:09 PM
admin
admin
Posts 331 		Hi,

You might be able to get the information you want using Bulk AD Users. You can use the "Get users from list" method - this expects a list of users, 1 per line (If you open the CSV file in excel, you should be able to copy/paste from the column). Add the attrbutes you want to export via the "Grid\Properties To Load" dialog if they don't already exist. Click the "Export to CSV" button to export the data to CSV.

Another option is to use this script to export details for all users to CSV:

http://www.wisesoft.co.uk/scripts/vbscript_extract_user_data_to_csv.aspx

You should then be able to filter the data you are interested in using a lookup in Excel. It might actually be more efficient to return the data in this way, depending on the total number of users in your Active Directory database (If you have a very large number of users, it could also be a lot slower).

Writing a script to read usernames from a CSV file, querying the attributes of those users and then writing them back out to a CSV is also an option - If you need to do it this way, please post back with some more details of the attributes you are interested in.

Hope this helps,

David
1/14/2010 2:47:18 PM
darefugee
darefugee
Posts 2 		Thanks Sir. Actually I did it a different way - I exported all the domain users along with the attributes I needed, to a CSV. I also already had the other list in another CSV, so I copied it and pasted into the all users CSV, then ran a slightly modified "compare" Excel macro I found somewhere else. It compared 14100 names against 2600 names and pared the results to just the matches in about 5 minutes. Good enough for my purposes.
1/31/2010 11:01:59 AM
htc3400
htc3400
Posts 1 		Dear Admin

Is there a way to display the password last set attribute from AD using ADbulk users tool???When i try that its actually displayed as system_comboject and does not display the date ...Please help...

Thanks
2/1/2010 12:40:07 PM
admin
admin
Posts 331 		htc3400 wrote:
Dear Admin

Is there a way to display the password last set attribute from AD using ADbulk users tool???When i try that its actually displayed as system_comboject and does not display the date ...Please help...

Thanks


Hi,

The attribute is "pwdlastset", but it requires special handling which hasn't been included in the current version of Bulk AD Users. This is because the attribute is stored as a large integer value in AD. The current version will display a value (filetime integer instead of a date) when using the "Get Users From OU" or "Get Users From Query" methods. If you refresh the grid or use a different method to select your user accounts, the value will display as "System.__ComObject".

I plan to include better support for large integer attributes in future versions of the application.

Thanks,

David
pages: 1
|
Home » Scripting » Select AD User & Attributes to Output CSV