Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Trace the activity of a node using Audit Trails

Trace the activity of a node using Audit Trails

Table of contents

Updated November 9, 2016

Overview

Check or trace any changes made on the particular node using the Audit Trails using an IP address.

Environment

NPM 12

Steps

  1. Log in to Orion Web Console using an account with Admin Privilege.
  2. Go to Settings > All Settings.
  3. Click on Web Console Settings.
  4. Verify if Audit Trails is set to Enabled.
  5. RDP to the NPM Server.
  6. Launch the Database Manager.
    Note: Before you proceed with the Database Changes, make sure you have a backup of your Orion Database.
  7. Determine the NodeID of the Node with an issue or need to trace using IP Address. (for example, 10.0.0.0) and return a NodeID : 55.
  8. Using the Node ID, execute the Query:
    SELECT TOP 1000 * FROM [dbo].[AuditingEvents]
    

     where networknode = 55

    All the activity on that particular node should be displayed as shown in the screenshot.

 

 

 

Last modified

Tags

Classifications

Public