OpsCenter common custom reports
Published 10 years ago
Version 1.0Was this article helpful?
try replacing this
AND ( ( (UTCBigIntToNomTime(domain_JobArchive.endTime) BETWEEN 'January 20 2016' and 'February 3 2016') ))
with
AND DATEDIFF(DAY,UtcBigIntToNomTime(domain_JobArchive.endTime),GETDATE())<=14
this should get you everything that has run in the past 14 days