Skip to content

Instantly share code, notes, and snippets.

@sshastri
sshastri / sqlserver.pp
Last active March 31, 2018 02:49
Use sqlserver module to execute SQL commands
class profile::app::sqlserver {
$version = '1.45'
sqlserver_instance{ 'MSSQLSERVER':
features => ['SQL'],
source => 'C:/setup',
sql_sysadmin_accounts => [$facts['id']],
}
@sshastri
sshastri / foo_status.rb
Last active May 25, 2017 04:09
Custom fact
Facter.add (:rhsm_deleted) do
confine :kernel => 'Linux'
setcode do
identity_output = Facter::Core::Execution.exec("cat /tmp/foo")
if identity_output.include?('not yet registered')
'not_registered'
elsif identity_output.include?('deleted')
'deleted'
@sshastri
sshastri / chk_used_classes.rb
Created January 26, 2017 01:38
Compare PuppetDB with code base to find used classes
#!/opt/puppetlabs/puppet/bin/ruby
# Script to compare the classes applied by queerying the PuppetDB
# versus all the classes defined in a provided module path
#
# Command to run:
# /opt/puppetlabs/puppet/bin/ruby chk_used_classes.rb <module_path> <input_file>
#
# Arguments:
# @param module_path (required): Ex: /etc/puppetlabs/code/environments/production