SharePoint permissions reporting tool

AID: 1975
  • Status: Published

5850 points

  • Bydp_expert
  • TypeReview
  • Posted on2009-11-17 at 01:34:53
Recently Microsoft has released the Fourth Release of the Microsoft SharePoint Administration Toolkit. It was announced on the SharePoint team blog.

A very interesting part of this toolkit is a permission reporting tool. I think that every administrator should have it on their MOSS/WSS environment as this helps with permission management on the farm. It is also really useful when working with work-flows and other permission setting solutions - it can help you debug some problems with the permissions to the work-flow and work-flow items.

Generally, the tool allows administrators to quickly check users' permissions. This is very helpful, especially when you have multiple inheritance brakes and large number of permission levels - it is very easy to lose track of who has which permissions.

The tool allows you to check permissions on every level (site, list and item) to determine what permissions the chosen user has. The tool displays what kind of permission levels the given user has to a chosen object and how they were assigned (i.e., through group or directly). More about this functionality is here.

The reporting tool, also, gives you the ability to quickly glance through permissions for all lists and sites in a given site. It also lets you compare the permissions to the parent permissions and lists which are different - who was added and who was removed as well as different permissions for given users on both locations. More on Office.com.

What is strange - the tool does not tell you that a user is a farm admin.

Another cool thing is the broken inheritance report. This report gives you information about what the permissions are for the current object and its siblings. More info about these report is here. The reports are in XML form, but can be easily opened in Excel. By default reports are stored in a SharePoint list.
Note: It takes some time to run the report.

You can download the tool from here.

Here are some tips about the setup:

  • you need to have SP2 with the April Cumulative Updates. I would recommend installing the October Updates, as the April ones are included in the October CU. All details on how to setup the October CU are here. Make sure you install the SP with all the language packs, as without them you will not be able to install the CU.

  • after you setup the Toolkit you will find the reporting tool in the folder where the toolkit was setup (by default C:\Program Files\Microsoft\SPAdministrationToolkit\PermissionReportingSolution). It's in the form of a WSP. You need to use the STADM and addsolution operation and to set it up on your farm. Here is an MSDN article on how to add solution, deploy it and activate the feature from the STSADM  
    Next you need to deploy the solution from the central administration (operations -> global configuration -> solution management).

  • The last step is the feature activation - you activate it for the farm. You need the April CU to activate the feature.

Asked On
2009-11-17 at 01:34:53ID1975
Tags

Effective permissions

,

reporting tool

,

permission inheritance

,

Sharepoint

Topic

MS SharePoint

Views
6254

Comments

Author Comment

by: dp_expert on 2010-12-03 at 01:22:19ID: 21814

Add your Comment

Please Sign up or Log in to comment on this article.

Join Experts Exchange Today

Gain Access to all our Tech Resources

Get personalized answers

Ask unlimited questions

Access Proven Solutions

Search 3.2 million solutions

Read In-Depth How-To Guides

1000+ articles, demos, & tips

Watch Step by Step Tutorials

Learn direct from top tech pros

And Much More!

Your complete tech resource

See Plans and Pricing

30-day free trial. Register in 60 seconds.

Loading Advertisement...

Top MS SharePoint Experts

  1. ACH1LLES

    358,298

    Wizard

    0 points yesterday

    Profile
    Rank: Genius
  2. JamieMcAllister

    189,161

    Guru

    0 points yesterday

    Profile
    Rank: Sage
  3. teylyn

    170,328

    Guru

    900 points yesterday

    Profile
    Rank: Genius
  4. ivan_vagunin

    156,400

    Guru

    0 points yesterday

    Profile
    Rank: Sage
  5. QPR

    123,685

    Master

    2,000 points yesterday

    Profile
    Rank: Genius
  6. Tehzar

    100,639

    Master

    0 points yesterday

    Profile
    Rank: Guru
  7. svetaye

    75,681

    Master

    0 points yesterday

    Profile
    Rank: Guru
  8. tedbilly

    71,150

    Master

    0 points yesterday

    Profile
    Rank: Genius
  9. quihong

    52,832

    Master

    0 points yesterday

    Profile
    Rank: Sage
  10. dp_expert

    49,160

    0 points yesterday

    Profile
    Rank: Wizard
  11. colly92002

    41,560

    0 points yesterday

    Profile
    Rank: Master
  12. clayfox

    39,400

    0 points yesterday

    Profile
    Rank: Genius
  13. milindsaraswala

    36,835

    0 points yesterday

    Profile
  14. RainerJ

    31,840

    1,000 points yesterday

    Profile
    Rank: Master
  15. abhitrig

    31,218

    0 points yesterday

    Profile
    Rank: Wizard
  16. dhawalseth

    30,268

    0 points yesterday

    Profile
  17. ImaCircularSaw

    29,438

    0 points yesterday

    Profile
    Rank: Guru
  18. martusha

    25,478

    0 points yesterday

    Profile
  19. zephyr_hex

    21,624

    0 points yesterday

    Profile
    Rank: Genius
  20. FastFngrz

    21,414

    0 points yesterday

    Profile
    Rank: Guru
  21. livanescu

    20,100

    0 points yesterday

    Profile
  22. danshady

    18,870

    0 points yesterday

    Profile
  23. CloudedTurtle

    18,050

    0 points yesterday

    Profile
    Rank: Master
  24. jessc7

    17,102

    0 points yesterday

    Profile
    Rank: Sage
  25. JoeKlimis

    16,318

    0 points yesterday

    Profile
    Rank: Master

Hall Of Fame