QueryBuilder Query for last logon via specified Authentication Method?

[#1]

Is there a query I can run via querybuilder, or some other report/tool maybe, that will give me the last logon date/time for a user that is broken down by Authentication Method? This would be for a user who has both a secWinAD alias and a secEnterprise alias. I want to know when the last time was that they logged in with either. Maybe that's something I can get form the support tool and I didn't look hard enough? Thanks!

-Missy

[Former Member]

Hm, I guess though there might be something 'quick and easy' from querybuilder because when you go into CMC > Sessions, it has the auth:username in the Username field... I'm actually just trying to see how many users are still using their AD log in and how many have started using their Enterprise account as requested, since we are phasing AD out for our BO instance.

[DellSC]

There's no way to do this in QueryBuilder. Any given user can have multiple "aliases" - one for each authentication type that uses the same user id. BOBJ doesn't track what time of authentication was used in the last login.

As Denis mentioned, you may be able to find this info in the audit database.

-Dell

[BasicTek]

auditing should have logon info but we found that for 3rd party since the logon occurs directly to the 3rd party (LDAP/AD/SAP), the 3rd party auditing is a better tool to keep track of it. In the BI audit logs (unless it's changed) all logons are just account logons not necessarily ent, AD, LDAP , SAP, etc

There might be a way to capture that but I haven't played too much with our auditing DB, however I do know that any 3rd party you are using in your case AD has it's own audit logs on the DC's that will have a record of all successful logons...

-Tim

[denis_konovalov]

Auditing ?