
--Check the imported forecasts for dulles town
SELECT ForecastBasis, * FROm Forecasting.Forecast
WHERE EntityID=671 AND ExternalGenerationDate IS NOT NULL
ORDER BY BusinessDay DESC

--Check the log of web service calls
SELECT * FROM tbAudit a WITH (nolock) WHERE a.AuditDateTime > '3/11/2020' AND a.AuditCategoryID = 23
ORDER BY 1 DESC


--Check the log for import tasks
SELECT * FROM tbAudit a WITH (nolock) WHERE a.AuditDateTime > '3/11/2020' AND a.AuditCategoryID = 3
ORDER BY 1 DESC
