Out-QLRSqlHtml

From PowerGUI Wiki

Exports data in HTML format.

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

Syntax

Out-QLRSqlHtml [[-Output] [<String>]] [-InputObject [<PSObject[]>]] [-Full] [<CommonParameters>]

Detailed Description

The Out-QLRSqlHtml cmdlet exports input objects in HTML format. The valid input objects are: - DML/DDL command descriptors - Log record descriptors - Transaction descriptors.

Related Commands

• New-QLRSqlReader
• Get-QLRSqlCommand
• Get-QLRSqlRecord
• Get-QLRSqlTransaction
• Out-QLRSqlCsv
• Out-QLRSqlXml
• Out-QLRSqlDatabase

Parameters

Name	Description	Required?	Pipeline Input	Default Value
Output	The file where to save the output. If this parameter is not set, output will be written to a pipeline as strings, one string per line.	false	false
InputObject	Objects that will be exported. Can be results of one of the following cmdlets: - Get-QLRSqlCommand - Get-QLRSqlTransaction - Get-QLRSqlRecord	false	true (ByValue)
Full	Set this parameter to include additional properties to the output. Note: Setting of this parameter may slow down the exporting process.	false	false

Input Type

Quest.LogReader.SqlServer.Wrappers.CommandWrapper, Quest.LogReader.SqlServer.Wrappers.TransactionWrapper, Quest.LogReader.SqlServer.Wrappers.RecordWrapper

Return Values

String if Output parameter is not set or None elsewhere.

Examples

EXAMPLE 1

$lr = New-QLRSqlReader –Online . Northwind Windows
Get-QLRSqlCommand $lr Out-QLRSqlHtml C:\out.htm
$lr.Close()

This commands open the online transaction log for the Northwind database on a local server. Then all DML/DDL commands are exported into C:\out.htm file in html format.