Sonicwall NSA ssh & MSSQL script

Sonicwall NSA ssh & MSSQL script

Cancelled

Job Description

We need a developer/server admin to create a script to perform the below:

1. Lookup/Query IP addresses from a MSSQL database (Multiple IPs) (Script to perform SELECT & query)
2. Add an Address Object for the IP addresses (1 x Address Object per IP) (If one does not already exist) to our Sonicwall NSA via ssh
3. Add the new Address Object to an Address Group to our Sonicwall NSA via ssh
4. Record the above in an audit trail (MSSQL)

---
Skills: microsoft-sql-server, script-writing