Compare SQL table to array

Hi guys

I wonder if any of you good folks can help me please?

I have a SQL query that fills a table:

            $DataAdapter = new-object System.Data.SqlClient.SqlDataAdapter 
            $DataAdapter.SelectCommand = $PrinterSelectCmd
            $dataset = new-object System.Data.Dataset
            $PrinterXmlFile = $dataset.Tables[0] 

I then also have an array that has the locally installed printer information

$printer = Get-WmiObject Win32_Printer

Is there a quick, easy way to compare if any of the values in $PrinterXmlFile (eg the sharename) against $Printer, if they aren’t in $printer to then build a new list based on the objects that arent in $printer?

Many thanks


No. You’re going to need to construct custom objects from each, so that you’re comparing apples to apples, in which case Compare-Object can do it.