Vista - How check local Queues in a If

Hello

I have problems with check local queues. I have a db with queues.

1. Check local system of. Is queue exist. when not create this part don't
function.

Where is the error? Do you have a idea?

Thanks for you help

Thanks
Gregor

#SQL Connection aufbauen
$conn = new-object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = "server=hsb592as;database=PrintMgmt;integrated
security=true"
$cmd = new-object System.Data.SqlClient.SqlCommand("spCreateQueue", $conn)
$cmd.CommandType = [System.Data.CommandType]'StoredProcedure'
$cmd.Parameters.Add("@PrintServerName",$env:COMPUTERNAME)
$cmd.Connection = $conn
$adapter = new-object System.Data.SqlClient.SqlDataAdapter
$adapter.SelectCommand = $cmd
$ds = new-object System.Data.DataSet
$adapter.Fill($ds)
$conn.close()

#DataTable erstellen
$dt = new-object "System.Data.DataTable" "dtData"
$dt = $ds.Tables[0]
$dt | FOREACH-OBJECT {

$PrintSRV = $_.PrintServer
$PrintSRVShort = $_.PrintServerShort
$QueueTemplate = $_.QueueTemplate
$QueueName = $_.Printername+'_'+$_.QueueName
$PrinterName = $_.PrinterName
$PrinterPortDomain = '.bkw-fmb.ch'
$PrinterPort = $_.PrinterName+'.bkw-fmb.ch'
$UNCName = '\\'+$_.PrintServer+'\'+$_.QueueName
$Url = 'http://'+$_.PrintServer+'/'+$_.QueueName
$Location = $_.Location
#$Description = 'Kommentar Feld'
$FilterPPort = "Name = '$PrinterPort'"
$FilterQueue = "Name = '$_.QueueName'"
$RegFile = $_.QueueRegFile

#Add PrinterPort
$colItemPrinterPort = get-WmiObject -class
"Win32_TCPIPPrinterPort" -namespace "root\CIMV2" -computername
$env:COMPUTERNAME -Filter $FilterPPort | foreach {$_.name}
If ($colItemPrinterPort -eq $PrinterPort)
{
write-Host = "Port exist" $PrinterPort
}
else
{
#Create PrinterPort
cmd /c start /wait Cscript c:\Windows\System32\Prnport.vbs -a -s
$env:COMPUTERNAME -r $PrinterPort -h $PrinterPort -me -y public -o raw -n
9100
write-Host = "Port created" $PrinterPort
}

1. >>>>>>>>>>>>>>>>>>>

$colItemQueue = get-WmiObject -class "Win32_Printer" -namespace
"root\CIMV2" -computername $env:COMPUTERNAME -Filter $FilterQueue |
foreach {$_.name}

if ($colItemQueue -eq $QueueName)
{
Write-Host = "Queue "$QueueName" exist"
}
else
{
Write-Host = "Queue "$QueueName" create"
....
}

If I follow, I would try doing this:
cmd /c start /wait "Cscript c:\Windows\System32\Prnport.vbs -a -s
$env:COMPUTERNAME -r $PrinterPort -h $PrinterPort -me -y public -o raw
-n 9100"

The variables you are declaring are likely not being passed to the
VBScript script.

Also, it is not:
write-host = "something"
but instead
write-host "something"

Marco


--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

Hello Marco

My problem is:

$colItemQueue = get-WmiObject -class "Win32_Printer" -namespace
"root\CIMV2" -computername $env:COMPUTERNAME -Filter $FilterQueue |
foreach {$_.name}

if ($colItemQueue -eq $QueueName)
{
Write-Host = "Queue "$QueueName" exist"
}
else
{
Write-Host = "Queue "$QueueName" create"
....
}

"Marco Shaw [MVP]" <marco.shaw@_NO_SPAM_gmail.com> wrote in message
news:ehcpwjwbIHA.4712@xxxxxx

1. for local computers -computername parameter is not needed
2. "root\CIMV2" is the default WMI namespace, you can remove it
3. You can't do Write-Host = "something", and there are also double quotes
errors.

Try this:

$colItemQueue = get-WmiObject -class "Win32_Printer" -namespace -Filter $FilterQueue
| where {$_.name -eq $QueueName}

if ($colItemQueue){
Write-Host "Queue $QueueName exist"
}
else
{
Write-Host "Queue $QueueName create"
....
}



-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com

Gregor wrote:I think I follow now, try doing this instead:

$colItemQueue = get-WmiObject -class "Win32_Printer" -namespace
"root\CIMV2" -computername $env:COMPUTERNAME -Filter $FilterQueue

if ($colItemQueue -ne $null)
{
Write-Host = "Queue "$QueueName" exist"
}
else
{
Write-Host = "Queue "$QueueName" create"
....
}