Go Up
You are here: AdministrationMonitored Object Types, Actions, and AttributesSQL ServerMonitored Object Types

Monitored Objects and Events

Events

Netwrix Auditor collects successful and failed logon attempts for Windows and SQL logons:

Logon Type Action

SQL logon

  • Successful logon
  • Failed logon

Windows logon

  • Successful logon
  • Failed logon

Objects

The table below contains the full list of object types that Netwrix Auditor monitors on SQL Servers (Application Roles, Database, Jobs, etc.). The product reports on the object added or removed, and on the object attribute modified.

Object type Attributes

Application Role

  • Date Created
  • Date Modified

  • Default Schema

  • Extended Properties

  • Id

  • Name

  • Owned Schemas

Backup

  • Backup name

  • Description

  • Device name

  • logical_device_name

  • Size

  • Type

Column

  • Allow nulls

  • ANSI Padding Status

  • Collation

  • Computed Text

  • Default Constraint

  • Full Text

  • ID

  • Identity

  • Identity increment

  • Identity seed

  • Is Computed

  • Length

  • Name

  • Not for replication

  • Numeric precision

  • Numeric scale

  • Primary Key

  • Rule

  • Rule Schema

  • System Type

  • XML Schema Namespace

Constraints

  • Date Created

  • Date Modified

  • Definition

  • ID

  • Is system named

  • MS shipped

  • Name

  • Published

  • Schema published

Credential

  • Id

  • Identity

  • Date Created

  • Date Modified

  • Name

Database

  • Compatibility

  • Database Size

  • Database Space Available

  • Date Created

  • Date Modified

  • Extended Properties

  • File Id

  • File Group

  • File Name

  • Growth

  • Id

  • Name

  • Options

  • Owner

  • Permissions

  • Size

  • Usage

Database Role

  • Date Created

  • Date Modified

  • Extended Properties

  • Id

  • Name

  • Owner

  • Owned Schemas

  • Role Members

Functions

  • Date Created

  • Date Modified

  • Id

  • Name

  • Permissions

  • Type

Jobs

  • Automatically delete job

  • Category

  • Date Created

  • Date Modified

  • Description

  • Email notification

  • Email operator

  • Enabled

  • ID

  • Name

  • Net send notification

  • Net send operator

  • Owner

  • Page notification

  • Page operator

  • Schedules

  • Write to the Windows Application event log

Job Steps

  • ID

  • Name

  • On Failure

  • On Success

  • Output file

  • Process exit code of a successful command

  • Retry attempts

  • Retry interval (minutes)

  • Step

  • Type

Jobs Schedules

  • Date Created

  • Date Modified

  • Enabled

  • ID

  • Name

  • Owner

  • Schedule Type

  • Settings

Indexes

  • Allow page locks

  • Name

  • Primary key

  • Ignore duplicate values

  • Unique constraint

  • Allow row locks

  • Type

  • Disabled

  • Included Columns

  • Fill factor

  • Data Space ID

  • Index Key Columns

  • Padded

  • Hypothetical

  • Unique

Keys

  • Name

  • ID

  • Date Created

  • Date Modified

  • MS shipped

  • Published

  • Schema published

  • Disabled

  • Not for replication

  • Not trusted

  • Delete referential action

  • Update referential action

  • Is system named

Login

  • Date Created

  • Date Modified

  • Default Database

  • Default Language

  • Disabled

  • Enforce Password Expiration

  • Enforce Password Policy

  • Id

  • Name

  • Password Hash

  • Server Roles

Restore

  • Type
Schema

 

  • Date Created

  • Date Modified

  • Extended Properties

  • Id

  • Name

  • Owner

  • Permissions

Server Instance

  • Ad Hoc Distributed Queries

  • Affinity I/O Mask

  • Affinity Mask

  • Agent XPs

  • Allow Updates

  • Awe Enabled

  • Blocked Process Threshold

  • C2 Audit Mode

  • Clr Enabled

  • Collation

  • Cost Threshold For Parallelism

  • Cross Db Ownership Chaining

  • Cursor Threshold

  • Database Mail XPs

  • Date Modified

  • Default Full-text Language

  • Default Language

  • Default Trace Enabled

  • Disallow Results From Triggers

  • Fill Factor (%)

  • Ft Crawl Bandwidth (max)

  • Ft Crawl Bandwidth (min)

  • Ft Notify Bandwidth (max)

  • Ft Notify Bandwidth (min)

  • Id

  • In-doubt Xact Resolution

  • Index Create Memory (K)

  • Lightweight Pooling

  • Locks

  • Max Degree Of Parallelism

  • Max Full-text Crawl Range

  • Max Server Memory (M)

  • Max Text Repl Size (B)

  • Max Worker Threads

  • Media Retention

  • Min Memory Per Query (K)

  • Min Server Memory (M)

  • Name

  • Nested Triggers

  • Network Packet Size (B)

  • Ole Automation Procedures

  • Open Objects

  • Permissions

  • PH Timeout (s)

  • Precompute Rank

  • Priority Boost

  • Query Wait (s)

  • Query Governor Cost Limit

  • Recovery Interval (min)

  • Remote Admin Connections

  • Remote Login Timeout (s)

  • Remote Proc Trans

  • Remote Query Timeout (s)

  • Remote Access

  • Replication XPs

  • Scan For Startup Procs

  • Server Trigger Recursion

  • Set Working Set Size

  • Show Advanced Options

  • SMO And DMO XPs

  • SQL Mail XPs

  • Status

  • Transform Noise Words

  • Two Digit Year Cutoff

  • User Connections

  • User Instances Enabled

  • User Instance Timeout

  • User Options

  • Web Assistant Procedures

  • Xp_cmdshell

Server Role

  • Date Created

  • Date Modified

  • Id

  • Name

  • Role Members

Stored Procedure

  • ANSI NULLs

  • Date Created

  • Date Modified

  • Encrypted

  • Execute us

  • FOR replication

  • Id

  • Name

  • Permissions

  • Quoted Identifier

  • Recompile

  • Schema

Table

  • ANSI NULLs

  • Date Created

  • Date Modified

  • Filegroup

  • Id

  • Name

  • Partition scheme

  • Permissions

  • Schema

  • Table is partitioned

  • Table is replicated

  • Text filegroup

Triggers

NOTE: Only DML table triggers are supported.

  • Date Created

  • Date Modified

  • Disabled

  • ID

  • Instead of trigger

  • MS shipped

  • Name

  • Not for replication

User

  • Date Created

  • Date Modified

  • Default Schema

  • Extended Properties

  • Id

  • Name

  • Owned Schemas

  • Roles

View

  • ANSI NULLs

  • Date Created

  • Date Modified

  • Encrypted

  • Id

  • Name

  • Permissions

  • Quoted Identifier

  • Schema

  • Schema bound

View Column

  • Allow nulls

  • ANSI Padding Status

  • Collation

  • Computed Text

  • Default Constraint

  • Full Text

  • ID

  • Identity

  • Identity increment

  • Identity seed

  • Is Computed

  • Length

  • Name

  • Not for replication

  • Numeric precision

  • Numeric scale

  • Rule

  • Rule Schema

  • System Type

  • XML Schema Namespace

  • XML Schema Namespace schema

View Index

  • Allow Page Locks

  • Allow Row Locks

  • ID

  • Data Space ID

  • Disabled

  • Fill Factor

  • Hypothetical

  • Ignore Dup Key

  • Name

  • Padindex

  • Primary Key

  • Schema Name

  • Type

  • Unique

  • Unique Constraint

  • View Name

View Index Column

  • Column ID

  • ID

  • Included Column

  • Index ID

  • Key Ordinal

  • Name

  • Partition Ordinal

  • Schema Name

  • Sort Order

  • View Name

Go Up