Does anyone has idea as what needs to be set up to populate column "SMCONNID" in SMQUERY table?
As of now space is appearing in this field hence my smuserid is also null.
Regards, NituThis message has been edited. Last edited by: Nitu Jain,
April 18, 2006, 11:44 AM
Tony A
Nitu,
The SMUSERID is dependant upon some GKE commands being sent to the server. I would suggest that you contact your local support for indepth information.
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
February 11, 2009, 03:23 AM
arvind
hi ,
Whats the difference between SMUSERID AND SMCONNID. I dont want to see the report usage of certain IDs who are developers, So i put ther WHERE NE condition in SMUSERID. but when i print the data why are the IDs showing up in SMCONNID?
Thank you
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
February 12, 2009, 08:53 AM
CLH
From the manual the SMUSERID is the effective userid for the connection to the Reporting field. The value will be the connection id unless a GKE %USERID or GKE %MRE id subcommand are received. The SMCONNID is the user identifier that made the connection to the reporting server. The effective id can change sometimes based on what security mode your are using sometimes if you pass it a different value.