sql查询操作日志记录表

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

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;