查看操作日志脚本

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:

评论 (31) -

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!

jauntvacation wrote at 2019/11/2 21:09:16 #

very useful information you shared here with us. keep it up. <a href="https://jauntvacation.com/">cheap holidays to dubai</a>

Www.oy688.Com 美国 wrote at 2019/11/9 16:30:14 #

Hi to all, the contents present at this website are actually remarkable for people knowledge, well, keep up the good work fellows.  Look at my homepage -  Www.oy688.Com - http://www.oy688.com/comment/html/?209395.html

Fake Love BTS 美国 wrote at 2019/12/14 22:59:32 #

Great article, totally what I wanted to find.

Infiniti Kloud Review 美国 wrote at 2019/12/18 14:22:53 #

Hi there! This post could not be written much better! Looking through this article reminds me of my previous roommate! He always kept preaching about this. I'll send this article to him. Fairly certain he will have a good read. Thank you for sharing!  Feel free to surf to my website;  Infiniti Kloud Review - kennethsherwood.com/.../doku.php

Saimei Doi wrote at 2020/1/16 22:45:45 #

What an interesting thread to discuss such important topics. When I was working on the article https://xn--lck0a4d411qemf.jp/casino-x/ that was published recently I made a huge research. Read about great online casino in Japan

digital marketing agency 美国 wrote at 2020/1/29 11:38:40 #

I every time emailed this webpage post page to all my contacts, since if like to read it then my contacts will too.  Look into my blog post ...  digital marketing agency - www.techmagnate.com/...tal-marketing-services.html

IPTV Player 美国 wrote at 2020/1/31 22:13:43 #

Wow, this article is good, my sister is analyzing such things, so I am going to let know her.

justsome-mmmm.blogspot.com 美国 wrote at 2020/2/9 0:16:41 #

It's in point of fact a great and useful piece of info. I am satisfied that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.

Kang Fappin 美国 wrote at 2020/2/18 14:08:21 #

I'm really enjoying the design and layout of your website. It's a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme? Exceptional work!

iptv subscription 美国 wrote at 2020/2/29 8:04:57 #

That is a great tip especially to those fresh to the blogosphere. Short but very precise info… Many thanks for sharing this one. A must read article!

Buy Sociology Papers Online wrote at 2020/3/3 13:40:46 #

Nursing students always look for the Sociology Paper Writing Services since it’s very difficult to complete Sociology Research Paper Services and Sociology Essay Writing Services on time.
superiorpapers.us/buy-sociology-papers-online.html

Devel wrote at 2020/3/7 17:22:30 #

Do you want to expand your business worldwide? Are you looking for a website development company which helps you to grow your business online? <a href="www.obiyaninfotech.com/.../">Obiyan Infotech is the best website development company in Delhi</a>
which provides many features to increase your online presence with lots of features like SEO & Mobile Friendly Website, best graphics UI experience and better User Experience.

For more details, visit: https://www.obiyaninfotech.com/website-design/
You can also contact us at +91 7044444433

mostpha wrote at 2020/3/11 13:48:31 #

https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/
https://www.rjeem.com/

anna91 wrote at 2020/3/13 15:11:30 #

Things are very open and intensely clear explanation of issues. was truly information. Your website is very beneficial. http://hotmailtuts.com/hotmail-login/

yoshimalinda wrote at 2020/4/2 18:11:28 #

    Thanks for sharing this useful information with us .I am looking for this from a long time and I really very happy to say That I also deals with this service <a href="mckarma.com/contact-yahoo-support/">; Yahoo Helpline, How to Contact Yahoo Support</a>

添加评论



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


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
732566 条评论
11 次评分
757723 次访问
访问统计开始于 2019年12月15日
平均日访问 6588 次
当前 99 人在线