Hey, Scripting Guy! How Can I Get a List of Active Directory Groups That Have Just 1 Member or Fewer?

re: Hey, Scripting Guy! How Can I Get a List of Active Directory Groups That Have Just 1 Member or Fewer?

XIIxOveR — Mon, 06 May 2013 18:51:07 GMT

If the value of objGroup.member is empty (i.e. group has 0 members) the following loop will error as it is not a collection:

For Each strUser in objGroup.Member

i = i + 1

If i > 1 Then

Exit For

End If

You have to accomodate for the possibility of the collection being empty.

re: Hey, Scripting Guy! How Can I Get a List of Active Directory Groups That Have Just 1 Member or Fewer?

Ryan — Thu, 01 Sep 2011 11:03:09 GMT

Hi,

I also would like to get this to write to a file. Please can you explain how to change it so that it does. I'm a noob admin that is just started to learn how to run these scripts..

Thanks!

re: Hey, Scripting Guy! How Can I Get a List of Active Directory Groups That Have Just 1 Member or Fewer?

IamMred — Tue, 19 Jul 2011 21:29:04 GMT

@Diddle You will need to change the following:

Wscript.Echo objRecordSet.Fields("Name").Value & " -- " & i

Portion of the script to write to a Word document. Use the Microsoft Word tags in the tag cloud to see how to do that, or check for scripts in the Script Repository (in related links portion).

re: Hey, Scripting Guy! How Can I Get a List of Active Directory Groups That Have Just 1 Member or Fewer?

Diddle — Tue, 19 Jul 2011 21:18:32 GMT

Well, this was interesting.... not the okra part, but the code. Is there a way to make it write to a text document the group and the number of members in that group with a comma delimiter. It seems like it would be more effective? How would you do this?

example

swbanana,5

swcheese,394

ect.

It would be really cool if you could change the above script to do this.

Thanks,

Diddle