How to report on Most recent logged on user

Document ID : KB000050896
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem

Reports which contain the user field display the most frequently logged on user not the most recent.

Environment

Non Specific

Solution:

R12.5

A fix is available from support to enable this.

Please log a call requesting the fix for problem number 1864 with product code DTSVMG

r12.0 SP1 and below

A fix is not available for this version due to design restrictions.

A workaround is to run the below DMS Script as an Asset Management job.

This will create a new item under additional inventory that can be reported on.

The Script

 
'********************************************************************************* 
'* 
'* This DMS script is a Inventory module that registers the last logged on user. 
'* NOTE: This does not indicate the user is still logged on or the user has 
'* logged off again. 
'* 
'****************************************************************************************** 
DIM rhdl, dummy AS INTEGER 
DIM LastUser, sMIFFile AS STRING 
rhdl = RegOpenKey(HKEY_LOCAL_MACHINE,"SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon") 
IF rhdl <> 0 THEN 
RegQueryVariable(rhdl, "DefaultUserName", LastUser, Dummy ) 
RegCloseKey(rhdl) 
ELSE 
LastUser = "" 
ENDIF 
sMIFFile = ENVGETSTRING("temp")+"\LastUser.MIF" 
CreateMifFile(sMIFFile,"Last user","") 
CreateMifGroup(sMIFFile,"Last logged on info","","") 
CreateMifString(sMIFFile,"Last logged on info","Last Logged on user",LastUser,"")