Edit

Get-AzureRmSqlSyncGroupLog

  • Reference
Module:
AzureRM.Sql

Returns the logs of an Azure SQL Database Sync Group.

Important

Because Az PowerShell modules now have all the capabilities of AzureRM PowerShell modules and more, we'll retire AzureRM PowerShell modules on 29 February 2024.

To avoid service interruptions, update your scripts that use AzureRM PowerShell modules to use Az PowerShell modules by 29 February 2024. To automatically update your scripts, follow the quickstart guide.

Syntax

Get-AzureRmSqlSyncGroupLog
   [-SyncGroupName] <String>
   -StartTime <DateTime>
   [-EndTime <DateTime>]
   [-LogLevel <String>]
   [-ServerName] <String>
   [-DatabaseName] <String>
   [-ResourceGroupName] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Description

The Get-AzureRmSqlSyncGroupLog cmdlet returns the logs of an Azure SQL Database Sync Group.

Examples

Example 1: Get the logs of an Azure SQL Sync Group

PS C:\>Get-AzureRmSqlSyncGroupLog -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -SyncGroupName "SyncGroup01" -StartTime "9/16/2016 11:31:12" -EndTime "9/16/2016 12:31:00" -LogLevel "All"
TimeStamp            LogLevel Details                                   Source
---------            -------- -------                                   ------
6/13/2017 9:14:26 AM Success  Schema information obtained successfully. fangltest2.database.windows.net/fangltest
6/13/2017 7:11:59 AM Success  Schema information obtained successfully. fangltest2.database.windows.net/fangltest

This command gets the logs of an Azure SQL Sync Group.

Parameters

-DatabaseName

The name of the Azure SQL Database.

Type:String
Position:2
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-DefaultProfile

The credentials, account, tenant, and subscription used for communication with azure

Type:IAzureContextContainer
Aliases:AzureRmContext, AzureCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-EndTime

The end time of the logs to query.

Type:DateTime
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-LogLevel

The type of the logs to query. Valid values are: 'Error', 'Warning', 'Success' and 'All'.

Type:String
Accepted values:Error, Warning, Success, All
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ResourceGroupName

The name of the resource group.

Type:String
Position:0
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-ServerName

The name of the Azure SQL Server.

Type:String
Position:1
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-StartTime

The start time of the logs to query.

Type:DateTime
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-SyncGroupName

The sync group name.

Type:String
Aliases:Name
Position:3
Default value:None
Accept pipeline input:True
Accept wildcard characters:False

Inputs

String

Outputs

AzureSqlSyncGroupLogModel