Fix bug in data warehouse report for EndPoint Protection
In the SQL query for the datawarehouse Endpoint report the line in the query "ELSE DATEDIFF(day, AntivirusSignatureUpdateDateTime, @Now) " means that there is never more than 7 days worth of data reported in the report. This is because this line says that anything over 7 days is non-compliant because it compares against @now.
A better comparison is against the date the data was entered i.e. "ELSE DATEDIFF(day, AntivirusSignatureUpdateDateTime, am.LastSyncTime_DW)" - which makes it relative to the Sync data rather than the date the report is run.