LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Log Reader - Command Line Interface

The command-line interface (CLI) helps you access the Log Reader functionality directly without opening the console.

With CLI, you can:

• Manage registration of SQL Server instances
• Manage Log Reader server components
• Read DML/DDL commands
• Read log records
• Read transactions
• Save results in CVS, HTML, XML files, or in databases

The Log Reader CLI uses Windows PowerShell technology. PowerShell is an extendable environment that operates with .Net objects. Log Reader requires PowerShell be installed where?

To use Log Reader CLI

1. (First use only) Install and register the Log Reader PowerShell Snap-In. For more information, see To register the Log Reader Snap-In.
2. Do one of the following:
   • Add the Log Reader Snap-In to the PowerShell console. For more information, see To add the Log Reader Snap-In to the PowerShell console.
   • Start PowerShell from a previously created configuration file. For more information, see To save PowerShell console configuration.
3. Run the Command-Line Interface commands.

Tips:

• To get help on a command, run the "get-help [command name] -detailed" command in PowerShell.
• You can create scripts with the Log Reader CLI commands. For more information, see To execute a Log Reader CLI script.

Related Topics

Log Reader PowerShell Snap-In

Log Reader Command-Line Interface Commands

Script Log Reader Commands