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.
Whenever a procedure(FEX) is invoked, a record needs to be inserted into a database table with the User Name(the user who is requesting the report) and the Report Name.
Is there any pre defined variable or function which will return the User Name.
Thanks, SanthoshThis message has been edited. Last edited by: Santhosh,
WebFOCUS 8.0.03 Unix HTML, Excel and PDF
Posts: 35 | Location: Los Angeles | Registered: April 25, 2014
This will get your user id only if you are requiring your users to sign in. If you are executing reports with a defaulted id then you will get only the defaulted id every time.
WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003
IFF you're requiring your users to sign in, and IFF you're using MRE, and IFF you've told your config.sys to pass the IBIMR_user variable. lot of IFFs.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
Originally posted by Alex: This will get your user id only if you are requiring your users to sign in. If you are executing reports with a defaulted id then you will get only the defaulted id every time.
Hi Alex,
Yes, the users need to sign in to access the reports. But still we are getting the edmadmin in the report.
For testing purpose, I ran few reports under different users and in the Workspace log it shows the appropriate user names for each requests.
Thanks, Santhosh
WebFOCUS 8.0.03 Unix HTML, Excel and PDF
Posts: 35 | Location: Los Angeles | Registered: April 25, 2014
Originally posted by susannah: IFF you're requiring your users to sign in, and IFF you're using MRE, and IFF you've told your config.sys to pass the IBIMR_user variable. lot of IFFs.
Yes, we require our users to sign in. I tested few reports from MRE. Could you help me on where I can find the config.sys file.
Or would you share some inputs If we do not wish to place our reports under MRE but still the user requires to sign in.
Thanks, Santhosh
WebFOCUS 8.0.03 Unix HTML, Excel and PDF
Posts: 35 | Location: Los Angeles | Registered: April 25, 2014
The file that contains the "Custom Settings" is Drive:\ibi\WebFOCUS77\client\wfc\etc\site.wfs.
There's a lot you can do, including the settings below. These are for v7.7.05. I'd read the Admin Console Help > WebFOCUS Online Help > WebFOCUS Administration Console > Configuration Settings.
# --- HTTP Header Variables ----------------------------------------------------
# --- Documentation: http://documentation.informati...02/wf77sec/index.htm
# --- WebFOCUS Security and Administration > Manipulating WebFOCUS Variables > HTTP Header Variables Available for Script Processing
# Specifies the authentication scheme (basic or digest) if an authorization header is supplied
<SET> AUTH_TYPE = &AUTH_TYPE (pass)
# Stores the number of bytes of data sent. For POST requests only
<SET> CONTENT_LENGTH = &CONTENT_LENGTH (pass)
# Designates the MIME type of attached data
<SET> CONTENT_TYPE = &CONTENT_TYPE (pass)
# Specifies the actual address of the host directory
<SET> DOCUMENT_ROOT = &DOCUMENT_ROOT (pass)
# Specifies the media (MIME) type the WebFOCUS Client prefers to accept, separated by commas
<SET> HTTP_ACCEPT = &HTTP_ACCEPT (pass)
# Restricts the content-codings that are acceptable in the response
<SET> HTTP_ACCEPT_ENCODING = &HTTP_ACCEPT_ENCODING (pass)
# Indicates which languages are preferred
<SET> HTTP_ACCEPT_LANGUAGE = &HTTP_ACCEPT_LANGUAGE (pass)
# Identifies the browser (or other client) making the request. It can be used to return content to different browsers
<SET> HTTP_USER_AGENT = &HTTP_USER_AGENT (pass)
# Indicates the URL of the referring Web page
<SET> HTTP_REFERER = &HTTP_REFERER (pass)
# Supplies any path information attached to the URL after the server address but before the query string
<SET> PATH_INFO = &PATH_INFO (pass)
# Value of PATH_INFO with any virtual path name expanded into a directory specification
<SET> PATH_TRANSLATED = &PATH_TRANSLATED (pass)
# Information that follows the question mark (?) in the URL
<SET> QUERY_STRING = &QUERY_STRING (pass)
# IP address of the client that made the request
<SET> REMOTE_ADDR = &REMOTE_ADDR (pass)
# Fully-qualified Domain name of the client that made the request
<SET> REMOTE_HOST = &REMOTE_HOST (pass)
# ????? – This is not documented
<SET> REMOTE_USER = &REMOTE_USER (pass)
# HTTP request method
<SET> REQUEST_METHOD = &REQUEST_METHOD (pass)
# Name of the script program being run
<SET> SCRIPT_NAME = &SCRIPT_NAME (pass)
# Server's host name or IP address
<SET> SERVER_NAME = &SERVER_NAME (pass)
# TCP/IP port on which the request was received
<SET> SERVER_PORT = &SERVER_PORT (pass)
# Name and version of the information retrieval protocol that relates to a request
<SET> SERVER_PROTOCOL = &SERVER_PROTOCOL (pass)
# Name and version of the Web server
<SET> SERVER_SOFTWARE = &SERVER_SOFTWARE (pass)
#The default URL protocol (http or https)
<SET> URL_PROTOCOL = &URL_PROTOCOL (pass)
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
Have you had any issues in WF 8 with the IBIMR_user? We can't seem to get it to recognize it. We set &USR in our reports = &IBIMR_user so when it's run in MRE we get the user info. Works great in WF7 but when we moved to WF8 it errors. Thanks Michelle
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML