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,"")