Details |
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
|