• Modify User Recursive Group Membership Report by adding a filter to limit Users it works against

    I have a customer we are running a divestiture migration with who has an extremely large Active Directory.  What I need to do is figure out based on a list of users (who have an LDAP Attribute populated for scope) what groups to add to our scope.  Normally…

  • Custom Query Domain Groups and Recursive Members

    This custom query report for Enterprise Reporter 3.1 is a Domain Groups with nested members report.  For the nested users, Display Name (Nested User), Email Address (Nested User), Is Disabled (Nested User), and Last Logon Timestamp (Nested User)  are shown…

    • Domain Groups and Recursive Members.zip

  • Report on group membership by domain computer account

    I need a report that lists all groups of which the computer accounts in a certain OU are members:

    computer           Member of

    computer1         GroupA

    computer2         GroupA

    computer2         GroupB

    etc.

    I have nu issue with reporting on group objects, listing computer…

  • Requesting a report that lists the Critical Groups in a domain, (Domain admins, Enterprise Admins, Schema Admins, etc.) showing the members of the group and also shows the users last logontimestamp

    Requesting a report that lists the Critical Groups in a domain, (Domain admins, Enterprise Admins, Schema Admins, etc.) lists the members of the group and also shows the users last logon time stamp

  • Custom Report that maps users access to a directory

    We are looking for a report that will show which groups (including nested groups) give a user access to a Windows share.

    For example we would like to see how USER1 has access to SERVER1\Shared

    SERVER1\Shared - GROUP1 has Modify Permissions, GROUP2 has…

  • Custom Reports with Custom Quieries breaks after upgrading to Enterprise Reporter 3.0

    Hi,

    I need help in fixing my Custom Report Queries when I upgraded Enterprise Reporter to version 3.0.  Somehow the database schema changed.  All of my custom reports display no results.

    Here is an example of "Folder Permission with Membership"…

  • Local Groups with Nested Members by Organizational Unit

    Local Groups with Nested Members by Organizational Unit

     

    Shows all the local groups for computers in the selected organizational unit with nested members.

    1. Run Computer discovery.

    2. Run AD discovery.

    3. Unzip and import the Local Groups with Nested…

    • Local Groups with Nested Members by Organizational Unit_v2.6.0.14000.zip

  • Local Groups with Members by Organizational Unit

    Shows all the local groups for computers in the selected organizational unit.

    1. Run AD and Computer discoveries.

    2. Unzip and import the Local Groups with Members by Organizational Unit_v2.6.0.14000.xrd report.

    3. Supply the parameters and run the report…

    • Local Groups with Members by Organizational Unit.zip

  • Local Groups with Members by Organizational Unit

    Shows all the local groups for computers in the selected organizational unit.

    1. Run AD and Computer discoveries.

    2. Unzip and import the Local Groups with Members by Organizational Unit_v2.6.0.14000.xrd report.

    3. Supply the parameters and run the report…

    • Local Groups with Members by Organizational Unit_v2.6.0.14000.zip

  • Local Administrators

    Shows the Administrators group memberships for the selected computers. Well-Known SIDs are excluded.

     

    Steps to import this report is as follows:

    1. Download the attached .xrd file.
    2. Open Report Manager.
    3. Go to My Reports.
    4. Click on Import and browse to the…
    • Local Administrators_v2.5.1.200.xrd.zip

  • Domain Users with group membership (with distinguished group name and OU)

    Domain Users report with list of groups for user.

    Changes:

    1. removed some info about user

    2. added distinguished group name

    3. Added optional parameters to filter by Group Name (e.g. "DOMAIN\Administrators") or Distinguished Group Name (e.g. "…

    • Domain users with group membership and OU.zip

  • Domain Users with group membership (with distinguished group name)

    Domain Users report with list of groups for user.

    Changes:

    1. removed some info about user

    2. added distinguished group name

    3. Added optional parameters to filter by Group Name (e.g. "DOMAIN\Administrators") or Distinguished Group Name (e.g. "…

    • Domain Users with group membership.zip

  • Users In Groups

    ER 2.6

     

    The report shows the direct and indirect group members. If you choose to include nested groups, both nested groups and users are displayed.

     

    1. Extract files

    2. Backup the database

    3. Execute the 'Users In Groups.sql' script

    4. Import…

    • Users In Groups.zip

  • Direct and indirect members of Group A and B

    ER 2.6

     

    The report shows all direct and indirect members of 'Group A', which are also members of 'Group B'.

    • Direct and indirect members of Group A and B.zip

  • Group Membership Comparison

    This Custom Query has been created to show the direct and indirect users that are members of the selected groups and show the comparison as well.

    You will need to run the SQL queries inside the "SQL_To_Add_Groups_GroupMembershipComparison.sql" file before…

    • Group Membership Comparison.zip

  • Domain Groups and Members - Detailed

    This is a customized version of the Domain Groups and Members report.  It has been customized to show each group member's SAMAccountName, First Name, and Last Name.

    Steps to import this report is as follows:

    1. Save the attached zip file to your computer…
    • Domain Groups and Members - Detailed.zip

  • NTFS Folder Permissions with Groups

    This report , for the specified computer, will show Folder permissions but will also include any groups found as a subreport with their direct members.

    • NTFS Folder Permissions with Groups Subreport 2.5.xrd.zip

  • Folder Permissions with Membership (For Groups with permissions to the folder, the Information Field is displayed)

    The current "Folder Permissions with Membership" report, doesn't include the "Information" field for Groups Permissioned to the Folder.

    The attached report will display the Information field for groups permissioned to the folder…

    • Folder Permissions with Membership (Information field displayed for Groups).zip

  • Group Membership Change History

    A custom query report that will take Organizational Units and Local Group Names as parameters. It will match the local group names against all the servers in the OU and reports the change history on the groups.

    For performance reasons, this report will…

    • Custom Query Parameter Values.zip