Identifying Active Business Objects Users

system · July 21, 2004, 7:48pm

Hi Jenn,
Send me your email address.

di652@worldnet.att.net

toscajo (BOB member since 2002-09-04)

system · July 21, 2004, 8:58pm

Her email address is on the email button just below her sig.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · July 23, 2004, 10:06am

Toscajo, Can you also send me the scripts.
ashok_kumar_1@lycos.com

Ashokkumar (BOB member since 2004-05-20)

system · July 23, 2004, 10:15am

Other “Radical Suggestion”,

You lock all users and wait for phone call of users in anger… this ones are actives users…

more seriously, if your repository is on Oracle database, you can audit his activity to see wich user is connecting to it. I don’t remenber exactly the exact way to do it now, but i have doc about it at home if you are interested…

bernard timbal (BOB member since 2003-05-26)

system · July 23, 2004, 11:41am

Hello toscajo,

I would be interested on these Scripts too.
My Email is on the Button below

Marc Beyrich (BOB member since 2004-07-21)

system · July 23, 2004, 4:19pm

Why don’t y’all just turn on auditing and use this item in the Bob’s Downloads area to report on usage?

Cindy Clayton (BOB member since 2002-06-11)

system · July 23, 2004, 4:26pm

Cindy, I have not seen the scripts being offered up but I think they are trying to identify active/inactive FC users.

jswoboda (BOB member since 2002-06-20)

system · July 23, 2004, 4:32pm

Hmmmm. Well, auditor won’t tell you that either which is why I went with turn on auditing and use the BOB Download report.

Cindy Clayton (BOB member since 2002-06-11)

system · July 26, 2004, 6:58am

At least in 5.1.x you have no chance to identify users’s activity on the repository (if they are only full client and never connect to webi). In fact, even you do not have auditor, webi logs are available.

If they are full client users, only thing you could do is to check LAT & LAD field dor obj_m_actor record.

In this case, you could find all full client users that for example changed the password.

But for who is not changing password, you will always have the dout if they are active or not.

For sure, forcing all of them by Supervisor to change the password could give you more informations, but may be this is not the “cleanest” way to obtain the information.

Alex

alex (BOB member since 2002-08-23)

system · July 26, 2004, 3:26pm

That won’t help. Those fields are not updated when users log on. They are updated only from Supervisor when a user id is modified.

Steve Krandel (BOB member since 2002-06-25)

system · August 26, 2004, 12:14pm

Hi Toscajo.

Could you please send me the scripts too?
superbongui@hotmail.com

Thanks a lot

Angel (BOB member since 2004-08-26)

system · August 26, 2004, 3:26pm

I was interested too.
Would it be possible for you to post the scripts here so that everybody gets benefitted.
or can you please send it to my email as in my signature.

mkumar (BOB member since 2002-08-26)

system · September 2, 2004, 3:39pm

You could also do the following (works fine for me). This will give you the last connection time for anybody who connected to one of the schema of the database where the repository is.
This does not cover webi users so you have to turn on the log auditing and use some other scripts to handle webi users.
You’ll get the machine name, program name, username and logon time.
If you can deduct username’s from their machine names (I can - their machine name ends with their username) then you know who did connect to your repository using what (BO, designer, supervisor, other tools …) and see when was the last time they used it!
It also tells you which domain was accessed by which user.
It’s not perfect but it works for me!

log table:

CREATE TABLE MYBOLOG
(
  USERNAME    VARCHAR2(30),
  MACHINE     VARCHAR2(64),
  PROGRAM     VARCHAR2(48),
  LOGON_TIME  DATE
)

code for trigger:
1 - change the 2 lines “v_machine not like […]” to get rid of some non necessary lines in your log table and add any other restriction you’d want.
2 - ask your dba to run it in system.

CREATE OR REPLACE TRIGGER LOGON_AUDIT AFTER
LOGON ON DATABASE 
declare
v_machine sys.v_$session.machine%type;
v_program sys.v_$session.program%type;
v_time sys.v_$session.logon_time%type;
begin
 select machine,nvl(program,'unknown'),logon_time
 into v_machine,v_program,v_time
 from sys.v_$session a
 where logon_time=(select distinct max(logon_time) from sys.v_$session
                           where username=a.username)
and username = user
and rownum < 2;
update mybolog 
  set logon_time=v_time
 where username=user
 and machine= v_machine
 and nvl(program,'unknown')= v_program;
 if sql%rowcount=0 
  then
  insert into mybolog
  select user,v_machine,v_program,v_time
  from dual
  where v_machine not like 'WEBI_MACHINES_NAMES'
  and v_machine not like 'ORACLE_MACHINE_NAME'
  and user not in ('WEBDBA','SYSTEM','SYS');
end if;
end;

Then you can use something like this in BO to get the info you want:
(some cleaning is required in order to fix some application names … path is also probably not the same on every machine).

select distinct USERNAME, MACHINE, 'Business Objects' PROGRAM, upper(PROGRAM) PROGRAMPATH, LOGON_TIME
from mybolog
where upper(PROGRAM) like '%BUSOBJ%'
union
select USERNAME, MACHINE, 'Supervisor', upper(PROGRAM), LOGON_TIME
from mybolog
where upper(PROGRAM) like '%SUPERVISOR%' 
or upper(PROGRAM) like '%SUPERVSR%' 
union
select USERNAME, MACHINE, 'Designer', upper(PROGRAM), LOGON_TIME
from mybolog
where upper(PROGRAM) like '%DESIGNER%'
union
select USERNAME, MACHINE, 'Excel AddIn', upper(PROGRAM), LOGON_TIME
from mybolog
where upper(PROGRAM) like '%EXCEL%'
union
select USERNAME, MACHINE, 'Other', upper(PROGRAM), LOGON_TIME
from mybolog
where upper(PROGRAM) not like '%DESIGNER%'
AND upper(PROGRAM) not like '%BUSOBJ%'
AND upper(PROGRAM) not like '%SUPERVISOR%'
AND upper(PROGRAM) not like '%SUPERVSR%' 
AND upper(PROGRAM) not like '%EXCEL%'

[Edited, when posting code samples please use the code option for formatting. It will preserve any indenting or formatting that you may have done. Thank you, Andreas.]

ochomarat (BOB member since 2002-08-29)

system · September 20, 2004, 1:28pm

Toscajo I know this post is a few weeks old but please could you send me the scripts too. My email is aadaramola@ge.cokecce.com

Thanks

ayzero (BOB member since 2002-10-22)

system · September 20, 2004, 2:15pm

I saw a demo on EQM last week and they have a mechanism for tracking all users , yes even FC and Zabo (at least that was how I understood the demo).

ww.noadbi.com for specs etc. It is not a n inexpensive tool, but certainly powerful:)

Lost in the Mountains and LOVING it!!!

Charles Killam (BOB member since 2003-04-24)

system · September 20, 2004, 2:20pm

I’ve heard about this tool and would love to get it. But the powers that be have a spend freeze at the moment. (but still want an audit!)

ayzero (BOB member since 2002-10-22)

system · October 8, 2004, 5:03pm

Hi Toscajo.

Could you please send me the scripts too?
uclalli@hotmail.com

Thanks~

award (BOB member since 2004-10-08)

system · November 11, 2004, 7:50am

Hello Toscajo,

I’m very interested on these Scripts too, could you possibly send them on to me
My Email is steve.marshall@threshergroup.com

system · November 11, 2004, 11:20am

Hi Toscajo.

Could you please send me the scripts too?

michael.dudley@3valleys.co.uk

Many Thanks

MichDudl (BOB member since 2002-08-19)

system · January 4, 2005, 5:31pm

Hi Toscajo.

I know this is already an old post, but i’d like the scripts also.

Thanks!

Charlie

diego.denolf@gmail.com

charlie_bel (BOB member since 2005-01-04)

Identifying Active Business Objects Users

log table:

code for trigger: 1 - change the 2 lines “v_machine not like […]” to get rid of some non necessary lines in your log table and add any other restriction you’d want. 2 - ask your dba to run it in system.

code for trigger:
1 - change the 2 lines “v_machine not like […]” to get rid of some non necessary lines in your log table and add any other restriction you’d want.
2 - ask your dba to run it in system.