Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Trace the user login activity in Orion Web Console using Audit Trails

Trace the user login activity in Orion Web Console using Audit Trails

Table of contents

Updated January 10, 2017

Overview

Determine the user login and logout activity using the AuditingEvents Table in Database Manager.

Environment

NPM 12

Steps

SELECT TOP 1000 * FROM [dbo].[AuditingEvents]
where actiontypeid = 1 or actiontypeid = 2 and accountid = 'admin'
order by timeloggedutc desc
  1. Log in to the Orion Web Console using an account with administrator privileges.
  2. Go to Settings > All Settings.
  3. Click 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, verify that you have a backup of your Orion Database.
  7. Locate and double click  the AuditingActionsTypes Table. Refer to the following image:
  8. Note the ActionTypeID (1 and 2 for the user login and user logout respectively).
  9. For example, we would like to trace the login activity of the 'Admin' account. Execute on the following query :  
  10. All activity of that particular user should be displayed as shown in the screenshot, latest first.

 

 

 

Last modified

Tags

Classifications

Public