So we’ve already had one situation where we had to use a recover command and lost all of our permissions, roles, etc. Restoring them can be a HUGE PITA because while Microsoft was kind enough to document them, you need to cross reference two different pages to see both the default permissions themselves, and the default assignments of those permissions to TFS groups and roles. BUT you cannot easily visualize them in the format you would see them in when setting your permissions. IOW, you are setting values in a dialog like this:
But the documentation is provided in this format:
NOT HELPFUL right? I had to search the pages by role or group, highlight where they showed up, and :: scroll, scroll, scroll:: to find all of the places where they existed to set the values. The documentation is NOT in line with the implementation. I kept thinking “if only this was in Excel, I could sort, and filter and SEARCH. There would be unicorns and rainbows!!” I searched, no one seemed to have posted a permissions matrix on-line and my buddies on the product team claimed no knowledge of one. They did say if I created one they would love to have it. And after the help they’ve given me lately, how could I say no?
I am more than a bit OCD and just sucked it up and spent the time building this in a spreadsheet format that was sortable and filterable. It is EXPLICIT permissions only, so those listed in the two referenced source pages. So I spent about 2 hours building this, but in the long run it will save me FAR more than 2 hours. JUST LOOK!
You can access the spreadsheet here, and all sorting and filtering work: https://skydrive.live.com/redir?resid=E796C9484DF4BAA3!10019&authkey=!AJ0OZWvOhG8OjHs Note that I separated it into 2 worksheets, Server, Collection and project level in one, and everything else in the other. I was going to put it all into one, but there were WAY too many columns and it was hard to read.
Again I say, you’re welcome! Please let me know if you notice anything I might have missed, I am human after all. Since it is SkyDrive updates will be posted in real time as I fill in any gaps or make corrections. If you feel compelled to repay my kindness I love dark chocolate and gerber daisies. Consequently if you meet up with me at a user group or tech event and want to thank me, I also prefer Hendricks gin