Geeks With Blogs

News View Michael Stephenson's profile on BizTalk Blog Doc View Michael Stephenson's profile on LinkedIn
Michael Stephenson keeping your feet on premise while your heads in the cloud
If you are using BizTalk 360 and want to get an overview of some of the events which have been occurring in your event log, the below is quite a handy little query which will summarize the different type of events so you can easily see the most common ones.

SELECT     
EventId, Source, COUNT(1) AS [No Instances], Computer, Message
FROM         
dbo.b360_ev_EventLogData
GROUP BY 
EventId, Source, CONVERT(varchar(8), Timestamp, 112), Message, Computer
HAVING     
 (CONVERT(varchar(8), Timestamp, 112) = CONVERT(varchar(8), GETDATE(), 112))
ORDER BY [No Instances] DESC


You can add this to the custom sql query tool so its easily accessible to your team.
Posted on Tuesday, May 21, 2013 1:20 PM BizTalk | Back to top


Comments on this post: Summarizing event log data from BizTalk 360

# BizTalk
Requesting Gravatar...
One of the best monitoring stuff that can be ever find! Do you have a facebook promotion page or something like that?
https://coupons-bonus.com
Left by Rraine on Feb 20, 2016 2:00 PM

# re: Summarizing event log data from BizTalk 360
Requesting Gravatar...
thank you for this, it really helped me with my systematically arrangtd information stuff
brazzers account
Left by Zara S. on Nov 06, 2016 5:22 AM

Your comment:
 (will show your gravatar)


Copyright © Michael Stephenson | Powered by: GeeksWithBlogs.net