Enable_vAccs.ps1

#Creates .SQL file with content inside
$sqlEnable = "SET QUOTED_IDENTIFIER ON;
`r`nGO `r`nUPDATE [User]`r`nSET Info.modify('replace value of (User/LastSelectedCredentialState/text())[1] with `"ACCESSSTATUS_ACTIVE`"') `r`nWHERE Name ='TycoAdmin';`r`nGO" 
$Desktop = "C:\Users\[redacted]\Desktop\" #Working directory
$hostname = hostname #MAR0123LPCC
$PCTest = $hostname.subString(7,4) #Tests for LPCS or LPCC
$hostTrim = $hostname -replace ".{4}$" #Removes "LPCS" from hostname
$lpcc = $hostTrim + "LPCC" #Used to enable [redacted] remotely
$sqlName = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances #Gets SQL instance name

#Message box
Add-Type -AssemblyName PresentationCore,PresentationFramework
$ButtonType = [System.Windows.MessageBoxButton]::OK
$MessageboxTitle = "License check failed"
$Messageboxbody = "$hostname is not licensed for use. Run script on other machine"
$MessageIcon = [System.Windows.MessageBoxImage]::ERROR

#Sets license directory location
if ($PCTest -eq "LPCS"){
    $licenseDIR = "E:\Program Files\Genetec Security Center\ConfigurationFiles\license.gconfig" #LPCS
}else{
    $licenseDIR = "E:\Program Files (x86)\Genetec Security Center 5.2\ConfigurationFiles\license.gconfig" #LPCC
}

#Loads license.config and sets node to check
[xml]$XmlDocument = Get-Content -Path $licenseDIR
$TestedLicense = $XmlDocument.configuration.Licensing.License

#If license is null, alert to go to other hostname
#Prevents users from activating tycoadmin on a non licensed system
if ($TestedLicense -eq $null){
[System.Windows.MessageBox]::Show($Messageboxbody,$MessageboxTitle,$ButtonType,$messageicon)
Remove-Item -LiteralPath $MyInvocation.MyCommand.Path -Force
exit
}

#Test for LPCC vs LPCS to activate [redacted]
if ($PCTest -eq "LPCC"){
    net user [redacted] /active:yes #Activate [redacted] locally
}else{
    net user [redacted] /active:yes
    WMIC /node:$lpcc process call create “cmd.exe /c net user [redacted] /active:yes” #remotely enable [redacted] from LPCS
}

#Creates .SQL file
New-Item -Path $Desktop -Name "Enable_[redacted].sql" -ItemType "file" -Value $($sqlEnable) 


#Test SQL Instance name
#When Instance name is SQLEXPRESS, have to use .\SQLEXPRESS
#When Instance name is MSSQLSERVER, have to use .\
#Loads SQL server instance and runs .sql content

if($sqlName = "MSSQLSERVER"){
        SQLCMD -S .\ -d Directory -i C:\Users\[redacted]\Desktop\Enable_[redacted].sql
}else{
        SQLCMD -S .\$sqlName -d Directory -i C:\Users\[redacted]\Desktop\Enable_[redacted].sql
}


#Changes to working directory
cd $Desktop

#Delete .sql file + .ps1 script
Remove-Item .\Enable_[redacted].sql
Remove-Item -LiteralPath $MyInvocation.MyCommand.Path -Force
logoff