AshFlaw

## Install-Choco.ps1
Function Install-Choco
{
    Set-ExecutionPolicy Bypass -force
    If (!(Test-Path -Path "C:\ProgramData\chocolatey"))
    {
      $env:chocolateyUseWindowsCompression = 'false'
      Invoke-WebRequest https://chocolatey.org/install.ps1 -UseBasicParsing | Invoke-Expression
      choco feature enable -n=allowGlobalConfirmation
    }
}

## Get-StaleADComputers.ps1
$duration = (Get-Date).AddDays(-365)
Get-ADComputer -Filter {LastLogonDate -lt $duration} | Select-Object Name, LastLogonDate | Sort-Object Name

## Set-SQLShinkAllLogFiles.sql
SET NOCOUNT ON
USE master
GO
/*
 * Update usage statistics. Not a necessary step
 * but will provide more accurate results
 */
DBCC UPDATEUSAGE(0)

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL

## Set-SQLInstanceAllDBLogFileSettings.ps1
Function Set-SQLLogFileSizeAndGrowth
{
  Param
  (
    $Instance
  )
  Import-Module dbatools -ErrorAction SilentlyContinue
  If ((Get-Module | Where-Object {$_.Name -eq "dbatools"}) -eq $null)
  {
    Write-Output "Installing required module: $dbatools"

## Invoke-RemoteVolumeExpand.ps1
Function Invoke-RemoteVolumeExpand
{
    Param
    (
        $Server
    )
    Function Invoke-VolumeExpand
    {
        $Include     = "C|W|D|E|F"
        $Partitions = Get-Partition | Where-Object {$_.DriveLetter -Match $Include}

## ChangeYourADPassword.ps1
$AccountName = ""
Set-AdAccountPassword -Identity $AccountName -OldPassword (Read-Host -asSecureString "Current password") -NewPassword (Read-Host -asSecureString "New password")

## LogOffRemoteServer.ps1
logoff /server:remote_computer_name

## CredentialObjectOneLine.ps1
$Credential = New-Object System.Management.Automation.PSCredential 'username',(convertto-securestring 'password' -asplaintext -force)

## Get-AvailableRAM.ps1
$Server = ""
(Get-Counter -Counter "\Memory\Available MBytes" -ComputerName $Server).CounterSamples[0].CookedValue

## Set-EolMailBoxAuditEnabledAll.ps1
Get-Mailbox -Filter {AuditEnabled -eq $False} -RecipientTypeDetails UserMailbox, SharedMailbox | Set-Mailbox -AuditEnabled $True –AuditDelegate Create, FolderBind, SendAs, SendOnBehalf, SoftDelete, HardDelete, Update, Move, MoveToDeletedItems, UpdateFolderPermissions
	Function Install-Choco
	{
	Set-ExecutionPolicy Bypass -force
	If (!(Test-Path -Path "C:\ProgramData\chocolatey"))
	{
	$env:chocolateyUseWindowsCompression = 'false'
	Invoke-WebRequest https://chocolatey.org/install.ps1 -UseBasicParsing \| Invoke-Expression
	choco feature enable -n=allowGlobalConfirmation
	}
	}
	$duration = (Get-Date).AddDays(-365)
	Get-ADComputer -Filter {LastLogonDate -lt $duration} \| Select-Object Name, LastLogonDate \| Sort-Object Name
	SET NOCOUNT ON
	USE master
	GO
	/*
	* Update usage statistics. Not a necessary step
	* but will provide more accurate results
	*/
	DBCC UPDATEUSAGE(0)

	IF OBJECT_ID('tempdb..#tmp') IS NOT NULL
	Function Set-SQLLogFileSizeAndGrowth
	{
	Param
	(
	$Instance
	)
	Import-Module dbatools -ErrorAction SilentlyContinue
	If ((Get-Module \| Where-Object {$_.Name -eq "dbatools"}) -eq $null)
	{
	Write-Output "Installing required module: $dbatools"
	Function Invoke-RemoteVolumeExpand
	{
	Param
	(
	$Server
	)
	Function Invoke-VolumeExpand
	{
	$Include = "C\|W\|D\|E\|F"
	$Partitions = Get-Partition \| Where-Object {$_.DriveLetter -Match $Include}
	$AccountName = ""
	Set-AdAccountPassword -Identity $AccountName -OldPassword (Read-Host -asSecureString "Current password") -NewPassword (Read-Host -asSecureString "New password")
	$Server = ""
	(Get-Counter -Counter "\Memory\Available MBytes" -ComputerName $Server).CounterSamples[0].CookedValue