Focal Point
User Usage Question

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/329104525

September 10, 2010, 03:32 PM
smoss
User Usage Question
Is there a way within the tools to see when a user signed on last?


WebFOCUS 7.7.03M
OS/400 and the client is Win7
September 13, 2010, 05:27 AM
GamP
When you have Resource Analyser active - no problemo.
If not, and if you do not have any other means of logging activity, I don't think there is anything (other than maybe the OS logging) that can tell you that.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 13, 2010, 05:51 AM
FrankDutch
There is a way but not an easy on.

On the server you will find a directory something like...\worp\worp_users\...

Thss holds for each user a subdirectory
In that directory you should find 5 or 6 xml files. Those files are used to build the personal dashboard for that user.
One of the files is named RECENT.XML
The date and time stamp of that file is the date and time the user has logged on for the last time.
You should be able to read this directory structure (some basic dir commands) put that info in a file, and create a report based on that info.
This will however only give you the LAST time a user has logged on, and won't give any info about how many times a user was logged on.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 13, 2010, 06:19 AM
GamP
Frank - this works, but ONLY if you have you system set up for using dashboards and nothing else. If you're not using dashboards but you do use mre, then this method will not work because there is nothing in the worp directories.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 15, 2010, 08:44 AM
smoss
Yeah, I have those files, but the date doesnt seemed to be updated. I just access the DB and nothing on that file changed.


WebFOCUS 7.7.03M
OS/400 and the client is Win7
September 15, 2010, 10:35 AM
FrankDutch
Maybe only accessing the dashboard is not enough
you may need to run a report first.
But I would not be interested in users that only log on and do not do anything.
(maybe there boss is interested in that though...)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 15, 2010, 11:48 AM
smoss
quote:
Originally posted by FrankDutch:
Maybe only accessing the dashboard is not enough
you may need to run a report first.
But I would not be interested in users that only log on and do not do anything.
(maybe there boss is interested in that though...)


yeah i ran the report too...still nothing Frowner


WebFOCUS 7.7.03M
OS/400 and the client is Win7
September 15, 2010, 03:38 PM
Arif
quote:
Hide Post
Frank - this works, but ONLY if you have you system set up for using dashboards and nothing else. If you're not using dashboards but you do use mre, then this method will not work because there is nothing in the worp directories.

I am interested in finding out about this also. I would like to write a report to distribute to my manager to see when the user was logged on last using the dashboard.
So, there is no log, DB table or file that has user last login information? Maybe you should submit a New feature request. I will do the same.


WebFOCUS 7.6.10
Windows
HTML
September 16, 2010, 10:28 AM
CLH
You may also want to try Resource Analyzer it does capture this information. Though it is an added charge.


Webfocus 8.0.7 on Windows