BusinessObjects Board

User Last Logon time by Universe

other Auditor
#1

Hi All,

I am currently using BI 4.2 version. I am looking to find User Name and last logon time of the user only for my specific universe. I have found a query to get all users and last logon time.

SELECT SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS WHERE SI_KIND = ‘user’ and SI_LASTLOGONTIME>‘2017.01.01’

How ever this query works on all enterprise users, but not specific to my universe. Could you please suggest how can i restrict this query to any particular universe.

I have audit universe disabled due to performance issues. I can’t use Audit universe. I can only use Query Builder.

Please suggest.

Thanks

NIHAL2010 (BOB member since 2018-03-16)

#2

Well, you’re out of luck. There is no concept of a logon by universe.

With Audit data, you would be able to look for the last Refresh event by user, by universe. But that is not stored in the CMS.

Joe

joepeters :us: (BOB member since 2002-08-29)

#3

Welcome to B:bob:B!

Feel free to ask us about your audit universe performance issues…

Nick Daniels :uk: (BOB member since 2002-08-15)