New-WEMConfiguration.ps1
|
<#
.Synopsis Create a new Configuration object in the WEM Database. .Description Create a new Configuration object in the WEM Database. .Link https://msfreaks.wordpress.com .Parameter Name .. .Parameter Description .. .Parameter Connection .. .Example .Notes Author: Arjan Mensch #> function New-WEMConfiguration { [CmdletBinding()] param( [Parameter(Mandatory=$True,ValueFromPipeline=$True, ValueFromPipelineByPropertyName=$True)] [string]$Name, [Parameter(Mandatory=$False)][AllowEmptyString()] [string]$Description, [Parameter(Mandatory=$True)] [System.Data.SqlClient.SqlConnection]$Connection ) process { Write-Verbose "Working with database version $($script:databaseVersion)" # escape possible query breakers $Name = ConvertTo-StringEscaped $Name $Description = ConvertTo-StringEscaped $Description # check if there's already a configuration with that name $SQLQuery = "SELECT COUNT(*) AS ObjectCount FROM VUEMSites WHERE Name LIKE '$($Name)'" $result = Invoke-SQL -Connection $Connection -Query $SQLQuery if ($result.Tables.Rows.ObjectCount) { # name must be unique Write-Error "There's already a Configuration object named '$($Name)'" Break } Write-Verbose "Name is unique: Continue" # build and execute Insert query $SQLQuery = "INSERT INTO VUEMSites ({0}) VALUES ({1})" -f $configurationSettings[$script:databaseSchema].SiteFields, ($configurationSettings[$script:databaseSchema].SiteValues -f $Name, $Description) $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # grab the ID from the newly created record $objectSite = Get-WEMConfiguration -Connection $Connection -Name "$($Name)" $IdSite = $objectSite.IdSite # fill other tables with defaults after adding the Site record # VUEMParameters $SQLQuery = ("INSERT INTO VUEMParameters ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].ParametersFields, ($configurationSettings[$script:databaseSchema].ParametersValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMAgentSettings $SQLQuery = ("INSERT INTO VUEMAgentSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].AgentSettingsFields, ($configurationSettings[$script:databaseSchema].AgentSettingsValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMSystemUtilities $SQLQuery = ("INSERT INTO VUEMSystemUtilities ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].SystemUtilitiesFields, ($configurationSettings[$script:databaseSchema].SystemUtilitiesValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMEnvironmentalSettings $SQLQuery = ("INSERT INTO VUEMEnvironmentalSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].EnvironmentalFields, ($configurationSettings[$script:databaseSchema].EnvironmentalValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMUPMSettings $SQLQuery = ("INSERT INTO VUEMUPMSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].UPMFields, ($configurationSettings[$script:databaseSchema].UPMValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMPersonaSettings $SQLQuery = ("INSERT INTO VUEMPersonaSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].PersonaFields, ($configurationSettings[$script:databaseSchema].PersonaValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMUSVSettings $SQLQuery = ("INSERT INTO VUEMUSVSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].USVFields, ($configurationSettings[$script:databaseSchema].USVValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMKioskSettings $SQLQuery = ("INSERT INTO VUEMKioskSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].KioskFields, ($configurationSettings[$script:databaseSchema].KioskValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # VUEMSystemMonitoringSettings $SQLQuery = ("INSERT INTO VUEMSystemMonitoringSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].SystemMonitoringFields, ($configurationSettings[$script:databaseSchema].SystemMonitoringValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # AppLockerSettings if ($configurationSettings[$script:databaseSchema].AppLockerFields) { $SQLQuery = ("INSERT INTO AppLockerSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].AppLockerFields, ($configurationSettings[$script:databaseSchema].AppLockerValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery } # GroupPolicyGlobalSettings if ($configurationSettings[$script:databaseSchema].GroupPolicyGlobalSettingsFields) { $SQLQuery = ("INSERT INTO GroupPolicyGlobalSettings ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].GroupPolicyGlobalSettingsFields, ($configurationSettings[$script:databaseSchema].GroupPolicyGlobalSettingsValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery } # VUEMItems $SQLQuery = ("INSERT INTO VUEMItems ({0}) VALUES {1}" -f $configurationSettings[$script:databaseSchema].ItemsFields, ($configurationSettings[$script:databaseSchema].ItemsValues -join ", ")) -f $IdSite $null = Invoke-SQL -Connection $Connection -Query $SQLQuery # Updating the ChangeLog New-ChangesLogEntry -Connection $Connection -IdSite -1 -IdElement $IdSite -ChangeType "Create" -ObjectName $Name -ObjectType "Global\Site" -NewValue "N/A" -ChangeDescription $null -Reserved01 $null # Return the new object Get-WEMConfiguration -Connection $Connection -IdSite $IdSite } } |