How To: Avoid "Duplicated Device" When Running One Query

Version 7

    Problem

     

    When we create one query then run this query to list the devices those can match the query, but the device list will include multiple duplicated devices, please refer to below screenshot:

     

    query2.PNG

     

     

    Cause

     

    If choosing the queried field as display column, this column will list all the queried data with device name, so there will be multiple duplicated device name in the list

     

    Solution / Workaround

     

    Remove the queried field in the display column, just only leaving device name in the display column,The less display column, the result will be more accurate.

     

    query1.PNG

     

    NoduplicateDeviceID.PNG