Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Network Performance Monitor (NPM) > Audits Events missing from in Last xx Audit Events on Node Details

Audits Events missing from in Last xx Audit Events on Node Details

Updated 22nd August 2017

Overview

Not all Audit Events are displayed in the Last XX Audit Events widget or resource. When you go to the Message Center, you can see the most current events as opposed to old events in the Last XX Audit Events widget.

Environment

  • NPM versions with the Orion Report Writer

The Orion Report Writer tool is being deprecated. 

Cause 

Events or Audits widgets can be placed in different views.

  • If placed on the Summary page, the widgets display all messages.
  • If on a Node Details page, only events relevant for the node are displayed. By design, messages concerning anything other than the node, such as Interface or Volume events, are filtered out.

Resolution

This behavior is by design.

To display all events on a Node Details view, use custom SQL code.

  1. Create an Advanced SQL Report in Report Writer.
    1. Run the Orion Report Writer on your Orion server.
    2. Click New, and select Advanced SQL. 
      MT_CreateRWadvancedSQL.png
    3. On the SQL tab, paste the following SQL code.
      SELECT TOP 50 
      auditEventID as AuditID, 
      TimeLoggedUTC as DateTime, 
      AccountID as UserID, 
      ActionTypeID, 
      AuditEventMessage as Action,
      NetworkNode as Node, 
      NetObjectID as ID,
      NetObjectType as Type
      FROM [dbo].[AuditingEvents]
      order by TimeLoggedUTC desc

      MT_CreateRWSQLandAddQuery.png
    4. Provide the name and details for the report and click Save.
      MT_CreateRWnameAndDeets.png
  2. In the Orion Web Console, go to the Node Details view, and add a custom widget to the view.
    The resource to add is "Report from Orion Report Writer".
    222.PNG
  3. Click Select the report and choose the report to be displayed in the widget.
    image.png
  4. The messages for all events show on a Node Details view.
    MT_CreateRWreport on the Web.png

 

Last modified

Tags

Classifications

Public