ScheduledTask-ClusterCreation.ps1

############################################################
############################################################
### The following script is called from Scheduled task with the action "provision-storage-2016.ps1 cluster01.blah.com"
############################################################

Start-Transcript -Append -Path e:\temp\transcript.txt

# Import MySQL Driver and Connect to DB

    Import-Module -Name C:\windows\system32\WindowsPowerShell\v1.0\Modules\MySQL\MySql.Data.dll

    $ConnectionString = “Server=localhost;uid=blah; pwd=blah;Database=database;”
    $MySQLConnection = New-Object -TypeName MySql.Data.MySqlClient.MySqlConnection
    $MySQLConnection.ConnectionString = $ConnectionString
    $MySQLConnection.Open()

    # Grab most recent pending provision

        # Build Query

        $query = "SELECT * FROM table WHERE pending=1 ORDER BY date ASC LIMIT 0,1"

        # Execute Query

        $command     = New-Object MySql.Data.MySqlClient.MySqlCommand($query, $MySQLConnection)
        $dataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($command)


        # Query to Array

        $table = new-object system.data.datatable
        $dataAdapter.Fill($table)



    # Execute the provision

        # Connect and Enter Remote Session Context

            $psuser = "domain\user"
            $pspassword = ConvertTo-SecureString "password" -AsPlainText -Force
            $cred = new-object -typename System.Management.Automation.PSCredential -argumentlist $psuser, $pspassword

            New-PSSession -ComputerName $args[0] -Credential $cred
            Enter-PSSession -ComputerName $args[0]


        $argumentlist = @($table.username),@($table.password),@($table.provisionstring),@($table.storagepool),@($table.sizeinbytes),@($table.clustergroup)
        $argumentlist | Out-File -Append -FilePath e:\temp\args.txt
        invoke-command -computername @($table.cluster) -FilePath "E:\provision-scripts\provision-smb3-share.ps1" -ArgumentList $argumentlist



############################################################
############################################################
NOW THIS FILE IS THE PORTION THAT CREATES A MOUNTPOINT, CREATES AN NTFS VOLUME, AND ADDS THE RESOURCE TO THE "file server" cluster group
############################################################

# Inputs
param(
    [Parameter(Mandatory=$true,Position=1)]
    [string]$username,
    [Parameter(Mandatory=$true,Position=2)]
    [string]$randpass,
    [Parameter(Mandatory=$true,Position=3)]
    [string]$provisionstring,
    [Parameter(Mandatory=$true,Position=4)]
    [string]$storagepoolfriendlyname,
    [Parameter(Mandatory=$true,Position=5)]
    [string]$volumesizeinbytes,
    [Parameter(Mandatory=$true,Position=6)]
    [string]$clustergroup
)

# New User
    NET USER $username $randpass /ADD /DOMAIN /Y

try{

# New Directory to Mount New Volume to
    $mountpoint = "M:\" + $provisionstring
    New-Item -Path $mountpoint –ItemType Directory

# New Volume
    new-volume -StoragePoolFriendlyName $storagepoolfriendlyname -friendlyname $provisionstring -FileSystem NTFS -ResiliencySettingName Parity -PhysicalDiskRedundancy 2 -ProvisioningType Fixed -Size $volumesizeinbytes -AccessPath $mountpoint -Verbose

# Turn Off Maintenance Mode
    #resume-clusterresource -Name "Cluster Virtual Disk (" + $provisionstring + ")"

# Attach Volume to File Server Role
    $fsrole = Get-ClusterGroup | Where { $_.Name -eq $clustergroup}
    #write-host "Cluster Group: " + $fsrole
    $clresource = Get-ClusterResource | where {$_.OwnerGroup -eq "Available Storage" -and $_.Name -eq "Cluster Virtual Disk (" + $provisionstring + ")"}
    #$clresource | Out-File -FilePath m:\provision\output.txt
    #write-host "Cluster Resource: " + $clresource
    Move-ClusterResource -Name $clresource -Group $fsrole

# New SMB3 Share
    New-SmbShare -Name $provisionstring -Path $mountpoint -ScopeName $clustergroup -CachingMode None -ChangeAccess $username -ContinuouslyAvailable $true -Description $provisionstring -EncryptData $true -FolderEnumerationMode AccessBased -FullAccess "Domain Admins" -Confirm
}
Catch {

#whatever

}