Get-QLRSqlRecord

From PowerGUI Wiki

Reads log records.

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-QLRSqlRecord [-Reader] <LogReaderSSWrapper> [-After [<DateTime>]] [-Before [<DateTime>]] [<CommonParameters>]

Detailed Description

The Get-QLRSqlRecord cmdlet reads log records from the open LogReader and writes them to a pipeline.

Related Commands

• New-QLRSqlReader
• Get-QLRSqlCommand
• Get-QLRSqlTransaction

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 records. Log Reader will read all records in the log that were added after this date.	false	false
Before	The last date in the log to read records. Log Reader will read all records in the log that were added before this date.	false	false

Input Type

Quest.LogReader.SqlServer.Wrappers.LogReaderSSWrapper

Return Values

Quest.LogReader.SqlServer.Wrappers.RecordWrapper

Examples

EXAMPLE 1

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

These commands read all log records in the transaction log of the Northwind database on the local server.

EXAMPLE 2

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

These commands read all log records added to the transaction log of the Northwind database on the local server after 01.01.2007.