sync_groups_logs

Creates, updates, deletes, gets or lists a sync_groups_logs resource.

Overview

Name	sync_groups_logs
Type	Resource
Id	azure.sql.sync_groups_logs

Fields

The following fields are returned by SELECT queries:

list

Successfully retrieved sync group logs.

Name	Datatype	Description
details	string	Details of the sync group log.
operationStatus	string	OperationStatus of the sync group log.
source	string	Source of the sync group log.
timestamp	string (date-time)	Timestamp of the sync group log.
tracingId	string (uuid)	TracingId of the sync group log.
type	string	Type of the sync group log.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	resourceGroupName, serverName, databaseName, syncGroupName, startTime, endTime, type, subscriptionId	continuationToken	Gets a collection of sync group logs.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
databaseName	string	The name of the database on which the sync group is hosted.
endTime	string	Get logs generated before this time.
resourceGroupName	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName	string	The name of the server.
startTime	string	Get logs generated after this time.
subscriptionId	string	The subscription ID that identifies an Azure subscription.
syncGroupName	string	The name of the sync group.
type	string	The types of logs to retrieve.
continuationToken	string	The continuation token for this operation.

SELECT examples

list

Gets a collection of sync group logs.

SELECT
details,
operationStatus,
source,
timestamp,
tracingId,
type
FROM azure.sql.sync_groups_logs
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND syncGroupName = '{{ syncGroupName }}' -- required
AND startTime = '{{ startTime }}' -- required
AND endTime = '{{ endTime }}' -- required
AND type = '{{ type }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND continuationToken = '{{ continuationToken }}'
;