Public/Get-OSDDriverWmiQ.ps1
|
<#
.SYNOPSIS Returns a Computer Model WMI Query that can be used in Task Sequences .DESCRIPTION Returns a Computer Model WMI Query that can be used in Task Sequences .LINK https://osd.osdeploy.com/module/functions/get-osddriverwmiq .NOTES 19.12.6 David Segura @SeguraOSD #> function Get-OSDDriverWmiQ { [CmdletBinding()] Param ( [Parameter(ValueFromPipeline = $true)] [Object[]]$InputObject, #Select a Computer Manufacturer [Parameter(Mandatory)] [ValidateSet ('Dell','HP')] [string]$Make = 'Dell', #Select whether the Query is based off Model or SystemId SystemSku Product [Parameter(Mandatory)] [ValidateSet ('Model','SystemId')] [string]$Result, #Open a Text File with the WMI Query after completion [switch]$ShowTextFile ) Begin { #====================================================================================================== # Information #====================================================================================================== Write-Verbose 'Get-OSDDriverWmiQ: Results are saved in the Global Variable $GetOSDDriverWmiQ for this PowerShell session' $OSDComputerModels = @() $OSDModelPacks = @() } PROCESS { if ($InputObject) { $OSDModelPacks += $InputObject $OSDComputerModels = foreach ($ModelPack in $OSDModelPacks) { foreach ($item in $ModelPack.Model) { $ObjectProperties = @{ Model = $item } New-Object -TypeName PSObject -Property $ObjectProperties } } } else { $OSDModelPacks = @() if ($Make -eq 'Dell'){$OSDModelPacks = Get-OSDDriver DellModel | Sort-Object Model -Unique} if ($Make -eq 'Hp'){$OSDModelPacks = Get-OSDDriver HpModel | Sort-Object Model -Unique} $OSDModelPacks = $OSDModelPacks | Select-Object Make, Model, Generation, SystemSku | Out-GridView -PassThru -Title 'Select Computer Models to Generate a WMI Query' } } END { $Items = @() #=================================================================================================== # Model #=================================================================================================== if ($Result -eq 'Model') { foreach ($Item in $OSDModelPacks.Model) {$Items += $Item} $Items = $Items | Sort-Object -Unique $WmiQueryFullName = Join-Path -Path $env:TEMP -ChildPath "WmiQuery.txt" $WmiCodeString = [System.Text.StringBuilder]::new() [void]$WmiCodeString.AppendLine('SELECT Model FROM Win32_ComputerSystem WHERE') foreach ($Item in $Items) { [void]$WmiCodeString.AppendLine("Model = '$($Item)'") if ($Item -eq $Items[-1]){ #"last item in array is $Item" } else { [void]$WmiCodeString.Append('OR ') } } $WmiCodeString.ToString() | Out-File -FilePath $WmiQueryFullName -Encoding UTF8 if ($ShowTextFile.IsPresent) { notepad.exe $WmiQueryFullName } $global:GetOSDDriverWmiQ = $WmiCodeString.ToString() Return $global:GetOSDDriverWmiQ } #=================================================================================================== # Dell SystemId #=================================================================================================== if ($Result -eq 'SystemId' -and $Make -eq 'Dell') { foreach ($Item in $OSDModelPacks.SystemSku) {$Items += $Item} $Items = $Items | Sort-Object -Unique $WmiQueryFullName = Join-Path -Path $env:TEMP -ChildPath "WmiQuery.txt" $WmiCodeString = [System.Text.StringBuilder]::new() [void]$WmiCodeString.AppendLine('SELECT SystemSku FROM Win32_ComputerSystem WHERE') foreach ($Item in $Items) { [void]$WmiCodeString.AppendLine("SystemSku = '$($Item)'") if ($Item -eq $Items[-1]){ #"last item in array is $Item" } else { [void]$WmiCodeString.Append('OR ') } } $WmiCodeString.ToString() | Out-File -FilePath $WmiQueryFullName -Encoding UTF8 if ($ShowTextFile.IsPresent) { notepad.exe $WmiQueryFullName } Return $WmiCodeString.ToString() } #=================================================================================================== # HP SystemId #=================================================================================================== if ($Result -eq 'SystemId' -and $Make -eq 'HP') { Write-Verbose "HP SystemId" -Verbose foreach ($Item in $OSDModelPacks.SystemSku) {$Items += $Item} $Items = $Items | Sort-Object -Unique $WmiQueryFullName = Join-Path -Path $env:TEMP -ChildPath "WmiQuery.txt" $WmiCodeString = [System.Text.StringBuilder]::new() [void]$WmiCodeString.AppendLine('SELECT Product FROM Win32_BaseBoard WHERE') foreach ($Item in $Items) { [void]$WmiCodeString.AppendLine("Product = '$($Item)'") if ($Item -eq $Items[-1]){ #"last item in array is $Item" } else { [void]$WmiCodeString.Append('OR ') } } $WmiCodeString.ToString() | Out-File -FilePath $WmiQueryFullName -Encoding UTF8 if ($ShowTextFile.IsPresent) { notepad.exe $WmiQueryFullName } $global:GetOSDDriverWmiQ = $WmiCodeString.ToString() Return $global:GetOSDDriverWmiQ } } } |