Performing MS SQL Audit with Nessus

Issue

The default Nessus\CIS auditfiles for MS SQL are split up in OS level and Database level auditfiles. This results in at-least 2 auditfile per instance which you have to schedule in 2 jobs.
This is not a scalable solution.

 Objective

  • Create OS level checks that run OS and database checks and loop through each running instance per server/cluster.

Solution

Posted on https://discussions.nessus.org/message/27616#27616