Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

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.

1 vote
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
TheCurse shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base