Subversion Repositories DevTools

Rev

Rev 2 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* Computer List */
2 
SELECT DISTINCT lt.CLIENT_IP
3 
  FROM LOGIN_TRAIL lt
4 
 WHERE lt.CLIENT_IP IS NOT NULL
5 
   AND ( /* IP address filter */
6 
 	   	( lt.CLIENT_IP LIKE :CLIENT_IP  	AND NOT :CLIENT_IP IS NULL )  OR
7 
		( lt.CLIENT_IP = lt.CLIENT_IP  	AND :CLIENT_IP IS NULL )
8 
 	   )
9 
ORDER BY lt.CLIENT_IP