Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Network Performance Monitor (NPM) > 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
20:24, 29 Mar 2017

Tags

Classifications

Public