Reading the memeberships of 560Users

[Beilage]

<HR style="BACKGROUND-COLOR: #ebebeb; COLOR: #ebebeb" SIZE=1> <!-- / icon and title --><!-- message -->
<!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->Hello,

I'm looking for a possibility for get the user with all their goup memberships in a excel Sheet. I have 560 domainuser in our domain.

So I need either an Excel spreadsheet where the user name stands in and behind them the names of the groups in a separte cell or a CSV file.

A single user, I can read with dsquery ... Unfortunately, but not 560 and I thought that there must be a way in VBA ...

I use Excel 2007

Can you help me?

Many greetings
<!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[Hermanito]

What is dsquery?

Do you have any VBA code right now for a single user?
Where do you have the list of users? On an Excelsheet?

Actually this sounds more like something you could/should do with PowerShell...

 

[Beilage]

Hi,
dsquery is a cmd command. You are able to read the attributes from 1 User... So I have NO VBA Code for one User.

I'm not sure how to to that.
The users are in the Active Directory right now.

What shall I do?

 

[Hermanito]

Although reading AD properties directly from VBA is possible, I have no experience or working code for that. I guess it can get quite complex...

Maybe check out things like:
http://stackoverflow.com/questions/5072996/powershell-how-to-get-groups-a-user-is-member-of
http://technet.microsoft.com/en-us/library/ee617195.aspx

and try to solve your problem with scripting...
I don't have any experience there either, so I can't help you with that, and I think you won't find many here with such experience...