Disable an Unwanted Component Monitor in AppInsight for Active Directory in SAM

This article provides steps to disable a specific component monitor under AppInsight for Active Directory when a monitored event or check is not required in the environment. It explains how to identify the correct application and component entry, update the database record, and validate the change.

Use this procedure when:

• You do not want a specific AppInsight for Active Directory component to be monitored

• A specific event or check is not applicable in the customer environment

• You need to disable only one component monitor without affecting the rest of the Application Monitor

This behavior can occur because AppInsight for Active Directory includes multiple predefined component monitors as part of the application. Some of these component monitors may not be applicable or required in every environment.

Step 1: Identify the application and target component

Run the following query to confirm the component monitor entries for the target application:

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

SELECT [ID], [ApplicationID], [Name], [IsDisabled]
FROM [dbo].[APM_Component]
WHERE [ApplicationID] = [ApplicationID]
  AND (
       [Name] LIKE '%[keyword1]%'
       OR [Name] LIKE '%[keyword2]%'
      );

Example:

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

SELECT [ID], [ApplicationID], [Name], [IsDisabled]
FROM [dbo].[APM_Component]
WHERE [ApplicationID] = 2
  AND (
       [Name] LIKE '%account failed%'
       OR [Name] LIKE '%attempted to logon%'
      );

Review the output and confirm the correct component monitor names and IDs before proceeding.

Step 2: Disable the required component monitor

If the component names are confirmed, run the following update:

-- 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 [dbo].[APM_Component]
SET [IsDisabled] = 1
WHERE [ApplicationID] = [ApplicationID]
  AND (
       [Name] LIKE '%[keyword1]%'
       OR [Name] LIKE '%[keyword2]%'
      );

If you want to target specific rows only, use the component IDs instead:

-- 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 [dbo].[APM_Component]
SET [IsDisabled] = 1
WHERE [ID] IN ([ComponentID1], [ComponentID2]);

Step 3: Validate the change

Run the same select query again to verify that the component monitor is now disabled:

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

SELECT [ID], [ApplicationID], [Name], [IsDisabled]
FROM [dbo].[APM_Component]
WHERE [ApplicationID] = [ApplicationID]
  AND (
       [Name] LIKE '%[keyword1]%'
       OR [Name] LIKE '%[keyword2]%'
      );

Confirm that:

• the correct component monitor was updated

• the IsDisabled value now shows the disabled state

• no unrelated components were changed