Compare SQL table to array

This topic contains 1 reply, has 2 voices, and was last updated by  Don Jones 1 year, 7 months ago.

  • Author
    Posts
  • #34246

    Barry Walledge
    Participant

    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
    $DataAdapter.Fill($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

    Barry

  • #34263

    Don Jones
    Keymaster

    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.

You must be logged in to reply to this topic.