Versions Compared

Version Old Version 4 New Version 5
Changes made by

Josh Lambright

Josh Lambright

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleOmit CTE to query all data:


Code Block
languagesql
SELECTID, JobID, ExecutionID, IsContainer, IsDirectionSwitched, ConnectionID, Path, DesiredName, Size, Version, SourceConnectionID, SourcePath, OperationType, OperationOnTicks, Reason 
FROMTransferAudits 
ORDERBYOperationOnTicks DESC
 


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

...


Retrieve the first 100 audits: 

http://localhost:9000/v1/jobs/executions/audits?sort=OperationOnTicks&desc=true&pageIndex=0&pageSize=100 

 

Retrieve the first 100 audits for job X: 

http://localhost:9000/v1/jobs/X/executions/audits?sort=OperationOnTicks&desc=true&pageIndex=0&pageSize=100 

 

Retrieve the first 100 audits for job X, execution ID of Y: 

http://localhost:9000/v1/jobs/X/executions/Y/audits?sort=OperationOnTicks&desc=true&pageIndex=0&pageSize=100 

 

Export all audits: 

http://localhost:9000/v1/jobs/executions/audits.csv 

 

Export all audits for job X: 

http://localhost:9000/v1/jobs/X/executions/audits.csv 

 

Export all audits for job X, execution ID of Y: 

http://localhost:9000/v1/jobs/X/executions/Y/audits.csv 

 

To query failures, use the previous three queries, substituting "failures.csv" for "audits.csv".

For example, to export all failures for job X, execution ID of Y: 

http://localhost:9000/v1/jobs/X/executions/Y/failures.csv 


 

For these queries, the "pageSize" default and maximum are both 100. 

...