Pasted

############################################################
############################################################
### 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
 
}