Hi,
Where can I find the highlighted field “Date Last Used” below in BAQ
I couldn’t find the field LastLogOnAttempt field in table ice.SysUserFile in BAQ.
Try plain old UserFile
select
[SysUserFile].[UserID] as [SysUserFile_UserID],
[SysUserFile].[LastLogOnAttempt] as [SysUserFile_LastLogOnAttempt],
[SysUserFile].[PwdLastChanged] as [SysUserFile_PwdLastChanged]
from Ice.SysUserFile as SysUserFile
Hi Mr Surendrapal,
I dont see the column LastLogOnAttempt and UserID in these table
try this
select
[UserFile].[DcdUserID] as [UserFile_DcdUserID],
[UserFile].[LastDate] as [UserFile_LastDate],
[UserFile].[LastTime] as [UserFile_LastTime]
from Erp.UserFile as UserFile
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
The output is totally different. By right both the data and time should be same.
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
after
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”
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
1 Like