查看操作日志脚本

by 嘉山 2018.3.30 15:50

SELECT  distinct A3.[Name] as [LoginUser_Name], A.[OccurrenceTime] as [OccurrenceTime],
A8.DisplayName,
A7.[ControlName] as [ControlName],A.description, A.[IsSuccess] as [IsSuccess], A.[ErrorMessage] as [ErrorMessage],  A1.[Name] as [Menu_Name],A.[MachineIP] as [MachineIP], A.[SessionID] as [SessionID],A.[ActionType] as [ActionType]
 ,A.* FROM  UBF_Log_OperateLog as A  left join UBF_Assemble_Menu as A1 on (A1.[Code] = A.[Menu]) 
    left join [Base_User] as A3 on (A.[LoginUser] = A3.[ID])
    left join [Base_Organization_Trl] as A5 on (A5.SysMlFlag = 'zh-CN')
      inner join [UBF_Log_OperateLog_Trl] as A7 on (A7.SysMlFlag = 'zh-CN')
      and (A.[ID] = A7.[ID])
      inner join UBF_MD_UIForm as A9 on A9.UID=A.Form
    inner  join [UBF_MD_UIForm_Trl] as A8 on (A8.SysMlFlag = 'zh-CN') and  A9.ID=A8.id
   WHERE  A.[OccurrenceTime] >='2018-03-29 00:00:00.000' and  A.[OccurrenceTime] <='2018-03-30 23:59:59.000'
  and
   ControlName!='登录' and a3.Name='sw' and A7.[ControlName] not in ('进入菜单','隐藏控件取消')
      --and A.description like '%1510140003%'
   order by A.[OccurrenceTime]

Tags:

评论 (16) -

senzhilian wrote at 2018/7/18 18:41:37 #

面膜代理  http://www.sealian.com.cn/
面膜微商  http://www.sealian.com.cn/
面膜批发  http://www.sealian.com.cn/
彩妆批发  http://www.sealian.com.cn/
化妆品批发  http://www.sealian.com.cn/
孕妇面膜  http://www.sealian.com.cn/
械字号面膜  http://www.sealian.com.cn/
海藻面膜  http://www.sealian.com.cn/
蚕丝面膜  http://www.sealian.com.cn/
补水面膜  http://www.sealian.com.cn/

viagra pills 美国 wrote at 2018/12/13 8:54:01 #

viagra without a doctor prescription - http://yotapati.com/letter/1474676

pharmacy without dr prescriptions 美国 wrote at 2018/12/14 1:10:13 #

viagra without a prescription - tao-bao-market.ru/.../

online pharmacy no prescription needed uk 美国 wrote at 2018/12/31 5:50:12 #

viagra without a doctor prescription safe - sertified.org/.../

viagra coupons 美国 wrote at 2019/1/26 5:14:35 #

Thank you for sharing your info. I truly appreciate your efforts and I will be waiting for your next write ups thank you once again.  female viagra - 114.71.1.161/index.php

viagra 美国 wrote at 2019/2/15 8:19:43 #

It's very easy to find out any matter on net as compared to textbooks, as I found this paragraph at this site.  viagra connect - www.aerostatumn.org/.../index.php

Yahoo Password Recovery wrote at 2019/5/29 14:30:14 #

In this segment, you will get three choices Mobile telephone number recuperation, Alternative Email Address and last one Secret Questions. Of all the 3 choice, a solitary alternative addressed effectively can assist you with giving your old secret phrase. In any case, in the event that you neglect to reply, attempt at the same time for the following alternative that one of it is, obviously, going to help you for recuperation.
Visit for more :-https://jigefy.com/yahoo-password-recovery/

cash app phone number wrote at 2019/7/10 1:46:15 #

Cash App (as of now know as Square Cash) is a Smartphone payment service by Square, Inc., enabling the customer to exchange cash to each other utilizing a cell phone application. As of February 18, 2018, the administration recorded 7 million dynamic users. Venmo’s transaction limit is different than Square Cash’s, however. Get instant help from our expert at Cash App Customer Support and feel free of all your queries and problems related with your account at the Cash App because they are at your service with the best solution to your every problem. You’re limited to $299.99 per week unless you verify your identity by linking your Facebook account or adding your ZIP code, last four digits of your SSN, and birthdate, which ups your limit to $2,999.99.

james_brown wrote at 2019/7/26 12:45:21 #

I'm glad I found this web site, I couldn't find any knowledge on this matter prior to. Also, operate a site and if you are ever interested in doing some visitor writing for me if possible feel free to let me know, I'm always looking for people to check out my web site.
https://fireboyand-watergirl.com/

International holiday packages wrote at 2019/8/2 20:51:02 #

Again a beautiful content, thank you so much for sharing such amazing information with us. Get the best travel agency in Delhi, India.
<a href="https://ridhitravels.in/">best travel agency in india</a>

Ridhitravels wrote at 2019/8/2 20:51:52 #

Again a beautiful content, thank you so much for sharing such amazing information with us. Get the best travel agency in Delhi, India.


https://ridhitravels.in/

onlinedigitalseo wrote at 2019/8/23 20:33:35 #

thank you so much for sharing such amazing information with us. Get the best Website Designing and Digital Marketing Services in Delhi, India. & For more information visit at :-https://online-digitalseo.com

onlinedigitalseo wrote at 2019/8/23 20:36:07 #

thanks to give for informative content... & for more information please visit & contact us : online-digitalseo.com/seo-services-company/

Dasspackers wrote at 2019/9/14 20:50:04 #

Dass Movers Packers provides complete solutions for all your shifting and packing needs. We specialize  in offering  tailor  made services to meet the budget and requirements of the clients from household and corporate sector.
<a href="http://dasspackersnmovers.com/">packing and unpacking<a/>

bellaedward wrote at 2019/9/17 18:17:24 #

Thanks for sharing the information. I found the information very useful. That’s a awesome story you posted. I will come back to scan some more.
visit: realcolors.makan-studios.com/lucky-patcher/

Somerset SEO 美国 wrote at 2019/9/18 6:30:08 #

Hello, thank you for putting up your website. It was really informative and I can tell that you are actually knowledgable about the subjects you blog about. Continue up the very good work!

添加评论



biuquote
微笑得意调皮害羞酷大笑惊讶发呆喜欢可怜尴尬闭嘴噘嘴皱眉伤心抓狂呕吐坏笑漫骂发怒
Loading


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
540737 条评论
11 次评分
57567 次访问
访问统计开始于 2019年9月14日
平均日访问 6396 次
当前 114 人在线