Using PowerShell to gather and upload information on devices in BYOD Rooms and Bookable Desks to Teams Rooms Pro Management Portal

The script utilizes PowerShell cmdlets and native Windows API functions to gather information about connected devices (peripherals). It can tell the differences between different types of peripherals such as USB devices, monitors, cameras, speakers, and microphones.

When you run the PowerShell script, the data is exported to a CSV file that can be upload to Teams Pro Management Portal for managing, monitoring, and reporting usage of devices in BYOD rooms and Bookable Desks.

Steps

  1. Go here to download the Get-TeamsBYODRoomDevices.ps1 PowerShell script.

  2. Unblock and extract the downloaded zip file. Move the Get-TeamsBYODRoomDevices.ps1 script to your preferred location on your PC.

  3. Open a new PowerShell window and navigate to the location where you moved the Get-TeamsBYODRoomDevices.ps1 script.

    Note

    You can optionally open the script and customize it before you run it. However, don't change the sheet name. The sheet name must be named PERIPHERALS.

  4. Run the script by executing the following command in the PowerShell window:

    \Get-TeamsBYODRoomDevices.ps1
    
  5. The script prompts will guide you through the process:

    • Wait for the script to detect and gather information about the connected devices.
    • Connect the external devices when prompted.
    • Enter the required details such as User Principal Name (UPN), Display Name, and Grouping ID for data collection when prompted.
    • Provide the folder path where the PERIPHERALS.csv file will be saved when prompted.
    • The script will process the discovered peripheral data and export it to the specified file path.
  6. Review the exported data to verify accuracy.

  7. When finished, enter 'Y' when prompted to end the collection process.

  8. Open the CSV created on the set area path and notice the device details collected including Account, Display Name, Product ID, Vendor ID, Serial Number, Peripheral Name, Peripheral Type and Group ID.

    Note

    Group ID is a way to still 'group them' for later assignment if while individually collecting the peripheral data you do not know the UPN or Display Name for the group of peripherals being collected. This is because Teams Pro Management portal won't have any understanding of Group ID, it is more for keep the peripherals grouped in the output CSV so an account plus the display name could be assigned to each at a later time.

  9. Save the CSV file in .XLSX format. The first sheet in the CSV file must be titled PERIPHERALS.

    Important

    If sensitivity labels are enabled in your tenant, verify that the Excel file has a label of non-business, public, or general.

  10. Sign in and open the Microsoft Teams Pro Management portal, in the Devices page, select Import to add the device inventory to upload the file you modified.

  11. Verify that the device and desk association is updated successfully in the Teams Pro Management portal.