Use custom query to connect to MS SQL Server

Is there a way to use a custom query when connecting to SQL server?  For example if we wanted to use a query to pull together a more succint view of the SQL Server agent job history rather than just grabbing the msdb.dbo.sysjobs_view table only.

You cannot write a full query, but you can add a condition to the lookup query.  In the Open Log File dialog, you should see a Condition field.  The value added here will be appended to a WHERE clause.  For example, if I was only interested in records written by 'Graph' loggers, I could use a 'like' condition:



Hope that helps,

Toby

OK, thanks.  I will look into that