Skip to content

Instantly share code, notes, and snippets.

View wilpig's full-sized avatar

Wilbur Longwisch wilpig

View GitHub Profile
- name: LTM Configuration Management A Devices
hosts: all
connection: local
gather_facts: false
# strategy: free
vars:
provider:
server: "{{ inventory_hostname }}"
user: "{{ f5svc_username }}"
password: "{{ f5svc_password }}"
- name: LTM Configuration Management A Devices
hosts: all
connection: local
gather_facts: false
# strategy: free
vars:
provider:
server: "{{ inventory_hostname }}"
user: "{{ f5svc_username }}"
password: "{{ f5svc_password }}"
#!/bin/bash
# hack to stop patching
#grep "release\ 5" /etc/redhat-release
#if [ $? -eq 1 ]; then
# echo -e "Patching has been suspended until fixes from Redhat have been found the the NFS issue introduced with the start of patching on RHEL6 and the flurry of fixes has stopped for RHEL7.\n\nWe will contact everyone via email once we have a timetable for the changes."
# exit 1;
#fi
grep -q "release\ 8" /etc/redhat-release
#!/bin/bash
countries=('unitedkingdom' 'usa' 'canada' 'mexico');
countrycode=('gb' 'us' 'ca' 'mx');
len="${#countries[@]}"
#Download zones
for ((i=0; i<${len}; i++ ));
do
#!/bin/bash
# An enhanced stateful firewall for a workstation, laptop or router that
# isn't running any network services like a web server, SMTP server, ftp
# server, etc.
# change this to the name of the interface that provides your "uplink"
# (connection to the Internet)
UPLINK="eth0"
- hosts: all
gather_facts: yes
vars:
ad_user: samiam
ad_pass: samspassword
tasks:
- name: Copy EPEL8 GPG Key
copy:
src: 'files/etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-8'
---
extends: default
rules:
braces:
level: warning
max-spaces-inside: 1
brackets:
level: warning
# Use this to install elasticsearch
#
# Optional Parameters:
#
#
#
# USAGE EXAMPLES
#
# Simple
#
10.in-addr.arpa. 600 IN SOA ns0.vumc.org. dns-admin.vumc.org. 2553545296 10800 3600 2419200 900
10.in-addr.arpa. 600 IN SOA ns0.vumc.org. dns-admin.vumc.org. 2553545296 10800 3600 2419200 900
10.in-addr.arpa. 600 IN SOA ns0.vumc.org. dns-admin.vumc.org. 2553545296 10800 3600 2419200 900
9.134.100.10.in-addr.arpa. 600 IN PTR img1023wp.hs.it.vumc.io.
100.136.100.10.in-addr.arpa. 600 IN PTR adm1001lp.hs.it.vumc.io.
194.208.100.10.in-addr.arpa. 600 IN PTR ces1001wp.hs.it.vumc.io.
197.208.100.10.in-addr.arpa. 600 IN PTR ces1004wp.hs.it.vumc.io.
198.208.100.10.in-addr.arpa. 600 IN PTR ces1005wp.hs.it.vumc.io.
200.208.100.10.in-addr.arpa. 600 IN PTR ces1007wp.hs.it.vumc.io.
203.208.100.10.in-addr.arpa. 600 IN PTR ces1010wp.hs.it.vumc.io.
@wilpig
wilpig / pivot table
Last active March 23, 2017 01:47
SQL for a pivot table to join the custom attributes to the primary device row.
SET @sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'MAX(IF(AttributeID = ''',
AttributeID,
''', Value, NULL)) AS ',
Label
)
) INTO @sql