Reporting on failed cloud sync status

[joelnewton]

Hi. I'm trying to create a report that will tell me if syncing to the cloud has failed for more than X hours. 

Where is the sync status data stored in SQL so I can use it for my report? Thank you.

[DavidPK]

Hi Joel,

In a Classic hybrid installation (on‑prem Lansweeper Database syncing to the Lansweeper Platform), the cloud sync data is stored in the Lansweeper Database in:
dbo.tsysLastCloudSyncDates: last successful sync timestamp (LastScanSyncDate) 
dbo.tsysLastCloudSyncDates.md
dbo.tsysCloudProcessesStatus: per sync job status and timestamp (JobID, Status, Date)