Event Chains Disappearing in SQL Sentry version 2026.1.4

A known issue has been identified in SQL Sentry 2026.1.4 that can cause Event Chains to disappear from the SQL Sentry client. This is specific to chains that are in folders. First, only the listed owner of an Event Chain folder can see the folder and any chain within. Additionally, if you are the owner of the folder but a chain within it is owned by someone else, you can't see that chain. The chain functionality is unaffected, just the visual in the client is hindered.

Any Event Chains not inside a folder should be unaffected. 

Known issue in SQL Sentry 2026.1.4.

Option 1 (Recommended):

Upgrade to SQL Sentry 2026.3+

Option 2:

As a workaround, you may remove all chains from folders. To remove all chains from folders, follow the steps below.

1. Confirm in the dbo.TreeNodeFolder and dbo.TreeNode tables that the owner/s listed are not the user who cannot see the chains.
2. If they want to have all chains visible to all users, the only thing to do currently is to remove the chains from any folders.
   1. The NodeTypeID in both of the above tables should be 'CF18D121-C05B-451E-9BC5-0D432FD9CFB5' for Event Chains.
   2. Always take a backup of the SQL Sentry database before making manual changes. 
   3. Use the query below to delete all of the entries in the TreeNode table where the NodeTypeID is 'CF18D121-C05B-451E-9BC5-0D432FD9CFB5' to manually remove all chains from any folders.

---------------------------------------------------------------------------------------
-- 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.
---------------------------------------------------------------------------------------

--Confirm the chains that are currently in folders
SELECT
	EC.Name AS 'Chain Name',
	TNF.Name AS 'Folder Name',
	TN.ID AS 'Tree ID',
	TN.ParentTreeNodeFolderID 'Folder ID',
	TN.NodeTypeID,
	TN.Owner AS 'Chain Owner',
	TNF.Owner AS 'Folder Owner'
FROM TreeNode TN
JOIN TreeNodeFolder TNF ON TNF.ID = TN.ParentTreeNodeFolderID
JOIN EventChain EC ON EC.ID = TN.NodeID
WHERE TN.NodeTypeID = 'CF18D121-C05B-451E-9BC5-0D432FD9CFB5'

--Move all chains out of folders by deleting their records in the TreeNode table
--NodeTypeID 'CF18D121-C05B-451E-9BC5-0D432FD9CFB5' is for Event Chains
--This will not delete the chains themselves, just the references to the folder hierarchy
--It is still recommended to backup the SQL Sentry database before performing manual table updates
DELETE
FROM TreeNode
WHERE NodeTypeID = 'CF18D121-C05B-451E-9BC5-0D432FD9CFB5'