LogViewPlus Support » LogViewPlus Support » Help & Support » Use custom query to connect to MS SQL Server

Use custom query to connect to MS SQL Server

dicetube — Tue, 12 Dec 2023 13:40:23 GMT

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.

RE: Use custom query to connect to MS SQL Server

dicetube — Tue, 12 Dec 2023 13:40:23 GMT

OK, thanks. I will look into that

RE: Use custom query to connect to MS SQL Server

LogViewPlus Support — Tue, 12 Dec 2023 13:33:55 GMT

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