CJSmith dot me

I dump stuff I find useful here

Category: Business Objects

Check the audit on Business Objects XIR3 SP7 for logons

Published / by Chris Smith / Leave a Comment

This is useful to see who is using their licenses which are very expensive. I tend to check every few months and look at 90 days.
Its a simple count excluding the System Account and look at a date range.
I have only run this against XIR3 SP7 where auditing has been enabled on an environment running Windows and Microsoft SQL Server (Obviously it can run on almost most OS and database configs).

I have no idea where Business Objects stores the user list, so unfortunatly I can’t easily use a join to show where users havent logged in.