Good morning,
In IAM, you can see when your users logged in etc. in the session log information. Is there a way to extract information from the session log and show this in the end application? We would like to be able to show the datetime of the last login of a user in our application.
Best answer by Harm Horstman
Hi Stefan,
We are using a startup procedure that maintains a record in a table for each end user for this. The name of the procedure is defined as Extended Property (StartupProcedure)
The procedure should contains something like this:
IF NOT EXISTS (SELECT 1 FROM tw_user WHERE usr_name = dbo.tsf_user())
BEGIN
INSERT INTO tw_user (
usr_name
, is_active
, last_login_date_time
, insert_user
, insert_date_time
)
SELECT usr_name = dbo.tsf_user()
, is_active = 1
, last_login_date_time = GETDATE()
, insert_user = dbo.tsf_user()
, insert_date_time = GETDATE()
END
ELSE
BEGIN
UPDATE tw_user
SET last_login_date_time = GETDATE()
, is_active = 1
, update_user = dbo.tsf_user()
, update_date_time = GETDATE()
WHERE usr_name = dbo.tsf_user()
END
+21Hi Stefan,
We are using a startup procedure that maintains a record in a table for each end user for this. The name of the procedure is defined as Extended Property (StartupProcedure)
The procedure should contains something like this:
IF NOT EXISTS (SELECT 1 FROM tw_user WHERE usr_name = dbo.tsf_user())
BEGIN
INSERT INTO tw_user (
usr_name
, is_active
, last_login_date_time
, insert_user
, insert_date_time
)
SELECT usr_name = dbo.tsf_user()
, is_active = 1
, last_login_date_time = GETDATE()
, insert_user = dbo.tsf_user()
, insert_date_time = GETDATE()
END
ELSE
BEGIN
UPDATE tw_user
SET last_login_date_time = GETDATE()
, is_active = 1
, update_user = dbo.tsf_user()
, update_date_time = GETDATE()
WHERE usr_name = dbo.tsf_user()
END
+23Hi Stefan,
Harm's suggestion is great for Windows and Web GUI 😄 In case you would like this to show up in the Universal GUI, you can make use of Start objects for the application. You can start a Process flow or run a Task for example to execute Harm's procedure. Additionally, you could add an Open document process action to the process flow open a certain screen if desired.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.