InTrust 11.6 - InTrust Reports

Report Pack for SQL Server

This section contains a list of reports included in the InTrust11.5.1 Report Pack for SQL Server.

C2 Log

• Account Management
• Change Management
• Logons
• All events in c2 log

Account Management

Logins audit

This InTrust report shows events from the C2 log which indicate that a SQL Server login is added or removed, a Windows login is added or removed, or a property of a login, including passwords, is modified. For each SQL server name and instance, the report displays the following event details login name, date and time, action type and action status.

Roles audit

This InTrust report shows events from the C2 log which indicate that a login has been added or removed as a database user. For each SQL server name and instance, the report displays the following event details database name, login name, role name, action date and time, action type and action status.

Users audit

This InTrust report shows events from the C2 log which indicate that a login is added or removed as a database user (with Windows or SQL Server authentication). For each SQL server and instance, the report displays the following details: database name, user name, login name, action date and time, action type and action status.

Change Management

Database structure modifications

This InTrust report shows events from the C2 log which indicate that a CREATE, ALTER, or DROP object command has been executed. For each SQL server and instance, the report displays the following event details: database name, object name, user name, date and time, action type and action status.

Permission modifications

This InTrust report shows events from the C2 log which indicate that a GRANT, DENY or REVOKE has been executed for a statement permission or for an object permission. For each SQL server and instance, the report displays the following event details database name, object or statement name, user name, date and time, action type and action status.

Logons

Logons c2 log

This InTrust report shows user logon events from the C2 log. For each SQL server and instance, the report displays the following event details: Server and instance, Date/Time, login, event class, host and application name.

All events in c2 log

This InTrust report shows all SQL Server events gathered from the C2 log. For each SQL server and instance, the report displays such event details as Server, Instance, Date/Time, Login, Event Class, Database, Success.

Error Log

• Maintenance
• Security
• All events in error log

Maintenance

Backup history

This InTrust report shows backup and restore events in Error log. For each SQL server or server instance, the report displays event times, database and action.

DBCC history

This InTrust report shows DBCC events in the Error log. For each SQL server and instance, the following event details are displayed: event times and DBCC output messages.

Server starts up shuts down

This InTrust report, based on events from the Error log, shows when SQL servers were started and shut down.

Security

Logons error log

This InTrust report shows logon events in Error log. For each SQL server and instance, the following event details are displayed: event date and time, event type and status.

All events in error log

This InTrust report shows all events in SQL Server Error log. For each SQL server and instance, the following event details are displayed: date and time, event type and status.

Replication

Miscellaneous agent history

This InTrust report shows events from the history of auxiliary agents. For each SQL server and instance, the report displays the following event details: agent name, date/time, step number (Step# - 0 for a job outcome), step, status, message.

Replication agent history

This InTrust report shows events from replication agent history. For each SQL server and instance, the report displays the following event details: agent name and type, date/time, agent status, error number and message.