The reason you see duplicates in the console is because of the columns your showing. So if you were to query off of IP address and then show that column in your column sets then every computer that has more than 1 IP address would show up more times. So if you create a query but then only show the column for computer name and OS then you shouldn't see any duplicates. It's when you start adding the other columns that the computer shows up more than once.
Thanks much. I eliminated two columns that were specific to what was being looked for and that did the trick