Page Comparison

...

Additionally, auditing data can be accessed with a SQL query or via the SkySync Web Service. The queries are listed below:

DECLARE @pageindex as Int

Expandcode

title

language	sql

TSQL

(SQL

Server)

query:

Code Block
DECLARE @pageindex as Int = 0;

DECLARE @pageSize as Int

DECLARE @pageSize as Int = 1000;

DECLARE @offset as Int

DECLARE @offset as Int = @pageindex * @pageSize;

WITH CTE AS

WITH CTE AS (

SELECT ID

       SELECT ID, JobID, ExecutionID, IsContainer, IsDirectionSwitched, ConnectionID, Path, DesiredName,

Size

 Size, Version, SourceConnectionID, SourcePath, OperationType, OperationOnTicks, Reason, ROW_NUMBER()

       OVER

OVER (ORDER BY OperationOnTicks DESC

(ORDER BY OperationOnTicks DESC)

r

r FROM TransferAudits

FROM TransferAudits ) SELECT * FROM CTE WHERE r > @offset AND r

) SELECT * FROM CTE WHERE r > @offset AND r <= (@offset + @pageSize);

Omit CTE to query all data: SELECT ID

Expand

title	Omit CTE to query all data:

Code Block

language	sql

SELECTID, JobID, ExecutionID, IsContainer, IsDirectionSwitched, ConnectionID, Path, DesiredName,

Size

 Size, Version, SourceConnectionID, SourcePath, OperationType, OperationOnTicks, Reason

FROM TransferAudits ORDER BY OperationOnTicks DESC

FROMTransferAudits 
ORDERBYOperationOnTicks DESC

Links to retrieve/export the Auditing Data via the SkySync Web Service:

...

Versions Compared