cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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

0 Likes
View Entire Topic
BasicTek
Product and Topic Expert
Product and Topic Expert
0 Likes

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