Follow by Email

Thursday, 9 January 2014

Custom SCEP Endpoint Protection Reports to UTC +8 timezone

As these reports have a lot of internal links to the other reports. If during your test, you notice the report is not linked to the customized reports, please follow the below steps to change it:

1. open the customized rdl file with notepad

2. search for the keyword ReportName

3. change the value according to the value in your environment as below.  

<ReportName>Endpoint Protection - Hidden/Customized Computer malware list</ReportName>

4. save the change and import the rdl file and replace to previous customized one.

If you notice there is some report which is needed to change the time to UTC+8, please follow the below steps to do:

1. Export the report and import it as customized report.

2. Use report builder to open the customized report.

3. Go to Datasets as below:

clip_image001

4. By default, the StartDate and EndDate is set to use UTC time. To change them to UTC+8, please right click StartEndDates-> Dataset Properties as below

clip_image002

5. In the query, please change the GetUTCDate() to be GetDate() as below:

clip_image003

6. Click OK to save the change.

7. Similarly, for the TopUsersByThreats of the Customized Top users by threat, if we would like to change the FirstIncident and Last Incident to the UTC+8 time, please change it as below:

clip_image004

8. After that, please change the display name to be UTC +8 as below:

clip_image005

9. Save the change and test it report.

Additional information for report builder:

Report Builder Help for SQL Server 2012

http://technet.microsoft.com/en-us/library/hh965699.aspx

SQL Server 2008 R2 Report Builder 3.0

http://technet.microsoft.com/en-us/library/dn425067(v=sql.10).aspx

Building Custom Endpoint Protection Reports in System Center 2012 Configuration Manager

http://blogs.technet.com/b/configmgrteam/archive/2012/03/28/building-custom-endpoint-protection-reports-in-system-center-2012-configuration-manager.aspx

No comments:

Post a Comment