Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Tracking user logins within the Managed Reporting Environment

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Tracking user logins within the Managed Reporting Environment
 Login/Join
 
Platinum Member
posted
I took a look through the mradmin user manual and was unable to find anything that mentioned whether or not the MRE tracks logins to the various dashboards.

Does anyone know if the MRE does this natively, or do I need to create a script that will do this for me.

I did see that within the user admin portion of the dashboard builder it provides a list of users logged in/out at the given time.

Thanks for the help.


WebFOCUS 8201M/Windows Platform
 
Posts: 109 | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
It will to be be a hand-draulic routine.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
You could turn dashboard tracing on. Unfortunately, this creates an individual file per login event, so it might be a bit cumbersome to report on.

I inadvertently discovered Dashboard tracing while on an unrelated, ESRI Mapping course.

This is all v5.3.2 so it may be improved or documented.

The URL for Java component tracing is:

http://server-name/ibi_apps/tracing.jsp

On this page there is a link for Dashboard tracing, which can be accessed independently:

http://server-name/ibi_apps/worp/jsp/trace/WORP_TraceViewer.jsp

The trace can be turned on/off and a level of tracing can be set, Fatal, Error, Warning, Info.

The files are stored here: Drive:\ibi\WebFOCUS53\worp\log and the traces look something like this:

Gen Date: Thu Sep 30 01:32:43 EDT 2004
Gen Number: 252
Gen Label: WEB53
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.logDefau  
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.logDefau  ---------------
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.logDefau  Request type: WORP_LOGIN
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.logDefau  Return type: null
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.logDefau  Session Id : NULL_SESSION
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.logDefau  ************************************
39 04/29/2008 10:31:05:112 INFO   ibi.worp.WORP_RM.doPost    isPublicUser=true
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  >>>> encryptedDataMode >>> false
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  searching for < WORP_DUAL_LOGIN > parameter/flag
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  Checking for IBIMR_returntype parameter
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  updating request headers being sent to WebFOCUS CGI
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  getting HTTP header names from request
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  searching for server environment variables
39 04/29/2008 10:31:05:112 INFO   ibi.worp.cgi.WORP_CGIComm  no server environment variables were configured -- moving on ...
39 04/29/2008 10:31:05:315 INFO   ibi.worp.cgi.WORP_CGIComm  reading return code from cgi in mrcgi format
39 04/29/2008 10:31:05:315 INFO   ibi.worp.cgi.WORP_CGIComm  Reading from WF CGI >> http://server-name:80/ibi_apps/WFServlet
39 04/29/2008 10:31:05:315 INFO   ibi.worp.cgi.WORP_CGIComm  ERROR_CODE found >> 1000
39 04/29/2008 10:31:05:315 INFO   ibi.worp.cgi.WORP_CGIComm  processing cookies >> 
39 04/29/2008 10:31:05:315 INFO   ibi.worp.WORP_SM.doPost    user francism signed on successfully
39 04/29/2008 10:31:05:330 INFO   ibi.worp.WORP_SM.doPost    worpUser=francism
39 04/29/2008 10:31:05:784 INFO   ibi.worp.cgi.WORP_CGIComm  processing cookies >> 


The line that tells you the date/time/User ID of the login:
39 04/29/2008 10:31:05:315 INFO   ibi.worp.WORP_SM.doPost    user francism signed on successfully


Then there's the Startup Parameter "MRUSERLOG", which can be turned off/on via the Admin Console. It creates one file per user on a daily or hourly basis. The rudimentary documentation states:

"Determines whether a log file of user actions is created and, if so, how frequently".

I just tried it for the first time and it logs Dashboard logins, though the content of the log file does not contain the login id, only the file name does: "mr_francism_0429_10.log", stored in Drive:\ibi\client53\wfc\web\cgi.

I hope there's something here to get you started...


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, 2005Report This Post
Expert
posted Hide Post
What is the reason for tracking logins?

Where we are we have a standard call structure for all MRE programs.

We were able to add in an include that gets the MRE User and write it to a DB, with run time, program name, etc.

The result is a set of statistics that we can report to management on the useage of the dashboard environment.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
Thank you for all your help,

I actually decided to go the handraulic route. I have created a little ajax call that fires a request to a fex that I created to store the username, time and I am hoping someone can help me figure out a way to add the actual portal they are accessing into that equation as well. Here is how I am doing it.

On each of our portals the opening page is a welcome screen. Onload of the welcome screen I fire an ajax call which easily can grab the userid and datetime. Now I find that when I run the fex from within the tree view It can find the variable &WORP_MPV.EVAL, but when I run the same fex from within an ajax call that piece is lost. Any tips on how I can handle that?

Can I somehow access this variable from within my HTML layout page?

Is there a better way?

Thanks Again


WebFOCUS 8201M/Windows Platform
 
Posts: 109 | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Tracking user logins within the Managed Reporting Environment

Copyright © 1996-2020 Information Builders