to a list of Webi, Interactive, and Infovoew users

We need help to list it down the all Webi, Interactive, and Infovoew users (separated) When they last used the application.

Can this be done? eigther by using Query Builder? or Auditing Universe…if yes, kindly help us with query.

Using XI R2.


Rao70 (BOB member since 2010-04-06)

If you are using the query builder you will get the defined info within the CMS. If you are looking for user activity you must use the auditor database.

LAST_LOGIN_TIME is useful to see when users last logged in


Leong BO XI (BOB member since 2007-08-09)

I don’t think you can differentiate whether the user is in interactive mode or not. You can find out who logs in when and did what by using the Activity Universe against the Auditing schema.


substring :us: (BOB member since 2004-01-16)

Thank you so much for all your help…


Rao70 (BOB member since 2010-04-06)