This site is a summating demo of a live monitoring application that uses SCOME

Developed by Drew Salem
You are here:  SQL Server Reports > Logs by Server
  |  Login
<u>About this report</u>

About this report

Minimize

Instead of browsing each server in SSMS to view log entries, you could achieve the same from one location using SCOME. This report can:

Retrieve the first 500 rows of any SQL Server log on any remote linked server. Retrieve full Maintenance Plan log on any remote linked server. Retrieve full Jobs log on any remote linked server. Log cycle number can be specified for SQL Server logs (0 to 6).

Use SCOME to interrogate the following tables to retrieve log data from all linked servers: 

Jobs History
msdb.dbo.sysjobservers, msdb.dbo.sysoriginatingservers_view, msdb.dbo.sysjobs, msdb.dbo.sysjobhistory

Maint Plans
msdb.dbo.sysmaintplan_log, msdb.dbo.sysmaintplan_subplans, msdb.dbo.sysmaintplan_logdetail

SQL Server Logs
Use master.dbo.sp_readerrorlog @p, where @p is the log number, to retrieve log entries.

Retrieving log data in this page has been disabled (it's a headache setting up dummy data that correspond to the server names).

This help guide can be hidden by clicking the minimise icon on the right.

 

 


 Date data last gathered:

25 Oct 2009 08:00 AM


   SQL Server name

Please specify a server to interrogate



 

   SQL Server Reports





















Powered by phdcc.CodeModuleFree 01.01.03