Skip to content

Instantly share code, notes, and snippets.

@tsubauaaa
Created June 13, 2016 11:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tsubauaaa/097d8075c6a3ae6cb97b65939cb62b1d to your computer and use it in GitHub Desktop.
Save tsubauaaa/097d8075c6a3ae6cb97b65939cb62b1d to your computer and use it in GitHub Desktop.
inspec file of sqlserver chef cookbook
control 'check-dot-net-3.5-installed' do
impact 1.0
title 'check dot net 3.5 installed'
desc 'Check dot net 3.5 is installed'
describe windows_feature('.NET Framework 3.5 Features') do
it { should be_installed }
end
end
control 'check-sql-server-installed' do
impact 3.0
title 'check sql server installed'
desc 'Check sql server is installed'
describe service('MSSQLSERVER') do
it { should be_installed }
it { should be_enabled }
it { should be_running }
end
end
control 'check-sql-server-olap-installed' do
impact 1.0
title 'check sql server olap installed'
desc 'Check sql server olap is installed'
describe service('MSSQLServerOLAPService') do
it { should be_installed }
it { should be_enabled }
it { should be_running }
end
end
control 'check-sql-browser-installed' do
impact 1.0
title 'check sql browser installed'
desc 'Check sql browser is installed'
describe service('SQLBrowser') do
it { should be_installed }
end
end
control 'check-report-server-installed' do
impact 1.0
title 'check report server installed'
desc 'Check report server is installed'
describe service('ReportServer') do
it { should be_installed }
it { should be_enabled }
it { should be_running }
end
end
control 'check-sql-server-agent-installed' do
impact 1.0
title 'check sql server agent installed'
desc 'Check sql server agent is installed'
describe service('SQLSERVERAGENT') do
it { should be_installed }
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment