I have created a query for a specific software package. When I run the query I see multiple lines for several, but not all the workstations listed. I have selected several columns of data I need output from this query. I do see differences in the lines for the duplicated device names. My question is how do I identify the cause for the duplicates and how do I get accurate data from the query?
I got a same problem! The query result is duplicate device by get a ip address (0.0.0.0) as attach file.
Do you found a method to solve this problem? OR Is there any suggesion? Please share to me.
image001.jpg 195.5 K
I have found this is typically caused by the items (columns) you are bringing back in the query. Make sure the machine component looks for the software you are specifically looking for. Also, if you have multiple lines per device, look at which of the columns have differences and start looking there how you can prevent the differences you aren't looking for. Like specifying a version number.