Spreadsheet: 70295d1271089592-how-to-concatenate-a-dynamic-list-of-cells-but-only-concatenate-unique-entries-724394-how-to-concatenate-a-dynamic-list-of-cells-but-only-concatenate-unique-entries-new-post-e
Sheet: App Protection Activities

 |  |  |  |  |  |  |  |  | Old
 | 666 | Application Protection Activity Assessments
 |  | AP Activity (1) | Application |  | Protection Activity |  |  | AP Activity (2)
 | Item # | Application-Protection Activity Name | Name | DR Team Role Responsible | Name | Description ("With respect to this app, do [WHAT]") | DR Team Role Responsible | DR Team RoleS Responsible | [NAME] [NAME] | DRP | DR | DRM Role Responsible | Last Assessed yyyy-mm-dd | Marked for Deletion [NAME]
 | 1 | AVM 2.6.1 Approve change management changes | AVM 2.6.1 | VB Application Specialist | Approve change management changes | Approve Changes that affect the DRP with respect to the Change Management process | *DRM | VB Application Specialist, *DRM | 2010-03-24 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2010-03-23 00:00:00
 | 2 | AVM 2.6.1 Approve project management changes | AVM 2.6.1 | VB Application Specialist | Approve project management changes | Approve Changes that affect the DRP with respect to the Project Management process | *DRM | VB Application Specialist, *DRM | 2010-03-24 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2010-03-24 00:00:00
 | 3 | AVM 2.6.1 Check agreements protected | AVM 2.6.1 | VB Application Specialist | Check agreements protected | Check that originals or copies of licence and support agreements are safely stored offsite. | Procurement Specialist | VB Application Specialist, Procurement Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 4 | AVM 2.6.1 Check asset register backup | AVM 2.6.1 | VB Application Specialist | Check asset register backup | Check there are regular daily back-ups of the asset register | Asset Management Specialist | VB Application Specialist, Asset Management Specialist | 2008-11-26 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 5 | AVM 2.6.1 Check asset register up-to-date | AVM 2.6.1 | VB Application Specialist | Check asset register up-to-date | Check that the asset register is up-to-date, including continuing accuracy of description, type, physical location, IP address, asset owner and serial numbers of all equipment, maintenance contract number and asset-life expiry date | Asset Management Specialist | VB Application Specialist, Asset Management Specialist | 2008-12-16 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 6 | AVM 2.6.1 Check backup media drive | AVM 2.6.1 | VB Application Specialist | Check backup media drive | Check storage media listed on these documents remains readable on an alternative tape drive to that used to write the tape | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 7 | AVM 2.6.1 Check backup media location | AVM 2.6.1 | VB Application Specialist | Check backup media location | Check back-up media remain present & available, at primary site and off site media store, on the right shelf, suitably labelled | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 8 | AVM 2.6.1 Check backup media readability | AVM 2.6.1 | VB Application Specialist | Check backup media readability | Check storage media listed on these documents remains readable by restoring an individual tape and calculating the checksum | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 9 | AVM 2.6.1 Check backup media sanitization | AVM 2.6.1 | VB Application Specialist | Check backup media sanitization | Check recently released back-up tapes to ensure they have been securely wiped before being returned to the available tape pool | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 10 | AVM 2.6.1 Check backup media state | AVM 2.6.1 | VB Application Specialist | Check backup media state | Check storage media is undamaged and untampered with | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 11 | AVM 2.6.1 Check backup report | AVM 2.6.1 | VB Application Specialist | Check backup report | Check back up media picking documents have been produced and stored correctly | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 12 | AVM 2.6.1 Check backup software secure | AVM 2.6.1 | VB Application Specialist | Check backup software secure | Ensure back up software is not tampered with, by comparing the object code byte-by-byte with a certified reference version | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 13 | AVM 2.6.1 Check backup software supported | AVM 2.6.1 | VB Application Specialist | Check backup software supported | Ensure back up software is subject to support contract with the vendor | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 14 | AVM 2.6.1 Check backup software up-to-date | AVM 2.6.1 | VB Application Specialist | Check backup software up-to-date | Ensure back up software is up-to-date, including patches | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-10-01 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 15 | AVM 2.6.1 Check backup storage protected | AVM 2.6.1 | VB Application Specialist | Check backup storage protected | Check if the backup storage areas fire protected? | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-12-18 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 16 | AVM 2.6.1 Check backup storage secure | AVM 2.6.1 | VB Application Specialist | Check backup storage secure | Check if the backup storage areas secure as to access. | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-12-01 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 17 | AVM 2.6.1 Check business processes protected | AVM 2.6.1 | VB Application Specialist | Check business processes protected | Ensure that the appropriate data, operating systems & documentation concerned with processes vital to your business are identified. |  | VB Application Specialist, | 2008-06-01 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 18 | AVM 2.6.1 Check contract renewals | AVM 2.6.1 | VB Application Specialist | Check contract renewals | Review service agreement renewal calendar to ensure that maintenance contracts are being promptly renewed | Procurement Specialist | VB Application Specialist, Procurement Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | n/a
 | 19 | AVM 2.6.1 Check contract database backup | AVM 2.6.1 | VB Application Specialist | Check contract database backup | Check that there are regular daily back-ups of the support contract database | Procurement Specialist | VB Application Specialist, Procurement Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | n/a
 | 20 | AVM 2.6.1 Check contracts up-to-date | AVM 2.6.1 | VB Application Specialist | Check contracts up-to-date | [NAME] that the support contract database is up-to-date including equipment in scope, maintainers contract number, hours of cover, contract restrictions and expiry date | Procurement Specialist | VB Application Specialist, Procurement Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 21 | AVM 2.6.1 Check data protected | AVM 2.6.1 | VB Application Specialist | Check data protected | Check that there are backups of the data kept offsite.  Where? | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 22 | AVM 2.6.1 Check full system image | AVM 2.6.1 | VB Application Specialist | Check full system image | Ensure there a full system image, aka boot tape | Backup Operations Specialist | VB Application Specialist, Backup Operations Specialist |  | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 23 | AVM 2.6.1 Check insurance policies protected | AVM 2.6.1 | VB Application Specialist | Check insurance policies protected | Check that originals or copies of insurance policies are safely stored offsite. | VB Application Specialist | VB Application Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 24 | AVM 2.6.1 Check internal manuals protected | AVM 2.6.1 | VB Application Specialist | Check internal manuals protected | Check if backup copies of Operating Instructions and Documentation are kept? Where? How? | VB Application Specialist | VB Application Specialist |  | BBT SMB DRP | BBT SMB DR | *DRM
 | 25 | AVM 2.6.1 Check license keys protected | AVM 2.6.1 | VB Application Specialist | Check license keys protected | Check that originals or copies of registration and software licence keys are safely stored offsite. | VB Application Specialist | VB Application Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 26 | AVM 2.6.1 Check object code integrity | AVM 2.6.1 | VB Application Specialist | Check object code integrity | Check the integrity of the object code libraries by use of checksums | VB Application Specialist | VB Application Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 27 | AVM 2.6.1 Check OS media protected | AVM 2.6.1 | VB Application Specialist | Check OS media protected | Check that backup copies of operating systems are kept offsite. Where? | Wintel Specialist | VB Application Specialist, Wintel Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 28 | AVM 2.6.1 Check pre-printed stationery protected | AVM 2.6.1 | VB Application Specialist | Check pre-printed stationery protected | Check that originals or copies of pre-printed stationery, forms & paper supplies pertaining are safely stored offsite. |  | VB Application Specialist, | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 29 | AVM 2.6.1 Check Primary Site environment | AVM 2.6.1 | VB Application Specialist | Check Primary Site environment | Check physical and environmental controls at Primary Site. | Facility Specialist | VB Application Specialist, Facility Specialist | 2008-12-18 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 30 | AVM 2.6.1 Check restore access rights | AVM 2.6.1 | VB Application Specialist | Check restore access rights | Check the access rights are valid for at least a sample of the user base on a restored database. | VB Application Specialist | VB Application Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 31 | AVM 2.6.1 Check restore integrity | AVM 2.6.1 | VB Application Specialist | Check restore integrity | Check all or part of an application’s data can be restored from the tapes, calculating a checksum and ensuring this matches the checksum of the original application. | VB Application Specialist | VB Application Specialist | 2008-11-25 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2008-11-25 00:00:00
 | 32 | AVM 2.6.1 Check software register | AVM 2.6.1 | VB Application Specialist | Check software register | Ensure there is an *offsite* register of all software components (including firmware, device drivers, custom software, and operating system settings.  This should also include appropriate data, operating systems, where installed and relationships between | VB Application Specialist | VB Application Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 33 | AVM 2.6.1 Check vendor manuals protected | AVM 2.6.1 | VB Application Specialist | Check vendor manuals protected | Check that originals or copies of user, operator, & administrator manuals are safely stored offsite. | VB Application Specialist | VB Application Specialist | 2008-11-27 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM
 | 34 | AVM 2.6.1 Ensure passwords stored offsite | AVM 2.6.1 | VB Application Specialist | Ensure passwords stored offsite | Identify all system passwords necessary in an emergency, and arrange for a sealed envelope with these passwords to be included at a central place | VB Application Specialist | VB Application Specialist |  | BBT SMB DRP | BBT SMB DR | *DRM
 | 35 | AVM 2.6.1 Review DRP | AVM 2.6.1 | VB Application Specialist | Review DRP | Review of the DRP (eg Confirming the names and ongoing availability of all Primaries & Secondaries) | *DRM | VB Application Specialist, *DRM | 2010-01-18 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2010-03-24 00:00:00
 | 36 | AVM 2.6.1 Test DRP | AVM 2.6.1 | VB Application Specialist | Test DRP | Conduct a DR test | *DRM | VB Application Specialist, *DRM | 2010-01-18 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM | 2010-03-24 00:00:00
 | 37 | AVM 2.6.1 Test UPS | AVM 2.6.1 | VB Application Specialist | Test UPS | Test UPS supply to confirm it still operates for the planned duration and that all equipment and peripherals can be tidily closed down in this period | Facility Specialist | VB Application Specialist, Facility Specialist | 2008-12-18 00:00:00 | BBT SMB DRP | BBT SMB DR | *DRM