HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Creation date of a user

 
Wim Van den Wyngaert
Honored Contributor

Creation date of a user

Is there a way for finding the creation date of a user ? I can find it in audit but is there an (undocumented) feature that is easier to use ? If possible, also the modification date.

Wim
Wim
10 REPLIES
Bart Zorn_1
Trusted Contributor

Re: Creation date of a user

Wim,

Generally, if you create a user, you also create his/her home directory. This directory's creation date gives an indication of the account creation time. Of course this is anything but water tight.

As for account modifications, I am afraid that the Audit server is your only friend!

Regards,

Bart
Wim Van den Wyngaert
Honored Contributor

Re: Creation date of a user

Bart,

Bad luck. Our user share their home directory (applic from 1974).

Wim
Wim
Volker Halle
Honored Contributor

Re: Creation date of a user

Wim,

a 'user' only exists in the UAF. The only fields in the UAF, which are capable of holding a date/time value, can be found with:

$ sea sys$library:lib.req uaf$q_

and there is no definition for a creation or modification date.

You could 'guess' the creation date by the creation date of the user's home directory.

Volker.
Volker Halle
Honored Contributor

Re: Creation date of a user

Wim,

an applic from 1974 on VMS ? Did you migrate the disks from RSX ?

According to the VAX Timeline page:

http://h18002.www1.hp.com/alphaserver/vax/timeline/

the VAX architecture committee has met for the first time in April 1975.

Volker.
Wim Van den Wyngaert
Honored Contributor

Re: Creation date of a user

It came from PDP. A few years after the birth of DSM they started using it. The last team member that started the application is now going to retire ...

Wim
Wim
John Gillings
Honored Contributor

Re: Creation date of a user

Obviously way too late after the fact, but if there is anything important to you that you want to record about your users, and isn't already in the UAF (like user creation date), you can store it in the user data field.

It's a counted ASCII field (up to 255 characters). You can store anything that will fit.

See UAI$_USER_DATA for $GETUAI and $SETUAI.
A crucible of informative mistakes
Thomas Ritter
Respected Contributor

Re: Creation date of a user

User creation dates...very topical for us at the moment given the liftime of the systems. For management reporting purposes we produce a daily report of new users added to the system. We wrote a C program using RMS to read the sysuaf and produce a .CSV output file of all users in alphabetical order. Comparing two reports one can see additions or removals. Our business rules do not allow userid removals. Because the files are in a CSV format, support staff can massage using Excel. This is the real trick. We tend to find non-technical staff have lots of enthusiasm for studing these type of reports. We have made it a practise over the years to CSV just about anything useful.
Wim Van den Wyngaert
Honored Contributor

Re: Creation date of a user

My primary use of the date was finding recently created users.

We keep audit files for 180 days and have "athorization audit" active.

$anal/audit/sel=subtype=sysuaf_add/full/out=xx dev:[dir]*sec*.*
$sea xx "user record"

will give all users added in the last 180 days.

SOX will have to live with that.

Wim
Wim
Jan van den Ende
Honored Contributor

Re: Creation date of a user

Wim,

we also have the information (for years already), but not from SYSUAF.
Our Personnel System (not on VMS :-( ) is defined LEADING for all purposes. Any modifications are uesed to uodate SYSUAF, and full (and condensed) reports of that are produced.

.. but it is entirely tailor-made for our purposes.

just our EUR 0,02

Proost.

Have one on me.

jpe
Don't rust yours pelled jacker to fine doll missed aches.
Ian Miller.
Honored Contributor

Re: Creation date of a user

I would use the audit log. (you should have Authorization logging enabld in auditing). You can look at the audit file(s) online or restore old ones from backups and look at those. It is a common requirement to keep audit logs for a while (a year or more).
____________________
Purely Personal Opinion