Pass parameter into function

Question

I'm trying to pass each value in an array through a function. This is what I have:

#Pulls a list of computers from SCCM
$sccmComputers = Get-ComputersCollection -CollectionName "All Desktops" 

#Function to check each item in $sccmComputers against a database.
Function CheckDisposal ($pc){
$check = invoke-sqlcmd2 -ServerInstance shopserv-lr -Database inventory -query "SELECT * FROM Computers WHERE ServiceTag = '$pc' and Status = 'Disposed' "
return $check}

foreach ($pc in $sccmComputers)
{

}

I can't seem to figure out how to get each of the items from $sccmComputers to pass through the function and if returns true output the value to the console.

Below is the code that worked for me:

Function CheckDisposal ($a){
$check = invoke-sqlcmd2 -ServerInstance shopserv-lr -Database inventory -query "SELECT * FROM Computers WHERE Name = '$a' and Status = 'Disposed'"
return $check
}


$sccmComputers = Get-ComputersCollection -CollectionName "All Desktops"


foreach($item in $sccmComputers)
{

  $dispose = CheckDisposal $item.Name
  if($dispose)
  {
    Write-Output $dispose.Name
  }
}

well, call your function inside foreach loop? – 4c74356b41 Mar 01 '17 at 19:42 — 4c74356b41, Mar 01 '17 at 19:42

score 0 · Accepted Answer · answered Mar 01 '17 at 19:51

0

foreach ($pc in $sccmComputers)
{
    CheckDisposal $pc
}

answered Mar 01 '17 at 19:51

Mark Wragg

22,105
7
39
68

If the query finds $pc in the database how can I get that to output to the console? – Matthew Mar 01 '17 at 20:57
My assumption is that it gets returned when you do Return $check – Mark Wragg Mar 01 '17 at 20:59
What happens currently if you run your code with the modification above? – Mark Wragg Mar 01 '17 at 21:38
1

Nothing would happen. I ended up figuring out the problem though. I've edited my question with the correct code. Thanks for your help. – Matthew Mar 02 '17 at 21:22
FYI it's perfectly valid to submit an answer to your own question and accept it :). – Mark Wragg Mar 02 '17 at 21:24

Pass parameter into function

1 Answers1