updated SQL statement from NetSpot (UNE-394)