mtellin

-- Show files
SELECT name, physical_name AS current_file_location,(size *8) /1024 AS size_MB
FROM sys.master_files

-- Good data
SELECT * FROM AdventureWorks2014.Sales.SalesPersonQuotaHistory;

-- Uh oh....
DELETE FROM AdventureWorks2014.Sales.SalesPersonQuotaHistory;

mtellin

#!/usr/bin/env python3
# Script to check Culver's and alert when it's bonfire smores
import requests
import os
from bs4 import BeautifulSoup

# Set environment variables for the following items
slackToken = os.environ['SLACK_TOKEN']
culversLogo = os.environ['CULVERS_LOGO']
city = os.environ['CULVERS_CITY']

mtellin

import requests
import os
from bs4 import BeautifulSoup

# Set environment variables for the following items
slackToken = os.environ['SLACK_TOKEN']
kvdbId = os.environ['KVDB_ID']
rcloneLogo = os.environ['RCLONE_LOGO']

# Pull the rClone page and use BeautifulSoup to parse

mtellin

#!/usr/bin/env python3
rubrik_server = "10.0.11.14"
rubrik_user = "admin"
rubrik_pass = "password"

import requests

session = requests.post('https://{}/api/v1/session'.format(rubrik_server), verify = False, auth =(rubrik_user,rubrik_pass))
session_token = session.json()
authorization = 'Bearer ' + session_token['token']

mtellin

# This will return the list of NSX Security Groups that are backed by Active Directory Groups for you to review
Get-NsxSecurityGroup | Where {$_.InnerXml -like "*DirectoryGroup*"}

# Alternatively, to also remove the security groups as part of the command 
# Note: you will be prompted to confirm the group(s) it finds
Get-NsxSecurityGroup | Where {$_.InnerXml -like "*DirectoryGroup*"} | Remove-NsxSecurityGroup

mtellin

Infrastructure Queries

• Show current problems within the monitored environment
  problem

• Show list of changes within the monitored environment
  change

• See which Controller is responsible for each VNI
  controller of vxlan group by controller

mtellin

# --------------------------------------------------
# 
# Mike Tellinghuisen
# 2017-04-10
# Loop through NSX non-Universal IP Sets and create
# Universal IP sets from them. Non-Universal IP sets
# are not removed during this script.
#
# --------------------------------------------------