{"id":6939,"date":"2023-01-18T19:50:59","date_gmt":"2023-01-18T19:50:59","guid":{"rendered":"https:\/\/rakhesh.com\/?p=6939"},"modified":"2023-01-18T19:50:59","modified_gmt":"2023-01-18T19:50:59","slug":"teams-powershell-contd","status":"publish","type":"post","link":"https:\/\/rakhesh.com\/azure\/teams-powershell-contd\/","title":{"rendered":"Teams PowerShell (contd.)"},"content":{"rendered":"

I had to leave yesterday so stopped my previous post<\/a> abruptly. In my previous post I had mentioned that after an account migration the user couldn’t see any of their teams so I changed their role from member\/owner to owner\/member and back, and that fixed the issue. However they couldn’t see any of the channels they previously had access to.<\/p>\n

I prepared a report of all the channels in the teams the user is a member of via this snippet:<\/p>\n

$outputObjArray = [System.Collections.ArrayList]@()\r\n$user = \"abc@def.com\"\r\nGet-Team -user $user | ForEach-Object {\r\n\t$OutputHash = [ordered]@{\r\n\t\t\"Team\" = (Get-Team -GroupId $_.GroupId).DisplayName\r\n\t\t\"GroupId\" = $_.GroupId\r\n\t\t\"Channels\" = (Get-TeamChannel -GroupId $_.GroupId | Where-Object { $_.MembershipType -eq \"Private\" }).DisplayName -join '; '\r\n\t}\r\n\t$outputObjArray.Add($OutputHash) | Out-Null\r\n}\r\n\r\n$outputObjArray | ForEach-Object{ [PSCustomobject]$_ } | Export-CSV -NoTypeInformation $reportFileName<\/pre>\n
Sent the CSV to the user so they can select the ones they were a member of. The channels are in a single column with semi-colons separating them.<\/p>\n
Armed with that output I ran the following to add the user back to the channels:<\/p>\n
$user = \"abc@def.com\"\r\nImport-Csv $reportFileName | ForEach-Object {\r\n\t$channels = $_.Channels -split ';\\s*'\r\n\tforeach ($channel in $channels) {\r\n\t\tif ($channel -ne \"NONE\" -and $channel.Length -ne 0) {\r\n\t\t\t\"$($_.Team) | $channel\"\r\n\t\t\tAdd-TeamChannelUser -GroupId $_.GroupId -DisplayName $channel -User $user\r\n\t\t} \r\n\t}\r\n}<\/pre>\n
The “NONE” and length 0 checks were necessary to ignore remarks from the user in the CSV file.<\/p>\n
In this case I went with adding the user as a member, but I could have used the -Role Owner<\/code> switch to add as an owner.<\/p>\n
I have more migrations to do, so I figured I should make a list of all teams a user is member of, find out the private channels, and if the user is in any of them then capture the info. Here’s what I came up with:<\/p>\n
$outputObjArray = [System.Collections.ArrayList]@()\r\n$user = \"abc@def.com\"\r\n$reportFileName = \".\/report.csv\"\r\nGet-Team -user $user | ForEach-Object {\r\n\tWrite-Host \"Processing $($_.DisplayName)\"\r\n\t\r\n\t# Capture the team name and Id\r\n\t$OutputHash = [ordered]@{\r\n\t\t\"Team\" = (Get-Team -GroupId $_.GroupId).DisplayName\r\n\t\t\"GroupId\" = $_.GroupId\r\n\t\t\"Private Channels\" = \"NONE\"\r\n\t}\r\n\t\r\n\t# Get the private channels\r\n\t$privateChannels = Get-TeamChannel -GroupId $_.GroupId | Where-Object { $_.MembershipType -eq \"Private\" }\r\n\t\r\n\t# If the count isn't 0, process them\r\n\tif ($privateChannels.Count -ne 0) {\r\n\t\t$groupId = $_.GroupId\r\n\t\t$channels = @()\r\n\t\t\r\n\t\t# Create an array of all the channels where this user has a role\r\n\t\t$channels += @($privateChannels | ForEach-Object {\r\n\t\t\t$channelName = $_.DisplayName\r\n\t\t\t$role = \"\"\r\n\t\t\t$role =  (Get-TeamChannelUser -GroupId $groupId -DisplayName $_.DisplayName | Where-Object { $_.User -eq $user }).Role\r\n\t\t\tif ($role.Length -ne 0) { \"$channelName | $role\" } else { \"\" }\r\n\t\t})\r\n\t\t\r\n\t\t# Join this array into a string; skip any empty elements (coz there would be empty elements from the output above)\r\n\t\t$OutputHash.\"Private Channels\" = $($channels | Where-Object { $_.length -ne 0 }) -join '; '\r\n\t}\r\n\t\r\n\t$outputObjArray.Add($OutputHash) | Out-Null\r\n}\r\n\r\n$outputObjArray | ForEach-Object{ [PSCustomobject]$_ } | Export-CSV -NoTypeInformation $reportFileName<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
I had to leave yesterday so stopped my previous post abruptly. In my previous post I had mentioned that after an account migration the user couldn’t see any of their teams so I changed their role from member\/owner to owner\/member and back, and that fixed the issue. However they couldn’t see any of the channels … Continue reading Teams PowerShell (contd.)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[887],"tags":[227,878],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6939"}],"collection":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/comments?post=6939"}],"version-history":[{"count":3,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6939\/revisions"}],"predecessor-version":[{"id":6942,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6939\/revisions\/6942"}],"wp:attachment":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/media?parent=6939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/categories?post=6939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/tags?post=6939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}