How do I SQL query from a certain IP range for last synced computers.

Answer Summary:
SELECT NAME, IP, LAST_SYNC FROM MACHINE WHERE IP LIKE '192.168.10%' ORDER BY LAST_SYNC DESC
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

3

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
Answered 07/27/2012 by: dugullett
Red Belt

  • Thank you for the quick response.
Please log in to comment
Answer this question or Comment on this question for clarity