Creation date of a user

[Wim Van den Wyngaert]

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

[Bart Zorn_1]

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]

Bart,

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

Wim

[Volker Halle]

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]

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]

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

[John Gillings]

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.

[Thomas Ritter]

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]

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

[Jan van den Ende]

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