amitrogye

var SubststitutionHelper = Class.create();
SubststitutionHelper.prototype = {
    initialize: function(record) {
    	this.log = new GSLog("intuit.custom.debug.level", this.type);
    	this.record = record;
    	// preload variables for request item
    	this.variables = {};
    	if(this.record.getTableName() == 'sc_req_item'){
    		this.preloadVariables();
    	}

hunterowens

import pymssql
import pandas as pd

## instance a python db connection object- same form as psycopg2/python-mysql drivers also
conn = pymssql.connect(server="172.0.0.1", user="howens",password="some_fake_password", port=63642)  # You can lookup the port number inside SQL server. 

## Hey Look, college data
stmt = "SELECT * FROM AlumniMirror..someTable"
# Excute Query here
df = pd.read_sql(stmt,conn)

Sam-Martin

Replace yourdomain with your service now URL. User must have the rest_service role.

groue

// This sample code shows how to use GRDB to synchronize a database table
// with a JSON payload. We use as few SQL queries as possible:
//
// - Only one SELECT query.
// - One query per insert, delete, and update.
// - Useless UPDATE statements are avoided.

import Foundation
import GRDB

icerge

Watch out performance of your queries!

var sw = new GlideStopWatch();  
var recGR = new GlideRecord('cmdb_ci');  
recGR.addQuery('sys_class_name', 'INSTANCEOF', 'cmdb_ci_server');  
recGR.addQuery('name', 'ABCDEF');  
recGR.setLimit(1);  
recGR.query();  
if (recGR.hasNext()) { 

e0x70i

<#
Ported to powershell2 from script by Laurent Kempé 
http://laurentkempe.com/2016/04/07/Upload-files-to-DropBox-from-PowerShell/

.SYNOPSIS
This is a Powershell script to upload a file to DropBox using their REST API.

.DESCRIPTION
This Powershell script will upload file to DropBox using their REST API with the parameters you provide.

angelo-v

# will not work in all cases, see https://gist.github.com/angelo-v/e0208a18d455e2e6ea3c40ad637aac53#gistcomment-3439904

function jwt-decode() {
  sed 's/\./\n/g' <<< $(cut -d. -f1,2 <<< $1) | base64 --decode | jq
}

JWT=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiYWRtaW4iOnRydWV9.TJVA95OrM7E2cBab30RMHrHDcEfxjoYZgeFONFh7HgQ

jwt-decode $JWT

thisnameissoclever

/*
	Script Include definition:
		Name: JournalRedactor
		Client Callable: false
		Accessible from: All application scopes
	Additional details: 
		Version: 1.3
		Usage documentation: http://redactor.snc.guru/
		License: https://gist.github.com/thisnameissoclever/767b8a738b929a0bd943965431061c1e
*/

dsample

# EditorConfig is awesome: http://EditorConfig.org

# top-most EditorConfig file
root = true

# Unix-style newlines with a newline ending every file
[*]
charset = utf-8
indent_style = space
indent_size = 2

Neo23x0

Base64 Patterns - Learning Aid

Base64 Code	Mnemonic Aid	Decoded*	Description
JAB	🗣 Jabber	$.	Variable declaration (UTF-16), e.g. JABlAG4AdgA for $env:
TVq	📺 Television	MZ	MZ header
SUVY	🚙 SUV	IEX	PowerShell Invoke Expression
SQBFAF	🐣 Squab favorite	I.E.	PowerShell Invoke Expression (UTF-16)
SQBuAH	🐣 Squab uahhh	I.n.	PowerShell Invoke string (UTF-16) e.g. Invoke-Mimikatz
PAA	💪 "Pah!"	<.	Often used by Emotet (UTF-16)