user reports

The creation date and last modified date are stored in your LDAP. We report off from that for audit purposes. We use the AVAAP security dashboard to pull the LDAP info and push it into a oracle database that we can report off from. I have a report that shows me the user name, create date, last modified date.

I would start with an LDAP browser or if you need a report you can dump that data or create a smart note to the LDAP. That might be a good place to start. Just depends on the tools at your disposal.

With great hopes I looked at several users inside LDAP thinking that the creation date would be stored there. The createTimeStamp was consistently empty, and in many cases that was the only "creation" type of entry. It seems to depend on your version of the Lawson environment, but in other cases I found these attached to user resources:

whenChanged 20100521190425.0Z
whenCreated 20100219195554.0Z

Do you have a way to extract LDAP data?

Best regards,
Dave
(303) 773-3535

I don't have a way to extract LDAP data.

But I will start looking into now.

thanks

If you don't already have it, JXplorer is a wonderful free tool for browsing LDAP:

http://jxplorer.org/downloads/users.html

With that, you'll see lwsnrmdata as one of the branches. Click on that to see all of the users defined. Click on any of them to see all of their attributes in the window on the right.

You can "dump" the lwsnrmdata branch into an LDIF format text file (a menu option at the top of JXplorer), although that can be rather challenging to parse through. If the creation dates exist in LDAP, though, they'll be in that LDIF file.

Best regards,
Dave

In addition to the LDAP browser (Jexplorer or Softera are the ones I've used) you can also create a smart note to pull the LDAP info then dump to excel or another tool to analyze. If screens shots would help with that I can pull some together quickly for you.

Thanks everyone. I was able to retrieve the info from LDAP and I have submitted the info to our auditors

thanks

Jay