建模修改历史表

建模修改历史表：select * from modelingaudittrailheader t

第一步我自己去测试环境模拟，改一下建模
select * from modelingaudittrailheader t where t.employeename='52090499' order by TXNDATE desc
第二步，观察数据的生成
第三步，根据观察写where条件
select * from modelingaudittrailheader t where OBJECTTYPENAME='WIPDataSetup' and OBJECTNAME is null order by TXNDATE desc
去正式环境查，查到了谁改的建模

 

select top 10 t.EmployeeName,t.ObjectTypeName,t.TxnDate,m.AuditTrailInfo from modelingaudittrailheader t
left join ModelingAuditTrail m on m.ModelingAuditTrailHeaderId=t.ModelingAuditTrailHeaderId
where 1=1--t.employeename='登录账号'
and t.OBJECTTYPENAME like '%OnlineQuerySetup%'
order by TXNDATE desc