This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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 Read Permissions, GROUP3 has Modify Permissions

GROUP4 is a member of GROUP2.

USER1 is a member of GROUP1 and GROUP2.

 

The report would look something like this:

Report for USER1 to SERVER1\Shared

------------------------------------------

USER1 -> GROUP1 -> SERVER1\Shared (Modify)

USER1 -> GROUP4 -> GROUP2 -> SERVER1\Shared (Read)

 

This is a small example.  A user may have access to the share through four or more sets of groups in some cases and the groups could be nested about five deep. 

 

We would specify the user name and server\share for the report.

 

It looks like a similar request was asked for here:

https://www.quest.com/community/products/enterprise-reporter/f/custom-reports/934/custom-report---folder-permissions---expanding-the-groups#

 

We would like the same kind of report, but we do not need every group expanded out.  We could limit the report to include one user to one specific share.  Some kind of report that would recursively check the users group-path to the share.

 

Thanks,

Allen

  • Thank you for your request. Someone will look into this and respond shortly.
    • Hi Allen, I would like to follow up and let you know we are still actively researching this and will have more details on this shortly.
      • Hi

        Please find the attached report which displays the list of groups (including nested groups) that give a user access to a shared folder. This report requires the AD and NTFS collections. 

        Thanks

        Naureen
        Share Permissions by Account.zip

        • I was able to import the report just fine. We do have AD and NTFS collections.

          I do have three problems:

          I am unable to select a user for the report. When I search, I see no results. I can select users in other reports that we have created.

          When I validate the query, I get: Invalid object name 'tblNTFSShare'.

          When I click the layout tab, I get "The report could not be generated. Check the properties of the report and try again."

          Thanks,
          Allen
          • We are on 2.5.1 Build 1000 if that matters.
            • Being on version 2.5.1 does make a big difference and why you are experiencing the errors. The report will have to be investigated again for possible support in v2.5.1.

              Are you upgrading soon? Version 2.6 and v3.0 are available with many new features.

              Thanks!
              -Angela
              • This is a good reason for us to upgrade to 3.0. I will try to do that soon and re-test the report. No need for you to re-investigate. Thanks.
                • We have successfully upgraded to version 3.0.0 Build 2722. I was able to import the custom report and validate the query, however, I am getting an error when I run the report:
                  Printing: Error when trying to populate the datasource. The following exception was thrown: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >=, or when the subquery is used as an expression.

                  Thanks,
                  Allen
                  • We will look into this issue and get back to you shortly.
                    Thank you!
                    • Hi Allen,

                      Please find the attached updated report. Kindly let us know if you face any issues.

                      Thanks

                      Naureen

                      5543.Share Permissions by Account.zip