AS/400 User Account Creation Date

DSPOBJD OBJ(userid) OBJTYPE(*USRPRF)

Enter option 5. You will see the creation date/time and who created the userid.

Mitch

Thanks, I'll try that first thing in the morning....

You wouldn't by any chance know a way to return a report of all the user accounts and their creation dates?

James

you can direct the output of DSPOBJD to a file, e.g.,:
DSPOBJD OBJ(*ALL) OBJTYPE(*USRPRF) OUTPUT(*OUTFILE) OUTFILE(LIBRARY/USERLIST)

you can then run a query to extract the fields that you want

James, Did this work for you?

Mitch

Actually it didn't work out as I had thought... the account creation date was not included in the userpref.  However, when I looked at the account using *SERVICE rather then *BASIC I was able to see a creation date... now I am just trying to write a query that will pull this creation date for all accounts.

any thoughts?

What version of the OS are you using? I have V5R3 and I see the creation date when I look at the object description. If you create a physical file using the parms that dedy gave you, you will have the creation date and time in the file.

Write a query using the new file as your input and select OBJECT, CREATION DATE, and CREATION TIME as your fields. You can sort whichever way you like. Your output will be 3 columns showing the userid along with their creation dates and times (if you need to be that specific).

Mitch, sorry for the delay...

I was able to write the query as you suggested, it returned the date that the object was created for the user account.

Thanks,

James,
Thank you for the points. Glad to help.
Mitch