Author: Bob Lin

1. Select File.

2. Select Open & Export > Import/Export.

3. Select Export to a file > Next.

4. Select Comma Separated Values > Next.

5. Under the email account you want to export contacts from, select Contacts.

6. Select Browse… and go to where you want to save your .csv file.

7. Type in a file name and then select OK.

Select Finish.

1. With the Microsoft Teams open, click on More or 3 dots….

2. Click on Language and speech>Turn on live captions.

3. Select the language everyone speak. For example, most people speak English and a few peoples speak Chinese, you should select English as default language. People speak Chinese will be translated to English.

1. Make sure Microsoft Teams PowerShell module is already installed on your computer. Please refer to this post:

How to Add Bulk Users to Microsoft Teams using PowerShell

2. Connect to Microsoft Teams PowerShell module by running this command:

Connect-MicrosoftTeams

3. Find the GroupID of the Team you wish to add users.

Use this command:

Get-Team| Where {$_.DisplayName -eq"MyTeam"} | Select-ExpandPropertyGroupID

Note: replace “MyTeam” with the team group you wish to add users, for example:

Get-Team | Where {$_.DisplayName -eq “Midwest Agents”} | Select -ExpandProperty GroupID

The GrupID is 043dc0a6-….-e6f17956e986

4. Creat a CSV file with Users to Add to the Team.

5. Import Users from CSV to Microsoft Teams using PowerShell.

Run these commands;

$TeamUsers = Import-Csv -Path “location.csv”

$TeamUsers | ForEach-Object {
Add-TeamUser -GroupId ########## -User $_.Email -Role $_.Role
Write-host “Added User:”$_.Email -f Green}

For example.

$TeamUsers = Import-Csv -Path “C:\Temp\Test2.csv”

$TeamUsers | ForEach-Object {
Add-TeamUser -GroupId 043dc0a6-…….-e6f17956e986 -User $_.Email -Role $_.Role
Write-host “Added User:”$_.Email -f Green}

1. Run PowerShell as administrator.

2. Install the PowerShell module for Microsoft Teams in your machine by runnng this command:

Install-Module MicrosoftTeams

Note: To check if you have the Teams module installed already by: 

3. Now, you can connect to Teams and work on your requirements. Get a List of Microsoft Teams with PowerShell using this command:

Connect-MicrosoftTeams

1. Go to Network>Site Configuration.

2. Click on Socket.

3. Yu should see all Interfaces and connections.

username: ubnt or root or admin

password: ubnt

1. Download SonicWal Global VPN, GVCSetupXX.exe (where XX is either 32 for 32‐bit Windows platforms or 64 for 64‐bit Windows platforms), from MySonicWall.
2. Double‐click GVCSetupXX.exe to launch the Setup Wizard.

3. Click Next and check Agree in the Agreement.

4. Click Next. The Installation Folder Selection page displays.

5. Keep the default settings and click on Next.

6. Follow the Wizard to complete the instalaltion.

Note: Click Allow if you receive this popup.

7. Setup Connection.

8. Enter IP address of the VPN Server and name.

9. Click Finish to complete it.

10. Now, it is ready to connect the VPN by clicking on Enable.

Step 1: Create a excel file with name and email address

Create an Excel table with the email addresses. Save it in OneDrive in our example.

Step 2: Create an Instant Power Automate Flow

1. Go to Power Automate by going to https://flow.microsoft.com or https://make.powerautomate.com/
2. Click on Create in the left pane.
3. Select the flow, for example Scheduled cloud flow.

4. Enter the flow name and edit the Run this flow date and time. Then click on Create.

5. Click on + to an action.

6. In the search bar, type list row and select List rows present in a table under Excel Online (Business).

7. Select OneDrive for Business in Location.

8. Select OneDrive in Documents Library.

9. Select the excel file saved in step 1.

10. Select Table, for example Table1 n our example.

11. Click New step.

12. Click + to choose an operation.

13. Type get a row in the search bar. Select Get a row – Excel Online (Business).

14. Select he column and value.

15. If you don’t see Key Value, type /.

16. Add another action for add a member.

17. Select Team and A user principle name or AAD ID.

18. Principle name could be Email address.

19. Now save the settings.

20. For demo, please check the Team’s member.

21. You should have just created flow in My flows.

22. You can test it, run it, edit it and turn it off.

• Hold down the reset button for 10 seconds. For a TZ, the reset button is located next to the power jack.
• Click on Factory Reset.

• Click OK to confirm to the reset.

• Please wait.

• The device will reboot.
• Set your computers IP address to 192.168.168.167 MASK 255.255.255.0.
• Connect your computer to the LAN port on the SonicWALL TZ.
• After the device reboots it will be in recovery mode. Connect to at http://192.168.168.168.
• The default login is: admin and password.

• At this point the device is reset to factory defaults and change the password.

With SonicWall Migration Tool, you can import configuration from old SonicWall and other platforms such as Check Point, Cisco IPX/ASA, Fortinet, Juniper, Palo Alto, Sophos and Watchguard. This article shows you how to use SonicWall Migration Tool to import an old SonicWall configuration.

1. Access SonicWall Migration Tool at https://migratetool.global.sonicwall.com/ and click Next.

2. Upload the exported configuration files

3. Select Target SonicWALL, for TZ70W in our example.

4. Review Interface settings.

5. Export the new Settigns.

Note: 1. You mya get an error if your https port is different from the default port 443 as shown above.

2. You may have a problem for email or an using https apps if you change the https port, from 8090 to 443. You may have two options. 1. change back the port to 8090. 2. Or re-configure the certificate and other related configuration.

6. Re-import the migrated configuration to the new SonicWALL.