Network Management
How to check who created a Comparison Criteria in NCM
This article will help track who added a Comparison Criteria in NCM.
First published date
Last published date
Overview
In NCM, you may not know why a configuration change is not being detected. It is important to check the currently enabled Comparison Criteria settings.
This article will discuss who to track who created a Comparison Criteria that you may be unaware of.
Product section
Resolution
You may perform the following:
- Query the NCM_CompareRegExs table
- Connect to the SolarWinds Platform server.
- Open Database Manager from the SolarWinds Platform folder of the start menu.
- Select Add Orion Server.
- Expand the SQL Server and database in bold.
- Navigate to the NCM_CompareRegExs table and double-click.
- Execute the query on the right to display the top 1000 rows.
- Get the RegExID of the Comparison Criteria in question.
- Right-click the database and select New Query.
- Paste and execute the following query:
-- 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 TOP 1000 * FROM [dbo].[AuditingEvents]
where auditeventmessage like '%XXXXXXXXX%'
NOTE: Change XXXXXXXXX with the RegExID of your Comparison Criteria.