So I wanted to try DelivePoint from Barracuda Tools and I was a bit disappointed. I was expecting this tool to map out the Active Directory Groups for each site with the type of permissions plus tell me what lists and libraries had a break in permissions and what groups were associated. When I tried to view the permissions for a given site it only allowed me to choose site collection administrators, full control, designer, and readers. There was no option to view any custom permissions, contributors or approvers. Not to mention, all the users for the site were listed and not the groups, so basically it broke out all the users from all my groups and shoved them into this long list with tons of pages. I also noticed a few options included that would transfer permissions from one account to another. They were really of no use, considering we use Active Directory Groups mainly. I was expecting one thing and I am sad to say i was really dissapointed by Barracuda Tools. I followed one of the developers, Keith Richie, a bit on his blog as he was creating this tool. I guess I was building up the product a little too much.
This week, I did, however, find a great tool that tells me every place within SharePoint (including lists and libraries) that has different permissions than the main site. If you go to codeplex and type in SUSHI, then you should find the project. This option I am talking about is one of many other tools included in the windows application. I am going to use this tool as a guide to map out all our active directory groups and sites using a database with two tables in SQL Server and an InfoPath Form (so far). I have one table that lists all the site information, such as template, url, name, and special information. I have another table that has a relationship by the id of the first table through a foreign key constraint. This second table list all the active directory groups related to the sites in the first table. For example, it has the group name, the purpose of the group, and a check box if the group is related to a list or library or a group of them so I can enter that information. I added a querying option on my InfoPath Form and the ability to submit to the database. It's a really simple easy form with only two rules and the base SQL Functionality. All in all I think this will help me out a great deal when documenting the site structure and security.