Sjeanpierre

#! /usr/bin/bash

for i in $( ls *.iso ); do
    filename=$i
    base=${filename%.*}
    echo processing $filename
    /cygdrive/c/Program\ Files\ \(x86\)/MakeMKV/makemkvcon.exe mkv iso:$filename 0 processed/
    mv processed/title00.mkv processed/$base.mkv
    echo done   
done

Sjeanpierre

Open Admin command prompt: bcdedit /set {current} safeboot minimal
Restart to BIOS and set to AHCI
Restart. Windows will boot into safe mode and will update the driver.
Open Admin command prompt: bcdedit /deletevalue {current} safeboot
Restart to boot Windows Normally.

Sjeanpierre

regionlist=($(aws ec2 describe-regions --query Regions[*].RegionName --output text))
for region in "${regionlist[@]}"
do
  aws --region $region ec2 describe-instances --output text --query 'Reservations[*].Instances[*].[Tags[?Key==`Name`] | [0].Value,PrivateIpAddress,InstanceId,State.Name,InstanceType,Placement.AvailabilityZone,LaunchTime]' --filters 'Name=tag:Name,Values=*'
done

Sjeanpierre

#!/usr/bin/env bash

set -e
echo "Waring, this script will remove chat history and prefrences from Skype for Business"
read -p "Press enter to continue"
current_user=`whoami`

#going into directory where app stuff is stored
cd /users/$current_user/library
pwd

Sjeanpierre

CREATE EXTERNAL TABLE `cf_logs`(
  `cachecachestatus` string COMMENT 'from deserializer', 
  `cacheresponsebytes` int COMMENT 'from deserializer', 
  `cacheresponsestatus` int COMMENT 'from deserializer', 
  `cachetieredfill` boolean COMMENT 'from deserializer', 
  `clientasn` int COMMENT 'from deserializer', 
  `clientcountry` string COMMENT 'from deserializer', 
  `clientdevicetype` string COMMENT 'from deserializer', 
  `clientip` string COMMENT 'from deserializer', 
  `clientipclass` string COMMENT 'from deserializer',