Get-QLRSqlTransaction

From PowerGUI Wiki

Reads transactions.

Contents 1 Syntax 2 Detailed Description 3 Related Commands 4 Parameters 5 Input Type 6 Return Values 7 Examples 7.1 EXAMPLE 1 7.2 EXAMPLE 2

Syntax

Get-QLRSqlTransaction [-Reader] <LogReaderSSWrapper> [-After [<DateTime>]] [-Before [<DateTime>]] [<CommonParameters>]

Detailed Description

The Get-QLRSqlTransaction cmdlet reads transactions from an open LogReader object and writes them to a pipeline.

Related Commands

• New-QLRSqlLogReader
• Get-QLRSqlCommand
• Get-QLRSqlRecord

Parameters

Name	Description	Required?	Pipeline Input	Default Value
Reader	The open LogReader object. This object should be created by the New-QLRSqlReader cmdlet.	true	false
After	The first date in the log to read transactions. Log Reader will read all transactions in the log that were active after this date.	false	false
Before	The last date in the log to read transactions. Log Reader will read all transactions in the log that were active before this date.	false	false

Input Type

Quest.LogReader.SqlServer.Wrappers.LogReaderSSWrapper

Return Values

Quest.LogReader.SqlServer.Wrappers.TransactionWrapper

Examples

EXAMPLE 1

$lr = New-SQLSqlReader -Online . Northwind Windows
Get-QLRSqlTransaction $lr

These commands read all transactions in the Northwind database on the local server.

EXAMPLE 2

$lr = New-SQLSqlReader -Online . Northwind Windows
Get-QLRSqlTransaction $lr -After 01.01.2007

These commands read all transactions that was active after 01.01.2007 in the Northwind database on the local server.