CWA - Update Table Data - UnifiController

Purpose

This document provides the requested data from the Unifi controller to the ConnectWise Automate environment.

Content	Type	Function
EPM - Data Collection - Agnostic - Script - Get-UnifiController	Agnostic Script	Returns all available data from the Unifi Controller.
CWM - Automate - Script - Update Table Data - UnifiController	Script	1. Executes Agnostic Script 2. Creates Custom Tables 3. Populates those tables with data
CWM - Automate - Custom Table - plugin_proval_unificontroller	Custom Table	Holds individual controller to Client / Location Data.
CWM - Automate - Custom Table - plugin_proval_unifidevices	Custom Table	Each controller has devices; this information is stored here.
CWM - Automate - Custom Table - plugin_proval_unifiwireless	Custom Table	Each site has wireless information; this information is stored here.

To implement this solution, follow these steps. Is there any manual configuration that needs to happen for this solution to succeed?

Import the Automate script into the environment.
Identify the devices that either host the Unifi controller or target a machine that can access that controller, and run the script.
- Notes:
  1. Depending on the size of the controller and the number of sites and/or devices that controller has, this script could take a while to complete.
  2. The script is written in a way that the SQL injection statement should never exceed the character limit of the Automate platform; the script should loop through until all requested information is uploaded to the table.

(This section can be filled with frequently asked questions related to the implementation or usage of the solution.)