Want to track user activity

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

WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE

Posts: 285 | Location: Texas | Registered: June 27, 2006

Ignored post by Sayed posted

Show Post

Francis Mariani

Expert

posted

Hide Post

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

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

dhagen

Virtuoso

posted

Hide Post

Check this

"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott

Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004

Ignored post by dhagen posted

Show Post