ionred

USE CommonDB
GO
/*
USER DEFINED FUNCTION: getColumnNames
USE: PRIVATE/INTERNAL
AUTHOR: BDC 10/9/23
DESCRIPTION: This function returns a comma-separated list of column names for a given table and schema.
PARAMETERS:
- @schemaName: the name of the schema where the table is located.
- @tableName: the name of the table to retrieve column names from.

ionred

# Description: Basic App Install
# Author: BC 2022-10-02
#
# Install boxstarter:
# 	. { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# 	Install-BoxstarterPackage -PackageName <URL-TO-RAW-GIST> -Credential (Get-Credential)

ionred

# Description: Boxstarter Script
# Author: Jess Frazelle <[email protected]>
# Last Updated: 2019-10-27 BC
#
# Install boxstarter:
# 	. { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:

ionred

Title: Update-AUPackages Time: 2025-03-05 16:00 AU version: 2022.10.24 AU packages: 3 LAST RUN HAD 3 errors !!!

Finished 3 packages after .11 minutes.
0 updated, 0 pushed, 0 ignored
3 errors - 3 update, 0 push.

ionred

gatewayip=192.168.2.1
rm routeListtemp > /dev/null 2>&1
rm amazonCIDR > /dev/null 2>&1
rm routeList > /dev/null 2>&1
rm netflixip > /dev/null 2>&1
rm netflixCIDR > /dev/null 2>&1
rm arinunclean > /dev/null 2>&1
rm arinCIDR > /dev/null 2>&1
#cycle 3 times to make sure we get a good set of A records, Amazon ELB (Netflix host) only gives 8 a records per lookup
echo -en "Getting Netflix IP's from DNS Lookups...\t\t\t\t\t"