DOORs Usage Report

I'm needing to pull a report on who logged into DOORS and how many times in 30 / 60 / 90 days.  Is there such a thing built in, or is there a log file that I can dig through to get what I need?  My users login via the client as well as DWA.

Re: DOORs Usage Report
Martin_Hunter - Tue Jan 14 05:49:19 EST 2014

The log file you are after is license.log.

LMTOOLS should help you find the path to the debug log file.

Take a look on the DXL forum for some tools to analyse this file.

- Martin

Re: DOORs Usage Report
llandale - Wed Jan 15 11:50:29 EST 2014

The License Log file is better than my suggestion below as there exist tools to display summary information.  But unfortunately it

• doesn't tell you which database the supplied DOORS license was used.  So if there are more than one DOORS database you cannot tell which was which.
• Tells you the system user who requested the license, not the DOORS user name

There is a DOORS login history file which records successful and failed login attempts.  It is stored inside the database and is not accessible via DXL.  However, you can have a scheduled task on the DOORS server that copies it to where DXL (running on clients) can see the copy:

This Windows command works:

• C:\\WINDOWS\\system32\\cmd.exe /c \"copy /V /Y \"c:\\Doors-Data\\v93-Data\\v6data\\logs\\login_history.txt\" \"c:\\Doors-Data\\v93-Data\\conf\\u1000001.dir\\" c_NameHistoryFile "\"
   

Presumably that will run 12:01am every day.  Your DXL would read the file (..err.. the copy):

• ConfStream cs = confRead(c_NameHistoryFile, confSystem)

Parsing that file is very difficult.

Seems to me you could change database options to not log failed attempts.

-Louie