gmirsky

use role accountadmin;
use warehouse systemadmin_wh;
use database qa_mdm_db;
--
WITH filtered_queries AS (
    SELECT
        query_id,
        query_text AS original_query_text,
        -- First, we remove comments enclosed by /* <comment text> */
        REGEXP_REPLACE(query_text, '(/\*.*\*/)') AS _cleaned_query_text,

gmirsky

import sys as sys
import logging as logging
import platform as platform
import boto3 as boto3
import argparse as argparse
import requests as requests
from botocore.exceptions import ClientError

logger = logging.getLogger(__name__)

gmirsky

#Inventory-RT53-Zone-Records.ps1
#Get a Full List of all records from all RT53 Zones, OR only for a targeted Zone set by Variable
#Also can get list for a single targeted Record Type, example TXT, MX etc
# ****** This WILL NOT export any records with "_domainkey" in the Name (url) for security reasons.
#Version: 1.5
#Tested with Windows Powershell: 5.1, 7.0.3
#Tested with MacOS PowerShell : 7.0.3
#Date 10/23/2020
#Modified 8/03/2022
#Created: Ed Walsh

gmirsky

Keybase proof

I hereby claim:

• I am gmirsky on github.
• I am vanapagan (https://keybase.io/vanapagan) on keybase.
• I have a public key ASBjua-PhTAUtm8VOq70I_UYHE1NbI6ev52cXkjrfPmf1Qo

To claim this, I am signing this object:

gmirsky

use role accountadmin;
--
-- create warehouse ddl
--
show warehouses;
--
CREATE temporary TABLE temp_warehouses as SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
--
select 'CREATE OR REPLACE WAREHOUSE ' || t."name" || '\n' ||			
' INITIALLY_SUSPENDED = TRUE \n' ||			

gmirsky

use role accountadmin;
--
show users;
--
CREATE temporary TABLE temp_users as SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
--
select 'CREATE USER ' || t."name" || '\n' ||
' PASSWORD=' || '''Ch@ng3MeN0W!''' || '\n' || 
' COMMENT = ' || '''' ||
case 

gmirsky

select current_user();
select current_available_roles();

gmirsky

import ldap3
import json

server_password='Passw0rds123!'
server_ip='172.16.10.50'

server = ldap3.Server(
    server_ip,
    port=636,
    use_ssl=True

gmirsky

import pandas as pd
import openpyxl
from openpyxl import load_workbook

workbook_name = './MyExcelWorkBook.xlsx'
chars_to_remove = [
    '+',
    '&',
    '(',
    ')',

gmirsky

#!/usr/local/bin/bash
XXX=$(aws ec2 describe-instances \
    --filters "Name=tag-key,Values=Name" \
    --query 'Reservations[*].Instances[*].{Instance:InstanceId, Type:InstanceType, Platform:Platform, Volumes:BlockDeviceMappings[*].Ebs.VolumeId, NetworkInterfaces:PrivateIpAddress,AZ:Placement.AvailabilityZone, Name:Tags[?Key==`Name`]|[0].Value}' \
    --output json)

echo "$XXX" > xxx.json