By dicetube - 12 Dec 2023
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.
|
By LogViewPlus Support - 12 Dec 2023
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
|
By dicetube - 12 Dec 2023
OK, thanks. I will look into that
|
|