{"id":4220,"date":"2024-08-13T10:50:54","date_gmt":"2024-08-13T09:50:54","guid":{"rendered":"https:\/\/www.lieben.nu\/liebensraum\/?p=4220"},"modified":"2024-08-13T10:50:54","modified_gmt":"2024-08-13T09:50:54","slug":"microsoft-teams-permission-auditing","status":"publish","type":"post","link":"https:\/\/lieben.nu\/liebensraum\/2024\/08\/microsoft-teams-permission-auditing\/","title":{"rendered":"Microsoft Teams permission auditing"},"content":{"rendered":"\n
\"\"\/<\/figure>\n\n\n\n

I lied, not just Teams, also Sharepoint and Onedrive!<\/p>\n\n\n\n

As I am asked often how to report on specific permissions granted to individual (groups) of (internal\/external) users….and Microsoft doesn’t have a good built-in solution, nor does the community seem to yet….this something was just asking to be coded!<\/p>\n\n\n\n

My TeamPermissions PowerShell module<\/a> will do exactly the above, a full report in XLSX, CSV or HTML format that contains ALL unique permissions<\/strong> for a given Team, Sharepoint site or Onedrive location for all files, folders, lists, list items etc. Example:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

It uses the safe Entra Delegated Permission Flow<\/a> for authentication so your credentials\/tokens stay with you, but this does mean you have to run it as a Sharepoint Administrator (or Global Admin), there is no support for MI\/SPN runs yet but can be added easily if there is much demand.<\/p>\n\n\n\n

Since it exports to Excel in append mode, you could run it for multiple (or all) team sites and use e.g. Pivots to view all permissions for a given user.<\/p>\n\n\n\n

Do note that although some work has been done on performance, it does not scan multiple locations in parallel yet, this will be added in a future version.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Example:<\/p>\n\n\n

\nInstall-PSResource -Name TeamPermissions -Repository PSGallery\n\n#then get xlsx\/html reports for the INT-Finance Department Team:\n\nGet-TeamPermissions -teamName \"INT-Finance Department\" -ExpandGroups -OutputFormat XLSX,HTML\n\n#Or get all permission for a Sharepoint site:\n\nGet-TeamPermissions -TeamSiteUrl \"https:\/\/tenant.sharepoint.com\/sites\/site\" -ExpandGroups -OutputFormat Default\n<\/pre><\/div>\n\n\n
Notes<\/strong><\/p>\n\n\n\n
Required PS modules: PnP.PowerShell, ImportExcel<\/p>\n\n\n\n
Running multiple times will append data if you don’t move the (xlsx, csv, html) file, turning the report into a multi-location report.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
I lied, not just Teams, also Sharepoint and Onedrive! As I am asked often how to report on specific permissions granted to individual (groups) of (internal\/external) users….and Microsoft doesn’t have a good built-in solution, nor does the community seem to yet….this something was just asking to be coded! My TeamPermissions PowerShell module will do exactly … Continue reading Microsoft Teams permission auditing<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[4,27,32,39,43,44],"tags":[],"class_list":["post-4220","post","type-post","status-publish","format-standard","hentry","category-automation","category-microsoft-teams","category-office-365","category-powershell","category-security","category-sharepoint-online"],"_links":{"self":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/4220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/comments?post=4220"}],"version-history":[{"count":0,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/4220\/revisions"}],"wp:attachment":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/media?parent=4220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/categories?post=4220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/tags?post=4220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}