If you run select platform_name as OS, - client_os_level as OS_VER, - node_name as Node, - cast(cast(client_version as char(2)) || '.' - || cast(client_release as char(2)) || '.' - || cast(client_level as char(2)) || '.' - || cast(client_sublevel as char(2)) - as char(15)) as "Client" - from nodes - order by platform_name, "Client", Node
you get a listing like: OS OS_VER NODE Client ---------------- ------------------ ------------------ --------------- AIX 4.3 KOS1 5 .1 .1 .0 SCO Open Server SCO 3.2 5 BRVCVM1 3 .1 .0 .8 TDPO LinuxAMD64 2.6.9-11. BRVRAC1_ORA 5 .3 .0 .1 WinNT 5.00 BRVITS1N2 5 .1 .5 .0 HTH Thomas Rupp
