If you want to know all agents connected to Siebel database, just run
select count(*) from v$session where username not in ('SADMIN, any other system login ids) and program = 'siebel.exe'
And to get the list of active users in a specific timeline,
The column LAST_LOGIN_TS on the table S_USER shows the last time a user
logged into the system. You should be able to create a simple query to
get a list of all users that last logged into the system in a certain date range.
select distinct(LOGIN) from siebel.s_user where last_login_ts > '01-May-2015'
[su_divider style=”dotted”]
@skmeSiebel