sql查询操作日志记录表

select top 2000 bophis.*,
logorgl.FNAME 登陆组织,
userl.FNAME 用户,
objtl.FNAME 单据名称,
sysl.FNAME 子系统
from T_BAS_OPERATELOGBK bophis  --操作日志备份表
left join T_ORG_ORGANIZATIONS_L logorgl on  bophis.FLOGONORGID=logorgl.FORGID and logorgl.FLOCALEID=2052
inner join T_SEC_USER userl on bophis.FUSERID = userl.FUSERID
inner join T_META_OBJECTTYPE_L objtl on bophis.FOBJECTTYPEID=objtl.FID and objtl.FLOCALEID=2052
left join T_META_SUBSYSTEM_L sysl on bophis.FSUBSYSTEMID=sysl.FID and sysl.FLOCALEID=2052
where objtl.fname='自助请假单'
order by bophis.FDATETIME desc;


select top 2000 bophis.*,
logorgl.FNAME 登陆组织,
userl.FNAME 用户,
objtl.FNAME 单据名称,
sysl.FNAME 子系统
from T_BAS_OPERATELOG bophis  --操作日志表
left join T_ORG_ORGANIZATIONS_L logorgl on  bophis.FLOGONORGID=logorgl.FORGID and logorgl.FLOCALEID=2052
inner join T_SEC_USER userl on bophis.FUSERID = userl.FUSERID
inner join T_META_OBJECTTYPE_L objtl on bophis.FOBJECTTYPEID=objtl.FID and objtl.FLOCALEID=2052
left join T_META_SUBSYSTEM_L sysl on bophis.FSUBSYSTEMID=sysl.FID and sysl.FLOCALEID=2052
where objtl.fname='自助请假单'
order by bophis.FDATETIME desc;

系统为了保持操作日志的查询效率目前默认5万条就进行归档，所以大部分记录会在bak表