Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Infor / Lawson Platforms
S3 Security
user reports
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
362
Members:
0
Total:
362
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Security
user reports
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Jay2
Veteran Member
Posts: 84
6/18/2010 12:40 PM
Does Lawson store the user creation date somewhere?
I need a user report with date the user was created.
Any ideas??
mark.cook
Veteran Member
Posts: 444
6/18/2010 12:57 PM
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.
Dave Amen
Veteran Member
Posts: 75
6/18/2010 1:07 PM
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
Jay2
Veteran Member
Posts: 84
6/18/2010 1:27 PM
I don't have a way to extract LDAP data.
But I will start looking into now.
thanks
Dave Amen
Veteran Member
Posts: 75
6/18/2010 1:40 PM
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
mark.cook
Veteran Member
Posts: 444
6/18/2010 2:02 PM
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.
Jay2
Veteran Member
Posts: 84
7/22/2010 12:50 PM
Thanks everyone. I was able to retrieve the info from LDAP and I have submitted the info to our auditors
thanks
Jay
You are not authorized to post a reply.