Skip to Content

finding AD login attempts for CMC BI launch pad

using BI platform 4.1 with AD authentication. I want to be able to track failed and succesfull logins via Active directory to both the CMC and BI Launchpad. Using the audit database with the query (or something similar) below i can find succesfull logins to the CMC but not the bi launchpad. How do i find the successfull and failed logins for both? Is there a way in the biplatform / audit database to track the ip address of the logins as well?

select a.user_name, a.user_id, a.start_time, a.duration_ms, e.Status_ID, e.Status_Name


dbo.ADS_EVENT a left outer join dbo.ADS_STATUS_STR e on a.status_id=e.status_id and a.event_type_id=e.event_type_id and e.language='en'

where Status_Name like '%Log%' and a.User_ID <> '0'

thanks for any help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 10, 2014 at 07:18 PM

    Do you have the Audit universe with Crystal reports? Check the reports under' IP Addresses - Logon Events' folder.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.