Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > Create scheduled report for audit events

Create scheduled report for audit events

Table of contents
Created by Roie.Exconde, last modified by MindTouch on Jun 23, 2016

Views: 83 Votes: 1 Revisions: 3

Overview

This article provides steps to create a scheduled report for audit events and identify who among the Orion users deleted nodes/interfaces/volumes.

Environment

All NPM versions

Steps

Create Scheduled Reports for Event Auditing:
1. Log in to your Orion SolarWinds Web Console as an administrator.
2. Under Home tab, select Reports.
3. Click the Manage Report icon (Green Pen Icon).
4. Click Schedule Manager then click Create new Schedule.
5. Assign a Schedule name (For example, audit report) .
6. Click assign report then enter audit on the search box.
7. Select the Last 100 Audit Events, then click Assign Report.
8. Click Next and Add frequency (For example, Every Friday, Weekly).
9. Under Action, select your target action (For example, email, Print or Save to a disk).
10. Once done, click Create Schedule under Summary.

Note: This report will include all the auditing activities on your Orion web console.

You can use the query below if you need to check the Orion accounts within database:

1. Open Database Manager on your Orion server.
2. Click Add default Server.
3. Expand SOLARWINDS_ORION instance.
4. Right-click on SolarWindsOrion and select New Query.
5. Paste the query below and execute:
 

SELECT TOP 1000 * FROM [dbo].[AuditingEvents]
where auditeventmessage like '%deleted%'


Note: Auditing event table is  [dbo].[AuditingEvents], account who performed the action is under the column AccountID.

 

 

 

Last modified
22:01, 22 Jun 2016

Tags

Classifications

Public