Is there a way to track the last time a user logged in to the dashboard module?

Hi Suzanne,

I do not know if tracking users logging into dashboard is valueable. We are more concerned with what reports the user is running. What parameter he/she is passing and what data is retrieved. All that is being done through a standard include module and then stored back in database.

Thanks,
Sayed

You could do what Sayed suggests, but here is a way to determine the last time a user logged in to Dashboard.

Every login attempt (including those with invalid User ID's or Passwords) creates a log file, usually in Drive:\ibi\WebFOCUS53\worp\log, so using APP commands and an IBI supplied master (FOCAPPQ.MAS) you can create a list of these log files.

You can create a fex of this code, put it in an APP folder, changing the location of the WORP log folder and run it. (This may not work if the WF server is not on the same machine as the client).

-*-- Print a report of the last time a User logged in to WF Dashboard ----------
-*-- (Based on platform independent method of listing files in a directory)
-*-- By Francis Mariani - 2007/04/05

-SET &ECHO=ALL;

-SET &DATADIR = 'D:\ibi\WebFOCUS53\worp\log';

APP MAP TEMPAPP1 &DATADIR
-RUN

APP QUERY TEMPAPP1 HOLD
-RUN

?FF FOCAPPQ
-RUN

DEFINE FILE FOCAPPQ
USER_ID/A24     = GETTOK(FILENAME, 256, 1, '_', 24, 'A24');
LOGIN_DT/A8YYMD = GETTOK(FILENAME, 256, 2, '_', 8, 'A8');
LOGIN_TM1/A6    = GETTOK(FILENAME, 256, 3, '_', 6, 'A6');
LOGIN_TM/A8     = EDIT(LOGIN_TM1,'99:99:99');
END
-RUN

TABLE FILE FOCAPPQ
SUM
LOGIN_TM
BY USER_ID
BY HIGHEST 1 LOGIN_DT
WHERE RECORDLIMIT EQ 5000
END
-RUN