Database Management

Watching target(s) through the EventSourceConnection table in the database when issues arise in watching target(s) through SQL Sentry Client

How to watch target through the SQL Sentry database using a query. This is very useful in case there are unknown system permissions not allowing you to watch through the Client. Many times the Client will have issues watching the target, but to get a solid resolution watching the target through the database is a logical resolution.

First published date

3/21/2022 1:06 PM

Last published date

7/28/2023 10:06 PM

Overview

If you are having issues watching a target through the SQL Sentry Client. The query in the Resolution section is resourceful in watching target(s) through the SQL Sentry database. This is a very useful workaround and also great knowledge to have overall for using the application.

Product section

SQL Sentry (SQLS)

Cause

N/A

Resolution

Running the query below will update a target to be watched in the SQL Sentry database, and you will need to update the name of the target(s) you intend to watch in this query template.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.



update EventSourceConnection
set isWatched = 1
where ObjectName like '(Target)'

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.