Email notification by last sync for disconnected computers on certain IP ranges.
How do I SQL query from a certain IP range for last synced computers.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
SELECT NAME, IP, LAST_SYNC FROM MACHINE WHERE IP LIKE '192.168.10%' ORDER BY LAST_SYNC DESC
SELECT NAME, IP, LAST_SYNC FROM MACHINE WHERE IP LIKE '192.168.10%' ORDER BY LAST_SYNC DESC
Please log in to answer
Posted by:
dugullett
12 years ago
I believe this is what your are wanting. Change the 192.168.10 to the range your need. If you can give me more info I'll be able to assist you more.
SELECT NAME, IP, LAST_SYNC FROM MACHINE
WHERE IP LIKE '192.168.10%'
ORDER BY LAST_SYNC DESC
Comments:
-
Thank you for the quick response. - krazyways 12 years ago
