End of Year Report

1. End of Year Report SecurityCenter

2. End of Year Report • Topics Covered • How to install the End of Year report template • How to modify the report template to accurately report quarterly in an end of year report.

3. Install the Report Template • Step 1 - From the reports page, select the report, and click Add. Next, select the Executive category, and choose “End of Year Report” • Step 2 – Click “Add It Now”, and wait for 15 seconds for the report to be added. Next, click “Finish”. • Step 3 – Delete the report, and then re-add the report to account for the chapter order bug.

4. Relative Date Changes • Components Requiring a Change • Table • Matrix • Bar Chart • Pie Chart • Settings to Change • Cumulative • Days Since Discovery (Vulnerability Discovered) • Mitigated Databases • Days Since Mitigation (Vulnerability Mitigated) • Change the Relative Date • Assuming Date the report will run is January 15, each number must be increased by 15.

5. Change Matrix (Cumulative) • Step 1 – From the reports page, select the report and click “Edit” • Step 2 – Click the Definition tab, then choose the Executive Summary Chapter. (Matrices are only in this chapter) • Open the matrix and select a row by holding the mouse key while moving to right. • Click Edit Filter, then go to Date Filters and change the “Vulnerability Discovered” dates.

6. Date Change Example • Day of Year Calculator • http://www.mbari.org/staff/coletti/doytable.html • Helps determine the number of days past January 1. • Assuming the date the report is run were January 17, you would increase the numbers by 17. • Between 288days and 382days ago. • Assuming the date the report is run were February 23, you would increase the numbers by 54. • Between 325 days and 419 days ago.

7. Change Matrix (Mitigated) • Step 1 – From the reports page, select the report and click “Edit” • Step 2 – Click the Definition tab, then choose the Executive Summary Chapter. (Matrices are only in this chapter) • Open the matrix and select a row by holding the mouse key while moving to right. • Click Edit Filter, then go to Date Filters and change the “Vulnerability Mitigated” dates.

8. Change Table (Cumulative) • Step 1 – From the reports page, select the report and click “Edit”. Navigate to the “Definition Tab”, choose a quarter chapter, and expand the section or group • Step 2 – Click the “Edit” button next to the table. • Step 3 – Click “Edit Filter” • Step 4 – Go to Date Filters and change the “Vulnerability Discovered” dates. • Note that this will be required for cumulative table components only.

9. Change Table (Mitigated) • Step 1 – From the reports page, select the report and click “Edit”. Navigate to the “Definition Tab”, choose a quarter chapter, and expand the section or group • Step 2 – Click the “Edit” button next to the table. • Step 3 – Click “Edit Filter” • Step 4 – Go to Date Filters and change the “Vulnerability Mitigated” dates. • Note that this will be required for mitigated table components only.

10. Change Bar Chart (Cumulative) • Step 1 – From the reports page, select the report and click “Edit”. Navigate to the “Definition Tab”, choose a quarter chapter, and expand the section or group • Step 2 – Click the “Edit” button next to the Bar Chart • Step 3 – Click “Edit Filter” • Step 4 – Go to Date Filters and change the “Vulnerability Discovered” dates. • Note that this will be required for cumulative bar chart components only.

11. Change Bar Chart (Mitigated) • Step 1 – From the reports page, select the report and click “Edit”. Navigate to the “Definition Tab”, choose a quarter chapter, and expand the section or group • Step 2 – Click the “Edit” button next to the Bar Chart • Step 3 – Click “Edit Filter” • Step 4 – Go to Date Filters and change the “Vulnerability Mitigated” dates. • Note that this will be required for mitigated bar chart components only.

12. Change Pie Chart (Mitigated) • Step 1 – From the reports page, select the report and click “Edit”. Navigate to the “Definition Tab”, choose a quarter chapter, and expand the group after the “Remediated Vulnerabilities” section. These groups are the only ones with a pie chart. • Step 2 – Click the “Edit” button next to the Bar Chart • Step 3 – Click “Edit Filter” • Step 4 – Go to Date Filters and change the “Vulnerability Mitigated” dates. • Note that this will be required for mitigated pie chart components.

13. For Questions Contact Cody Dumont cdumont@tenable.com