Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


Return to article

Let Users Get Group Information Themselves
 

At my company, many managers were asking me for membership lists so that they could determine who has access to what applications. To get this information, I was constantly pulling lists from the Microsoft Management Console (MMC) Active Directory Users and Computer snap-in. To alleviate this time-consuming task, I created the Group Enumerator utility (AD-GroupMem.hta). This HTML Application (HTA) provides users with group membership information without-having to give them access to the domain through the Active Directory Users and Computer snap-in. Now that I've created the Group Enumerator utility, managers can look up membership information themselves.

Figure 2 shows the Group Enumerator utility's UI. If you select a group in the Distribution Groups or Security Groups column, the members of that group will appear in the Group Membership column. The Group Enumerator utility supports subgroups. A plus sign (+) will appear in front of each subgroup in the Distribution Groups and Security Groups columns. In the Group Membership column, a hyphen (-) will appear in front of each submember. If you click the Export Results button, the HTA will export the results to Microsoft Excel.

You can download the Group Enumerator utility from the Windows Scripting SolutionsWeb site. (See page 1 for download information.) Listing 3 shows the code you need to customize to get the Group Enumerator utility to work in your environment. You need to replace the DOMAIN constant's value with your AD domain's name. If you don't want groups from certain organizational units (OUs) to display in the Group Enumerator utility, you can customize the code at callout A in Listing 3. After you customize this code, you need to remove the comment characters that precede it and comment out the line that callout B shows.

—Tad Sherrill





Reader Comments

Tried running this utility after I configured the Listing_03.customizeinADGroupMemhta.txt file. Yet when I launch AD-GroupMem.hta I get a scripting error on line 76 char 2. Also it does not enumerate any security or dl groups. Is there something I am doing wrong?

dcpark -July 11, 2006

This would be real handy, But I can't get it to work. Error is Line: 94 Subscript out of range" 'intSecCount'

OldDog -July 20, 2006

I don't have days to wait for it to enumerate a 60000 user domain for groups. It would be useful to be able to type in a group name or add a list of groups to a file and it choose from those.

JASONSTANLEY -July 21, 2006

I receive a similar error. Line: 98 Subscript out of range" 'intDistCount'

timwmarion -July 25, 2006

Excelent utility. Ran fine expcept for the ADO security nags when run from a server/IIS. Running from a PC solves that, though. How about a reverse lookup script? In other words, you pick a user and all their memberships are enumerated.

john_petry -July 27, 2006
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement