DOORS User Last Login

It would be pretty useful if there was a way to know when a user last logged into DOORS for admins looking after large user lists.

I don't think there is is there?

I guess parsing the whole database for module sessions belonging to the user would be a very slow workaround option.


DoorsXLAustralia - Thu Jun 04 03:23:18 EDT 2015

Re: DOORS User Last Login
smarti.sj - Thu Jun 04 12:06:47 EDT 2015

This is really a DXL question - you can write a script to process the User login file located on the database server \\doorsXXdata\v6data\logs\login_history.txt. Mike Sutherland (http://www.galactic-solutions.com/GalacticDownloads.htm)did have an old version out there - bet you could tweak it for the new history format fairly easily to get it to work.  When you merge the history file with the database user list it will show the last login in a sortable column - quite well done!

Good Luck

Re: DOORS User Last Login
DoorsXLAustralia - Thu Jun 04 20:38:05 EDT 2015

Thanks SJ,

It does sound like a clever solution.

Unfortunately in a Defence security IT environment there is no access to the server file-system which is managed by an infrastructure provider.

Would be great if there were some DXL perms to make some basic queries on login_history.txt so Administrator user can get some info through some DXL scripts.

Sean

Re: DOORS User Last Login
smarti.sj - Fri Jun 05 12:33:35 EDT 2015

DoorsXLAustralia - Thu Jun 04 20:38:05 EDT 2015

Thanks SJ,

It does sound like a clever solution.

Unfortunately in a Defence security IT environment there is no access to the server file-system which is managed by an infrastructure provider.

Would be great if there were some DXL perms to make some basic queries on login_history.txt so Administrator user can get some info through some DXL scripts.

Sean

I totally agree - should be a tool provided feature!  You can try an enhancement request.  I generally don't have access to the server either - I regularly put in an IT request for a copy of the file.