Date Last Used field

Epicor ERP 10
1

Hi,

Where can I find the highlighted field “Date Last Used” below in BAQ

image

I couldn’t find the field LastLogOnAttempt field in table ice.SysUserFile in BAQ.

image

2

Try plain old UserFile

3 
select 
	[SysUserFile].[UserID] as [SysUserFile_UserID],
	[SysUserFile].[LastLogOnAttempt] as [SysUserFile_LastLogOnAttempt],
	[SysUserFile].[PwdLastChanged] as [SysUserFile_PwdLastChanged]
from Ice.SysUserFile as SysUserFile
4

Hi Mr Surendrapal,

I dont see the column LastLogOnAttempt and UserID in these table

image

5

which version you are?

image
image.png1576×451 23.7 KB

7

I’m using version 10.2.100.28

image
image.png1279×474 25.6 KB

8

try this

select 
	[UserFile].[DcdUserID] as [UserFile_DcdUserID],
	[UserFile].[LastDate] as [UserFile_LastDate],
	[UserFile].[LastTime] as [UserFile_LastTime]
from Erp.UserFile as UserFile
9

Ok i query these two

1) select LastLogOnAttempt, * from ice.SysUserFile where UserID = ‘XXXXX’

2) select **
** [UserFile].[DcdUserID] as [UserFile_DcdUserID],
** [UserFile].[LastDate] as [UserFile_LastDate],**
** [UserFile].[LastTime] as [UserFile_LastTime]**
from Erp.UserFile as UserFile

image

The output is totally different. By right both the data and time should be same.

10

do any change and update in User file, and recheck the date, i think that LastLog is when you last logged in Epicor and the Last Data Used in user is when you did change last time within the User BO

before doing any changes in User UI

image
image1271×836 34 KB

after

image
image1079×852 22.1 KB

11

Based on my knowledge Erp.UserFile is lagecy system table Ice.SysUserFile is new design, so I assume later versions we will not see “Erp.UserFile”

12

The inner join link between the two tables :

select 
	[SysUserFile].[CompList] as [SysUserFile_CompList],
	[SysUserFile].[UserID] as [SysUserFile_UserID],
	[SysUserFile].[Name] as [SysUserFile_Name],
	[SysUserFile].[LastLogOnAttempt] as [SysUserFile_LastLogOnAttempt],
	[UserFile].[LastDate] as [UserFile_LastDate]
from Ice.SysUserFile as SysUserFile
inner join Erp.UserFile as UserFile on 
	SysUserFile.UserID = UserFile.DcdUserID
And
	SysUserFile.CompList = UserFile.CompList