Is there a way to audit user accounts by last login date/time?

[Former Member]

Hello all,

Is there a way to see or report on a user's last login. I don't see a last login date parameter in the UM record. I see that all security events are logged in the security log including logon and logoff, but what I need is to be able to produce a report that provides all user accounts which have not been logged on to since a specified date or # of days, i.e. since 01/01/2008 or >180 days.

Any clues or guidance is appreciated.

Regards,

Paul

[Former Member]

What is your Data Source in Portal?

[Former Member]

We use Active Directory as the data source for users. We have looked at last login date in the active directory, but there seem to be discrepancies. We are not certain that the last login date field in Active Directory is being updated when a user logs directly into the portal from outside our corporate network - i.e., without authenticating on the network first.

We are currently on EP6.0 SP17.

[Former Member]

The answer may lie with your DB server for the portal, what are you using?

[Former Member]

Sorry, I should have included that. We are using Oracle 10.2.02 on Solaris 5.8.

Thanks.

Edited by: Paul Larsen on Jul 25, 2008 8:57 PM

[Former Member]

I am using MSSQL. There are some UME and WCR tables that hold that info. As for what you are using, there might be a table that hold the same data.

[Former Member]

Is there a SAP / Portal standard way of accessing this information?

Our authorisations team have asked me to get them such a report, and I can't find anything on the portal (NW2004) that would give this information. I don't think the basis guys would be terribly chuffed to provide access directly to the database. If this (database access) is the only way, then I suppose a custom developed app could be created and deployed to the portal, but I would have thought this is a reasonalby sensible report so would be standard content somewhere.

Cheers,

Andrew