Automated CIS Benchmarking

I automated CIS (Center for Internet Security) benchmarks auditing of 100+ database servers using PowerShell scripts and queries. The project was for a Fortune 500 company that had to comply with the CIS benchmark. So, I developed a PowerShell script to login to each Microsoft SQL server. The script fetches required information using carefully formulated SQL queries to assess whether the database server complies with each one of the guidelines in the CIS benchmark specification.

The gathered data is then stored in a table. Each row in the table corresponds to a server. The script also sends an email with the data in a tabulated format.