Hello,
Question about a sql-query to get IP-addresses from client-nodes associated
with a schedule:
select substr(A1.ADDRESS,1,posstr(address,':')-1) as IP_address,A1.entity as
Name from summary A1, nodes A2 where A1.entity=A2.node_name AND node_name in
(select node_name
from ASSOCIATIONS) AND start_time>timestamp(concat('2002-11-26',' 07:00'))
order by IP_address ASC
Query gives output like this:
IP_ADDRESS NAME
------------------ ------------------
1xx.25.141.20 NT_A
1xx.25.141.21 AIX_Z
1xx.25.141.5 AIX_B
1xx.25.141.6 NT_X
1xx.25.141.7 NT_D
1xx.25.141.8 W2K_F
1xx.25.141.9 W2K_G
1xx.25.143.118 W2K_A
1xx.25.143.21 AIX_S
1xx.25.143.22 AIX_M
1xx.25.143.23 NT_K
I would like to order by IP-address on last octet of IP-address, like
sequence 5, 6, 7, 8, 9, 20 and so on and not like 20, 21, 5, 6, 7
Is there someone who can give me a hint?
Any tip is welcome.
Thanx,
Brian.
_________________________________________________________________
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
