How to get count of all concurrent logged in Users in Siebel ?

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

Leave a Reply

Your email address will not be published. Required fields are marked *