Description: Reads an MSSQL table containing records of new devices to create in SevOne and creates them. MSSQL records with a device already on SevOne or with missing info are excluded from the creation.
Rapid Network Automation Version: 2022.8 or later
Integrations required: SevOne minimum version 1.0.20, MSSQL minimum version 1.2.2
Authentication(s) needed: SevOne, MSSQL
SevOne User Role: The user must be part of the administrator's group
MSSQL User Role(Fixed DB Role): db_datareader // This is a fixed database role that can read all data from all user tables and views.
MSSQL User Role (User DB Role): At a minimum, the user must be able to read the targeted table. Please speak to your granting authority.
Setup:
- You must modify the variable SevOne_Authkey in the start block to your current SevOne authentication name
- You must modify the variable MSSQL_Auth in the start block to your current MSSQL authentication name
- You will need to change the MSSQL_Database & MSSQL_Table variable to reflect the database and table name you are trying to onboard from.
- The required columns in the MSSQL database table: "name", "alternate_name", "description", "ip_address", "polling_frequency"
Expected results:
- List of Devices
- Created devices
- Omitted devices