Subversion Repositories DevTools

/* Computer List */
SELECT DISTINCT lt.CLIENT_IP
  FROM LOGIN_TRAIL lt
 WHERE lt.CLIENT_IP IS NOT NULL
   AND ( /* IP address filter */
                ( lt.CLIENT_IP LIKE :CLIENT_IP          AND NOT :CLIENT_IP IS NULL )  OR
                ( lt.CLIENT_IP = lt.CLIENT_IP   AND :CLIENT_IP IS NULL ) 
           )
ORDER BY lt.CLIENT_IP