SQL*Plus Question

This should be easy but...

I'm trying to get a list from v$session of users logged in more than once with the same username but on different machines.

I can do:

select logon_time, username, osuser, machine, count(1) from v$session group by logon_time,username, osuser, machine having count(1) > 1

but this will only give me one line per user. I need to see the same username, etc for say "JSMITH" 3 times if he's logged in three times on different machines...

I'd like to exclude rows where the user is logged on twice on the same machine.

Many thanks,

Ed. Received on Thu Jun 08 2006 - 08:13:55 CDT