Alex Richards ajtrichards

## scan-list-of-aws-ips.sh
aws ec2 describe-network-interfaces --query NetworkInterfaces\[\].Association.PublicIp | jq -r '.[]' | xargs -I{} nmap -v -A -sV {}

## lumen-query-log.php
/**
 * You must enable to Query Log when using Lumen.
 */
DB::connection()->enableQueryLog();

$queries 	= DB::getQueryLog();
$last_query = end($queries);

## laravel-eloquent-dump-sql.php
<?php

$builder = MyModel::where('active', 1);

$query = str_replace(array('?'), array('\'%s\''), $builder->toSql());
$query = vsprintf($query, $query->getBindings());

dd($query);

## exchange-o365-set-calendar-permissions.ps1
pwsh -Command 'Install-Module -Name PSWSMan'
pwsh -Command 'Install-Module -Name ExchangeOnlineManagement'

sudo pwsh -Command 'Install-WSMan'

Connect-ExchangeOnline -UserPrincipalName YOUR_EMAIL_ADDRESS

foreach($user in Get-Mailbox -RecipientTypeDetails UserMailbox) {
  $cal = $user.alias+":\calendar"
  write-host $cal
	/**
	* You must enable to Query Log when using Lumen.
	*/
	DB::connection()->enableQueryLog();

	$queries = DB::getQueryLog();
	$last_query = end($queries);
	<?php

	$builder = MyModel::where('active', 1);

	$query = str_replace(array('?'), array('\'%s\''), $builder->toSql());
	$query = vsprintf($query, $query->getBindings());

	dd($query);
	pwsh -Command 'Install-Module -Name PSWSMan'
	pwsh -Command 'Install-Module -Name ExchangeOnlineManagement'

	sudo pwsh -Command 'Install-WSMan'

	Connect-ExchangeOnline -UserPrincipalName YOUR_EMAIL_ADDRESS

	foreach($user in Get-Mailbox -RecipientTypeDetails UserMailbox) {
	$cal = $user.alias+":\calendar"
	write-host $cal