Compare SQL table to array

This topic contains 1 reply, has 2 voices, and was last updated by Profile photo of Don Jones Don Jones 8 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #34246
    Profile photo of Barry Walledge
    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
    Profile photo of Don Jones
    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.