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 > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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: 1,873 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

Tags

Classifications

Public